Skip to content

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

  1. 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)
  2. 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)
  3. 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)
  4. 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

All 4 courses in this topic

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.

Back to every course