Advanced Excel Courses for Accountants 2026

Choose advanced Excel courses for accounting work. Compare practical coverage, then test reconciliation, formulas and reviewable client workpapers.

Published
Updated

Choose advanced Excel courses for accountants by the workpapers staff must prepare, then assess their skills with a reconciled workbook they can explain.

Choose the Course by Accounting Tasks

Match the course to the staff member’s next accounting task. A course covering repeatable imports suits recurring ledger extracts. Formula training suits someone who already imports clean data but struggles to explain a schedule.

Before advanced training, staff need to build ordinary formulas, use relative and absolute references and sort a complete table safely. Someone still learning these tasks needs intermediate training first.

Published Course Options

The University of Sydney’s Microsoft Excel Course: Level 3 suits an intermediate user needing broader analysis skills. Its syllabus covers Power Query imports, lookup functions and PivotTables, with data validation and recorded macros.

CCE teaches the course over seven hours, online or face to face. Electronic materials use Windows instructions. Its device guidance lists Excel 2016, 2019, 2021, 2024 or 365, but the required functions must also exist in the learner’s installation.

CPA Australia’s Power Query Fundamentals suits staff who repeatedly clean and combine extracts. The self-paced course covers CSV and Excel imports, transformations, combining files and handling errors. It is a six-hour CPD course for CPA members.

The Australian member fee is $242 including GST. Standalone access lasts 12 months, and the arrangement excludes associated CFI certifications. Pair this import course with formula and reconciliation practice.

For more developed reporting work, CPA Australia’s Dynamic Reporting with Power Query covers M formulas, related tables and a management report. It includes downloadable worksheets and practical tasks. The exercise requires 64-bit Excel.

This self-paced recorded webinar has five CPD hours. Fees are $275 for members and $481.25 for non-members, including GST. Choose it when staff already understand the source data and need to update a repeatable reporting model.

Match the Syllabus to the Workpaper

Accounting taskLearning to requireEvidence from the staff member
Clean a ledger extractData types, text cleaning and preserved source rowsA repeatable import with rejected rows visible
Match two recordsExact lookups and duplicate detectionUnmatched items and duplicate references listed separately
Build a scheduleTables, structured formulas and explicit assumptionsFormulas extend to added rows without manual repairs
Reconcile balancesControl totals and reconciling itemsA bridge from source total to reported balance
Repeat the jobRefreshable imports and documented dependenciesChanged inputs update the result and exception report

A course title does not establish coverage of structured formulas or reconciliation. Select the course for its taught topics, then use the exercise below to assess the whole accounting task.

Run the practice workbook on the learner’s actual Excel version and operating system before enrolment. Microsoft’s Power Query version guidance explains why platform support matters. A Windows demonstration does not establish identical Mac functionality.

For training approval, record the access period, practical files and tutor support alongside the fee and time away from work. Distinguish live questions during a class from feedback on a completed accounting workpaper.

Test a Client-Workpaper Exercise

Use a fictional receivables file to test whether the learner can import transactions and explain a reconciliation. Keep real client data out of training files.

Give the learner two CSV files. The invoice file contains four unique invoices of $100, $200, $300 and $400, totalling $1,000. The receipt file contains $100 and $250 allocated to those invoices.

Add a duplicate copy of the $100 invoice to the raw invoice file. The raw import must show five rows totalling $1,100. The accepted unique invoices must total $1,000, with the duplicate retained in an exception report.

  1. Preserve both source files unchanged. Record file names and row counts on a Read me sheet, with the rule for identifying a duplicate invoice.
  2. Import amounts as numbers and invoice references as text. Separate the duplicate using a documented rule, without deleting it from the original file.
  3. Match receipts to invoices using exact references. Report unknown references and duplicate identifiers separately instead of accepting the first lookup match silently.
  4. Calculate the outstanding balance using tables and structured formulas. The expected result is $650: $1,000 of unique invoices less $350 of receipts.
  5. Add a new unique $150 invoice to the source file and refresh. The accepted invoice total must become $1,150 and outstanding receivables $800. The original duplicate must remain visible.
  6. Hand the workbook to a reviewer with formulas visible, assumptions recorded and refresh instructions. The reviewer must trace the $800 balance to the preserved inputs.

Require a separate reconciliation of raw imports, excluded duplicates and accepted transactions. A correct closing balance alone can conceal two errors that cancel each other out.

Check formulas for fixed ranges that miss new rows, approximate matches and hard-coded totals. Keep assumptions in labelled cells, explain any manual adjustment and record who approved it.

Review and Maintain the Skills

A supervisor approves tasks from the completed workbook and the learner’s explanation. A course certificate records course completion. Permission to prepare a client schedule needs evidence that the person can find and explain an error.

Record the exercise version, Excel environment and review outcome. Name the tasks approved, such as preparing a receivables reconciliation under review. Record tasks still needing supervision, such as changing a shared query or introducing a macro.

For the next supervised job, compare the workbook with the client’s actual source records. Confirm the refresh instructions work and unresolved exceptions reach the reviewer. Training completion does not remove the practice’s normal review requirements.

Repeat the changed-input exercise when a shared workbook or import format changes. If recurring transformations become difficult to inspect in Excel, Python for accountants explains a local scripted approach. Keep the same source preservation and reconciliation requirements whichever method prepares the schedule.

One client form. One finished return.

Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.

See how Tax Genie works

Made for Australian accounting firms

Tax GenieSee how Tax Genie works