Transform your practice with AI-powered research, automated agents, and intelligent document analysis.
NEW NOVEMBER 2026 EDITION: This course is a completely updated version of our 2025 course, and it is as current as an AI course can be. It was updated in November 2026 and even includes the federal government’s Budget 2026, tabled on November 5, 2026. You’ll watch an AI browser compare the 532-page budget document with KPMG and PwC analyses and summarize the tax proposals most relevant to small businesses and their owners, with sources cited.
In 2025, most AI tools for accountants were assistants: you asked a question and got an answer back. In 2026, AI has moved from assistant to coworker. In April 2026, Copilot’s agent capabilities became the default in Word, Excel and PowerPoint. Anthropic, OpenAI and Perplexity now all offer agents that work directly inside Excel. And new AI coworkers such as Claude Cowork and Copilot Cowork take on whole multi-step tasks across your files and apps, then hand back finished work for you to review.
This practical course shows Canadian CPAs ten everyday ways to put these tools to work right now, each demonstrated step by step in the real applications: learning with Gemini Notebook (formerly NotebookLM) and Copilot Notebooks, automating with Microsoft 365 agents, Excel using AI agents, an agent in your browser with Perplexity’s Comet, writing and replying, deep research, strategic planning, document analysis, email management in Outlook and Gmail, and AI coworkers.
Crucially, this course goes beyond vendor hype. You’ll get the results of a head-to-head test from our Advanced Excel Using AI Agents course, in which four Excel agents updated a retirement spreadsheet’s tax figures, and the lessons it taught: supervise every run, and remember that even official sources can be out of date. You’ll watch Claude Cowork organize a fictional client’s 21 year-end documents. And you’ll learn the professional controls every CPA needs: checking citations, working on copies, and knowing where confidential client data is processed.
WHO WILL BENEFIT
Canadian CPAs and accounting professionals in public practice, industry and education who want practical, current and responsible ways to use AI right now to save time, improve accuracy and serve clients better.
5 activities • 4 videos • duration: 2h 45m

Acclaimed Author and On-demand Course Developer
David Trahair, CPA, CA, is an author 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.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.