Skip to content

CPD · Role tracks

Data skills for accountants

Cleaning and checking data, reading dashboards critically, and picking the right tool.

  • 3 modules
  • 3 marked written tasks of 450 to 800 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.

The modules

  1. Module 1

    Cleaning and checking data

    How to check a data extract before you use it, fix the common problems in repeatable steps, and prove the cleaned data still agrees to the source.

    Objective:
    To be able to test finance data for completeness, uniqueness, consistency, timeliness, validity and accuracy, clean it in recorded steps, and reconcile the result to the source.
    Marked task:
    Explain the difference between the extract and the ledger, with workings.
    What the marker looks for:
    Reconciles the extract to the ledger (25), Fixes each problem in recorded steps (30), Checks the cleaned data is fit to use (25), Handles the AI offer with sound judgement (20)
  2. Module 2

    Reading a dashboard critically

    How to read a finance or operations dashboard without being misled: definitions, time windows, filters, averages, axes, colours and AI-written insights.

    Objective:
    To be able to review a dashboard for misleading definitions, comparisons and charts, ask the right questions of its owner, and restate its messages accurately for decision-makers.
    Marked task:
    List the problems with the dashboard and explain why each could mislead.
    What the marker looks for:
    Finds the problems and why they mislead (30), Asks the owner the right questions (20), Restates the messages accurately (30), Recommends practical changes (20)
  3. Module 3

    When Excel, Power Query or Python fits

    How to choose between Excel formulas, Power Query and Python for a finance data job, and the controls each choice needs. Concepts, not coding.

    Objective:
    To be able to choose an appropriate tool for a finance data task from Excel formulas, Power Query and Python, and set the review and maintenance controls that the choice requires.
    Marked task:
    Recommend a tool for each job, with reasons based on the shape of the job.
    What the marker looks for:
    Chooses the right tool for each job (30), Sets controls in proportion to the risk (25), Responds to the AI-written script with sound judgement (25), Checks the data and tool before use (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

£79

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 Finance role tracks

All 7 courses in this topic

Buying for a team

Seats by invoice or purchase order, with a manager report. See CPD for employers.

Back to every course