Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
  1. Courses
  2. /Accounting & Tax
  3. /Technology for Accountants

Advanced Excel Using AI Agents 2026

Master autonomous spreadsheet agents while maintaining professional audit standards and financial integrity.

Created byDavid Trahairworkspace_premiumBest Instructor
AdvancedUpdated Oct 7, 2026

What You'll Learn

  • check_circleDistinguish between passive AI assistants and autonomous spreadsheet agents
  • check_circleApply preflight risk controls and workbook preparation habits for AI-assisted modeling
  • check_circleEvaluate the auditability and data provenance of different AI agent platforms
  • check_circleImplement verification procedures for AI-generated formulas and external data ingestion
  • check_circleMaintain professional liability and documentation standards under CPA codes of conduct

About This Course

This course provides a comprehensive framework for integrating autonomous AI agents into professional accounting and financial modeling workflows. It covers the transition from passive AI assistants to agentic systems capable of planning, executing Python code, and performing live data ingestion within Microsoft Excel.

The curriculum details the operational capabilities of four primary platforms—Microsoft Copilot, OpenAI ChatGPT/Codex, Anthropic Claude, and Perplexity—while emphasizing the non-negotiable requirement for human supervision, professional skepticism, and rigorous audit controls. Participants learn to implement preflight risk controls, manage data security, and verify agent-generated outputs against primary sources to meet CPA professional conduct standards.

Topics Covered:

  • Autonomous agentic vs. passive assistant workflows
  • Microsoft Copilot enterprise governance and Python execution
  • OpenAI ChatGPT and Codex local sandbox execution
  • Anthropic Claude cell-level audit and trace capabilities
  • Perplexity web-grounded financial research connectors
  • Workbook preparation and structural ring-fencing
  • CPA professional standards and audit documentation
  • Risk management for mid-year statutory tax changes

Course Content

9 activities • 8 videos • duration: 2h 34m

remove
Introduction1 videos • 5 min
  • videocamIntroduction to Agentic AI in Excel
    Duration 5:43
add
Working with Excel AI Agents1 videos • 29 min
add
Copilot in Excel1 videos • 24 min
add
ChatGPT for Excel and Codex1 videos • 24 min
add
Claude for Excel1 videos • 20 min
add
Perplexity and Spreadsheets1 videos • 18 min
add
Battle of the Excel Agents1 videos • 24 min
add
Conclusion1 videos • 6 min
add
Final Assessment1 quiz

Your Instructor

David Trahair

Acclaimed Author and On-demand Course Developer

menu_book39 courses
star13,050 reviews

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.

Credit Information

Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.

What Students Are Saying

4.9 out of 5
Student's Choice
12 reviews
  • ZS
    Ziying S.
    starstarstarstarstar

    Very informative

  • AR
    Andrew R.
    starstarstarstarstar

    Too technical when you have not been exposed to some of the agents/software

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(560 reviews)
    2 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(647 reviews)
    2.5 CPD hrs
  • Finance: NASBA - Finance

    Sensitivity Analysis and Scenario Planning

    starRated5.0out of 5,(143 reviews)
    1.5 CPD hrs