CPD · Foundation courses
Excel with AI
Faster spreadsheets with AI help, with every number still checked.
- 4 modules
- 4 marked written tasks of 450 to 850 words
- Pass at 80
- Facts checked 1 November 2026
- Yours to keep, no end date
- Certificate when every module passes
Who it's for
Anyone who builds or reviews spreadsheets.
The modules
Module 1
Using AI to write and explain formulas, and checking them
Get an AI assistant to write or explain a formula, then prove it works with a small test case that has known answers and awkward edge cases.
- Objective:
- To be able to use an AI assistant to write and explain Excel formulas, test them against a case with known answers, and correct the common errors AI-written formulas contain.
- Marked task:
- Work out the expected answer for each formula on the test case, and say whether each formula passes or fails.
- What the marker looks for:
- Tests each formula against the case (30), Diagnoses and fixes the failures (30), Spots design weaknesses in the passing formulas (20), Keeps evidence and plans the live check (20)
Module 2
AI features in Excel (Copilot, Python in Excel, data cleaning) and their limits
What the AI features inside spreadsheets can do as of November 2026, where they fall short, and how to prove what an AI did to your data.
- Objective:
- To be able to explain what AI features in spreadsheets do to data, recognise their limits, and verify and document AI-assisted data cleaning so a reviewer can rely on it.
- Marked task:
- Explain to Owen what the AI did to the dataset, step by step, in plain terms.
- What the marker looks for:
- Explains what the AI did (20), Reconciles and verifies the data (30), Corrects the cleaning decisions (30), Explains tool limits and documentation (20)
Module 3
Building a model with AI help without losing control
Use AI to speed up building a forecast model while keeping the structure, assumptions and checks you need to review and defend it.
- Objective:
- To be able to build or review an AI-assisted financial model so that its structure, assumptions and checks can be followed, tested and relied on, and to write clear review notes on it.
- Marked task:
- Write review notes on the model, ranked by impact. For each point give the location, the problem, its likely effect and the fix.
- What the marker looks for:
- Finds and ranks the issues (30), Quantifies effects and gives fixes (25), Tests the model properly (20), Concludes and records the AI's part (25)
Module 4
Spreadsheet risk: version control, hidden errors and evidence for audit
Controls for spreadsheets that AI tools can now edit: versions, access, locked inputs, check totals, change logs and the evidence an auditor will ask for.
- Objective:
- To be able to set proportionate controls for a team spreadsheet that AI tools edit, covering version control, hidden errors and the evidence needed for review and audit.
- Marked task:
- Set out the controls for the workbook covering access, version control, AI use, structure and checks. Explain why each is needed.
- What the marker looks for:
- Sets proportionate controls (30), Records and reviews AI edits (25), Prepares audit evidence (25), Sets limits and a review (20)
In every module
- A short written lesson, with its sources
- A quiz to check the ideas
- A written task, marked against a grid, with feedback. Pass at 80
- A reflection, and Copy for CPD record
A certificate for the course once every module is at 80 or more. Built for your CPD record.
Labs with this course
This course comes with the Excel matching with AI lab.
How it's marked
Your answer is marked by an AI model against the grid for the task, whose parts and marks are listed above for each module. Each part is judged Not shown, Partly, Mostly or Fully, and the mark is worked out from the grid's weights. A CIMA-qualified (CGMA) moderator checks a sample of marks and can add a note. Under 80, read the feedback and try again; your best mark counts.
See a marked task in full: the grid, an answer and its feedback
Price
£39
Or every course, track and lab for 365 days with the CPD year, £199. Or CPD monthly, £19.99 a month, cancel any time. Every lesson, plus 8 marked tasks a month, across every course, role track and lab.
More in AI, data and Excel foundations
- Data security and governance for AI in finance
- AI basics for finance: Claude, ChatGPT, Copilot and Gemini
- AI in finance
On the path for using ai in finance.
Buying for a team
Seats by invoice or purchase order, with a manager report. See CPD for employers.