Transform the way you use Excel. This practical course shows accountants how to harness AI to simplify complex formulas, automate recurring reports and build audit-ready models using modern Excel tools. Learn to prompt AI effectively, validate outputs and design structured, reliable spreadsheets that save time while maintaining accuracy, control and professional standards.

Ransomware is now a matter of “when” not “if.” This practical course is designed for accountants and finance professionals who play a critical role in risk management, governance, and operational continuity. Delivered by legal and cyber experts, the session blends real-world case studies, actionable insights, and proven strategies to help you: Protect financial data Prepare for and respond to cyber incidents Understand legal and regulatory obligations Build cyber resilience across your finance function Whether you’re in practice or industry, this course will equip you to identify vulnerabilities, support your organisation’s cyber strategy, and become a security-aware leader in your team.

This course introduces two of the most powerful Excel 365 reporting and analysis tools - Power Query and Power Pivot, using them to produce an Excel Dashboard. We will examine Excel tools for ‘What if’ and newer techniques in the very important data analysis areas of LOOKUP (especially XLOOKUP) and FILTERING. Finally, we will use the Excel Dashboard we have created to communicate the results via exchanges between Excel and PowerPoint.

This Excel Intermediate course is designed to extend participants’ knowledge and proficiency in MS Excel by focusing on a wide range of key functions, tools and analytical techniques. The course aims to enhance learners’ ability to utilise Excel effectively for data management, analysis and presentation and introduces using AI tools to get into deeper data analysis.

Advances in AI coupled with modern features in PowerPoint greatly simplify creating eye-catching and informative presentations. Effective usage of Copilot or ChatGPT cuts the time and manual input required for presenting and reporting on data for regular meetings, ad-hoc assignments or regulatory requirements. This hands-on course will guide you through using AI Tools with Microsoft 365 to efficiently and professionally present information.