Start with a task, not a label

You may open Excel every day, yet adding a row breaks your report. You may know pivot tables, yet the totals do not match the source. Experience alone does not determine a level. Look at what you can produce and verify independently.

Start with a small business file: expenses, orders or working hours. Try to turn it into a reusable tracker. The points where you struggle reveal the skills worth practising.

Beginner: build a solid foundation

This level suits you if absolute references, date formats or structured tables are still unfamiliar. The goal is to enter consistent data, write simple calculations and present readable results.

Practical test: add five expenses, copy a formula and check the total. Can you explain every reference? A correct workbook should remain understandable after you build it.

Intermediate: connect, summarise and validate

The intermediate level connects lists, automates checks and summarises with pivot tables. The aim is to handle missing matches and reconcile figures, rather than merely make a formula run.

Practical test: link orders to a product reference table and produce a monthly summary. Include a missing product deliberately. Your workbook should make the anomaly visible rather than silently turning it into zero.

Advanced: make updates reproducible

At this level you design a workflow: import, cleaning, calculations, checks and output. Power Query can replace repetitive operations. Automation is useful when a colleague can understand the logic and maintain the file.

Check your Excel version before a session. XLOOKUP is unavailable in Excel 2016 and 2019; alternatives may be used. Power Query, Power Pivot and scripting capabilities also vary by environment.

References

Back to the blog →