Advanced Excel Using AI Agents 2026 (On-Demand - CPABC)
Former Title: Advanced Excel Using AI for Accountants
Overview
This course is a completely updated version of our prior 2024 course. Re-engineered from the ground up, it transitions from basic conversational prompting to autonomous, model-directed spreadsheet control.
In 2024, AI in Excel was conversational—we treated tools like ChatGPT or Copilot as clever assistants, copying and pasting formulas from chat panels into our spreadsheets. In 2026, the technology has undergone a fundamental, paradigm-shifting evolution. We are no longer working with passive assistants; we are deploying autonomous AI agents with direct write, edit, and execution permissions over live spreadsheet grids. Modern agents dynamically plan multi-step workflows, execute sandboxed Python code, pull live market data from SEC filings and institutional databases, and audit their own outputs in real time.
Watch a short promotional video of the course here:
Access expires 180 days from purchase date |
Course Description
Crucially, this course goes beyond vendor hype. In Section 3, you’ll witness a side-by-side 'Battle of the Excel Agents,' stress-testing all four platforms against a complex financial model with thousands of calculations and multi-jurisdictional tax rules. You’ll learn how to establish pre-flight controls, ring-fence inputs, and enforce CPA Code Rules 208 (Confidentiality) and 218 (Working-Paper Documentation) so you can audit every output and lead your practice with complete confidence.
Applicable for
Learning Objectives
- Deploy Autonomous Agents: Transition from manual formula entry to model-directed workbook execution.
- Match Agents to Tasks: Select the optimal platform (Copilot, ChatGPT/Codex, Claude, or Perplexity) for specific workflows.
- Ring-Fence Financial Models: Structure sheets and isolate input assumptions to guarantee error-free AI runs.
- Operationalize CPA Controls: Implement pre-flight risk checks, plan mode supervision, and 30-day firm rollouts.
- Audit & Verify Outputs: Detect agent failure modes including circular references, hard-coded plugs, and stale tax data.
Course Content Created: November 2024
Course Content Updated: September 2026
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.Presenter
David Trahair, CPA, CAAbout This Product
CPABC On-Demand Courses offer self-paced learning through recorded sessions from previously delivered live seminars. Where available, accompanying materials such as handouts or course notes are included. On-demand courses are eligible for verifiable CPD hours upon successful completion, and a certificate will be made available for download for your records.
Please note that not all on-demand courses include downloadable materials such as handouts, course notes or presentation slides.
How to get started
After completing your purchase, go to mylms.bccpa.ca. Log in using your CPABC Online Services credentials. Click Go to Your Courses and Materials to access your Learning Center. Select your course title to begin.
Course Dates & Registration
- 2.5
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 4
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Advanced Excel Using AI Agents 2026 (On-Demand - CPABC)
Former Title: Advanced Excel Using AI for Accountants
- 2.5
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 4
- Credits
Overview
This course is a completely updated version of our prior 2024 course. Re-engineered from the ground up, it transitions from basic conversational prompting to autonomous, model-directed spreadsheet control.
In 2024, AI in Excel was conversational—we treated tools like ChatGPT or Copilot as clever assistants, copying and pasting formulas from chat panels into our spreadsheets. In 2026, the technology has undergone a fundamental, paradigm-shifting evolution. We are no longer working with passive assistants; we are deploying autonomous AI agents with direct write, edit, and execution permissions over live spreadsheet grids. Modern agents dynamically plan multi-step workflows, execute sandboxed Python code, pull live market data from SEC filings and institutional databases, and audit their own outputs in real time.
Watch a short promotional video of the course here:
Access expires 180 days from purchase date |
Course Description
Crucially, this course goes beyond vendor hype. In Section 3, you’ll witness a side-by-side 'Battle of the Excel Agents,' stress-testing all four platforms against a complex financial model with thousands of calculations and multi-jurisdictional tax rules. You’ll learn how to establish pre-flight controls, ring-fence inputs, and enforce CPA Code Rules 208 (Confidentiality) and 218 (Working-Paper Documentation) so you can audit every output and lead your practice with complete confidence.
Applicable for
Learning Objectives
- Deploy Autonomous Agents: Transition from manual formula entry to model-directed workbook execution.
- Match Agents to Tasks: Select the optimal platform (Copilot, ChatGPT/Codex, Claude, or Perplexity) for specific workflows.
- Ring-Fence Financial Models: Structure sheets and isolate input assumptions to guarantee error-free AI runs.
- Operationalize CPA Controls: Implement pre-flight risk checks, plan mode supervision, and 30-day firm rollouts.
- Audit & Verify Outputs: Detect agent failure modes including circular references, hard-coded plugs, and stale tax data.
Course Content Created: November 2024
Course Content Updated: September 2026
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.Presenter
David Trahair, CPA, CAAbout This Product
CPABC On-Demand Courses offer self-paced learning through recorded sessions from previously delivered live seminars. Where available, accompanying materials such as handouts or course notes are included. On-demand courses are eligible for verifiable CPD hours upon successful completion, and a certificate will be made available for download for your records.
Please note that not all on-demand courses include downloadable materials such as handouts, course notes or presentation slides.
How to get started
After completing your purchase, go to mylms.bccpa.ca. Log in using your CPABC Online Services credentials. Click Go to Your Courses and Materials to access your Learning Center. Select your course title to begin.
Course Dates & Registration
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.