An Excel learning path for office staff: what to learn first, how to practise, how to pick a course

Plenty of office workers open Excel every day without ever having learned it properly: they type data out of habit, add totals by hand, then lose an afternoon reconciling two files. This article pulls together a practical learning path from Microsoft's official documentation and advice shared on forums, ordered by one principle: learn first what you can use right away.

Why learning order matters

Excel has hundreds of functions and features, but office work usually comes down to a few jobs: entering data, looking things up, summing by condition, summarising reports and drawing simple charts. Popular learning roadmaps (Coursera's roadmap article, for example) start with foundations and only then move to real projects. The reason is simple: if the data going in is messy, even the best function or PivotTable will give you wrong answers.

Stage 1: Enter data cleanly

This is the most skipped step, yet it affects everything after it. Microsoft's guide to creating a PivotTable lists requirements for the source data, and they double as good data-entry rules in general:

• Each column has a single header row, with unique, non-blank names.
• No blank rows or blank columns inserted inside the data "to make it easier to read".
• Each column holds one data type: a date column contains only dates, a quantity column only numbers, with no text like "unknown" mixed in.
• Avoid merged cells inside the data area; keep merging for presentation only.

It is also worth learning Data Validation (drop-down lists) so other people enter the right values.

Stage 2: Turn ranges into Tables

Format as Table (Ctrl+T) is a small step that pays off. According to Microsoft's overview of Excel tables:

Data formatted as an Excel table, with filter buttons in the header and a total row

• A table grows automatically when you add rows, and formulas and formatting follow.
• Type a formula into one cell of a column and the whole column gets it (a calculated column).
• Formulas can refer to column names instead of cell addresses, which reads far better than C2:C500.
• The Total Row uses the SUBTOTAL function, so when you filter, only visible rows are counted.

Microsoft also warns not to confuse these Excel tables with the Data Table feature in the What-If Analysis group; they are completely different things.

Stage 3: Conditional sums and lookups

This is the group of functions used most in office reports.

SUMIFS, COUNTIFS

SUMIFS adds values that meet several conditions at once, for example total quantity per salesperson per month. Microsoft's documentation highlights a very common mistake: the argument order of SUMIFS differs from SUMIF. In SUMIFS the range to add comes first: =SUMIFS(sum_range, criteria_range1, criteria1, ...), whereas in SUMIF it comes last. Once SUMIFS is solid, COUNTIFS and AVERAGEIFS come quickly because they follow the same pattern.

XLOOKUP (or VLOOKUP on older versions)

XLOOKUP searches one column for a value and returns the matching value from another column in the same row; unlike VLOOKUP, the result column can sit to the left or right of the lookup column. Check one thing before you learn it: according to Microsoft Support, XLOOKUP is available in Excel for Microsoft 365, Excel 2021 and Excel 2024 (Windows and Mac), plus the Excel mobile apps, but it is not available in Excel 2016 or Excel 2019. If your company still runs those versions, learn VLOOKUP or INDEX + MATCH first, and be careful when sending files that use XLOOKUP to colleagues on older versions.

XLOOKUP example returning a dialling code from a country name

Stage 4: PivotTables and basic charts

Once the data is clean and inside a Table, a PivotTable lets you summarise by group with drag and drop: sales by region, orders by month, costs by department. Microsoft recommends keeping the source data as a table so that rows added later are included when you Refresh. A PivotTable does not change the original data, so you can experiment freely.

PivotTable Fields pane for dragging fields into Rows, Columns and Values

After PivotTables come basic charts: column, line, pie. What to learn here is picking the right type: column charts to compare groups, line charts for trends over time.

Stage 5: Power Query — later, when you need it

If every week you download the same kind of export from your accounting or sales software, then delete columns, fix formats and combine several files, that is the moment to learn Power Query. According to Microsoft, Power Query imports data from many sources, transforms it without touching the original, and records each step as a query you can rerun with a single Refresh. On versions: Excel for Windows (2016 onwards and Microsoft 365) has full support; Excel for Mac supports it only in Microsoft 365 and with limitations; Excel for the web has basic support.

How long does each stage take?

There is no reliable general figure per stage, because it depends on how much you use Excel every day. Two public reference points:

• The Microsoft Office Specialist: Excel Associate certification page says candidates should have roughly 150 hours of instruction and hands-on experience with Excel — a level that covers tables, formulas, functions and charts.
• Coursera's roadmap article suggests 20–30 minutes of practice a day rather than cramming.

So treat the stages above as an order of priority, not a fixed schedule.

Practise with your own work files

Roadmap articles such as Coursera's recommend tying learning to real projects. For someone in an office job, the most readily available project is your daily work:

1. Work on a copy, never directly on a shared file in use.
2. Pick a report you currently build by hand every week, rebuild it with a Table + SUMIFS or a PivotTable, and compare the result with the old method.
3. If the file contains customer details, salaries or other sensitive data, remove it or replace it with dummy data before asking for help outside or uploading it to another service, and follow your company's rules.
4. One theme per week (for example, lookups only), as Coursera suggests, to avoid drifting.

Free official resources

• Excel video training on Microsoft Support: grouped into areas such as getting started, formatting, formulas and functions, importing and analysing data, and collaboration.
• Each function's documentation page on Microsoft Support (for example XLOOKUP, SUMIFS): syntax, examples and the list of supported versions — check that list before using a new function.
• The skills outline for the MOS exams on Microsoft Learn: even if you do not plan to sit the exam, it is a fairly complete skills checklist.

Choosing a paid course: what to look at

This article does not rank or recommend any training provider. When comparing on your own, these criteria help:

• A concrete syllabus: does it clearly list Tables, SUMIFS, lookup functions, PivotTables, charts, Power Query, or just say "advanced Excel"?
• Exercises with realistic data: sales, timesheet or receivables data that is large enough and has real-world errors, rather than a ten-row table; exercise files you can download and redo.
• The Excel version used in the course: if it teaches on Microsoft 365 while your company uses Excel 2016 or 2019, functions such as XLOOKUP will not work at your job.
• Support while practising: does someone review your work, or is it video only?
• Certificate value: a course-completion certificate from a training provider is different from the Microsoft Office Specialist (MOS) certification issued by Microsoft. Microsoft currently offers "Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)" (exam MO-210, 50 minutes, available in Vietnamese) and an Expert level (MO-211). In a question on the Microsoft Q&A forum, the person answering advised newcomers to take the Associate exam first, since Expert leans towards advanced topics such as macros and complex formulas. A certificate helps show your skills when you have little experience, how much it counts depends on the employer.

In short

Follow the order: clean data entry → Tables → SUMIFS and lookup functions → PivotTables and charts → Power Query once you have repetitive work. Check the Excel version at your workplace before learning a new function, and use your own weekly report as the exercise.

Frequently asked questions

In what order should I learn Excel?

Clean data entry → Tables → SUMIFS and lookup functions → PivotTables and charts → Power Query once you have repetitive work. Learn first what you can use right away.

Can Excel 2016 or 2019 use XLOOKUP?

No. According to Microsoft Support, XLOOKUP is in Excel for Microsoft 365, Excel 2021, Excel 2024 and the Excel mobile apps. If your company still runs 2016 or 2019, learn VLOOKUP or INDEX + MATCH first.

How is MOS different from a training provider's certificate?

MOS (Microsoft Office Specialist) is issued by Microsoft: Excel Associate (exam MO-210, 50 minutes, available in Vietnamese) and an Expert level (MO-211). A course-completion certificate is issued by the training provider.