Skip to content

Find your starting point for Excel or bookkeeping

Compare your current skills with the published courses. Choose the Excel assessment or the bookkeeping and accounting-software assessment below.

There is no signup, no email capture and nothing stored. If JavaScript is off the quiz still works — add up the points yourself and read the band underneath. When you have a result, take it to the matching course hub and compare its published topics and prerequisites with the tasks you need to do.

Excel

Eight questions about the Excel tasks you already do. Use the result to compare course outlines and starting skills. This is a self-assessment for course selection, not a certification exam or a guarantee of readiness.

1You need the total of a column of numbers. What do you do?
2A formula needs to always point at cell B1, even when copied down. What do you do?
3You have a list of 4,000 rows and need to see one region at a time.
4You need a price from another sheet, matched on product code.
5How do you produce a summary by category and month?
6The monthly report needs the same export, cleaned the same way, every time.
7Someone asks you to make a dashboard.
8The same fifteen clicks, every single day.

Scoring key — out of 29

0–6 points

Start at the beginning — and that is a normal place to be

Introduction to Excel develops workbook navigation, data entry, Autofill, basic formulas, formatting and printing. Compare these tasks with the work you already do before choosing this starting point.

If most of your low answers were about lookups and pivot tables specifically, and the rest felt easy, Excel Intermediate 1 may be a better fit.

7–13 points

Excel Intermediate 1

Intermediate 1 builds a budget worksheet using tables, sorting, filtering, absolute and relative references, Flash Fill and workbook views. It is a useful next step when basic data entry and formatting are familiar.

Introduction to Excel if the referencing question was a guess; Intermediate 2 if you are already confident with tables and filters.

14–19 points

Excel Intermediate 2

Intermediate 2 develops charts, table functions and slicers, named ranges, functions with multiple arguments, conditional formatting and nested functions. It builds on the tables and references practised in Intermediate 1.

For PivotTables, compare Advanced Data Management after checking its starting skills. For deeper formula work, compare Advanced Functions. Power Query and Power Pivot belong to Expert Data Management.

20–25 points

Excel Advanced Functions, or Advanced Data Management

Choose by the task you want to improve. Advanced Functions covers conditional logic, data summaries, time calculations, text functions and formulas using tables and named ranges. Advanced Data Management covers validation, duplicates, PivotTables, PivotCharts and slicers.

Expert Data Management covers Power Query and Power Pivot. If you are new to PivotTables, compare Advanced Data Management first.

26–29 points

One of the Expert courses — pick by what you are building

Compare a specialist path with the work you need to do: Expert Functions for dynamic arrays and advanced formulas; Expert Data Management for Power Query and Power Pivot; Expert Dashboard for interactive reports; or Expert Macros and Forms for macros, minor VBA edits and form controls.

Check each published prerequisite. Expert Functions requires Advanced Functions or equivalent experience, and Expert Data Management requires Advanced Data Management or equivalent experience. A high overall score can still hide a gap in one of those subjects.

Bookkeeping & accounting software

Six questions to help you compare bookkeeping foundations with accounting-software courses. Your score suggests a level; the software your organisation uses determines whether QuickBooks Online or Sage 50 is relevant. Check the course outline before booking.

1Someone says "post it to the suspense account and we will clear it at month end".
2Your trial balance does not balance.
3GST and HST on a purchase from another province.
4How is the accounting software set up?
5Bank reconciliation.
6You need to use payroll, inventory or project-tracking features in your accounting software.

Scoring key — out of 18

0–5 points

Bookkeeping Fundamentals first

Compare Bookkeeping Fundamentals if double-entry accounting, ledgers, trial balances and reconciliation are unfamiliar. The course uses manual methods to explain the principles behind the records, before you apply them in software.

If the bookkeeping principles are familiar and the difficulty is your application, compare Part 1 of QuickBooks Online or Sage 50 instead. Ask a trainer about the order if you need both foundations and software practice.

6–11 points

Part 1 of the package you run — QuickBooks Online or Sage

Both Part 1 outlines cover company setup, customers, vendors, transactions, financial reports and bank reconciliation in their respective applications. QuickBooks Online Part 1 also lists payroll setup, inventory and report customisation. Choose the application you actually use.

The Sage Accounting Part 1 booking product teaches Sage 50; it is not the browser-based Sage Accounting product. Confirm the edition, country configuration and required features before choosing either software course.

12–18 points

Part 2 of your software — check the required foundation

QuickBooks Online Part 2 covers payroll workflows, inventory adjustments, year-end reports, budgets, forecasting, project tracking and job costing. Sage Accounting Part 2 covers payroll, inventory, year-end reporting, budgeting and project tracking in Sage 50.

Both Part 2 paths assume a working foundation in the relevant software. If you know bookkeeping but are new to QuickBooks Online or Sage 50, choose that application’s Part 1 first. The total alone cannot establish product-specific experience.

A quiz is a starting point rather than a verdict. If the result surprises you, or you land on a boundary between two bands, ask a trainer to help compare the course outlines. For a team, the same question is usually answered differently: corporate training is scoped to a mixed group rather than to a single level.

Use the assessment to choose a useful next step

Treat an Excel skills assessment as a way to identify a starting point, not as a judgement about your job performance. Familiarity with a feature name is different from being able to use it independently.

After reviewing your results, choose one recent spreadsheet task and compare it with the course topics. If you can complete the task but cannot explain or check the method, include that in your enquiry. A practical example often makes a course recommendation clearer than a level label alone.