Beyond Formulas: AI-Driven Excel Mastery for Accountants
This course provides Canadian CPAs with actionable insights to become Excel power users with the assistance of AI—enabling faster, smarter work without the burden of detailed technical learning.
It’s not just another Excel workshop focused on memorizing complex formulas. Instead, it empowers you to use AI tools that simplify and streamline your work, from data analysis to creating financial models. You’ll learn to collaborate with AI as a productivity partner, enhancing your efficiency and reducing the time you spend on repetitive Excel tasks.
Throughout the course, you’ll dive into the capabilities of AI platforms including Microsoft Copilot, ChatGPT, Perplexity and Google Gemini. These tools can instantly provide formula solutions, automate data transformations, and generate insightful data visualizations—all tailored for accounting professionals. You’ll see how to leverage these tools for tasks such as analyzing large datasets, calculating rates of return, and automating report and chart generation, with minimal reliance on manual formula input.
By focusing on real-world applications, this course offers CPAs practical skills to make Excel an even more powerful tool for financial analysis and decision-making. Each module is designed to be practical and immediately applicable, showing how AI can transform how you work with Excel to make data-driven decisions confidently.
Writer, Trainer, On-demand Course Developer and Acclaimed Author
David Trahair, CPA, CA, is an author, trainer, and eLearning developer who creates on-demand video courses for CPAs across Canada. His courses cover topics including personal finance, ethics, AI, and Microsoft Excel. David is also the author of six personal finance books, three of which are national bestsellers. Through his firm, he helps CPAs build practical skills through engaging, self-paced learning.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
