Most people who set out to learn Excel for work try to learn “Excel” as a whole, get lost in hundreds of functions and stop. Work rarely asks for that. It asks for a short list of skills done reliably: a clean list, a correct formula that still works when copied, a summary table, a readable chart. This roadmap orders those skills into five stages, tells you how to know you have finished each one and shows how to prove the result to an employer.
Function behaviour below comes from Microsoft’s own support pages. The practice tasks and the weekly plan are illustrative; adjust the pace to your time.
Before you start: check your version
Which Excel you have decides which features you can use. Two examples matter for this roadmap:
- XLOOKUP, the modern lookup function, works in Excel for Microsoft 365, Excel 2021 and Excel 2024. Microsoft’s article states that it is not available in Excel 2016 or Excel 2019.
- Power Query (also called Get & Transform) is built into Excel for Microsoft 365, 2024, 2021, 2019 and 2016 on Windows. Microsoft notes it is not supported in Excel 2016 and 2019 for Mac, and that the old add-in for Excel 2010 and 2013 has been deprecated.
If your employer uses an older version, learn the older lookup method (INDEX and MATCH, or VLOOKUP) alongside XLOOKUP. You will meet both in shared workbooks.
Stage 1: Handle a list without breaking it
Every later skill depends on data laid out properly. Microsoft’s PivotTable guidance describes the shape it wants: data organised in columns, one header row, each column with a unique, non-blank label, and no merged cells or double header rows. Get into that habit from day one.
Learn: entering and editing data, sorting and filtering, freezing the header row, formatting numbers and dates, and turning a range into an Excel table (Insert > Table).
You have finished this stage when you can take a messy list of 200 rows, give it a single header row, sort it by two columns, filter it to one region and format it as a table, without losing or scrambling a row.
Stage 2: Write formulas that survive copying
This is where most workplace errors start. A formula that works in one cell gives wrong answers when filled down because the references move.
Microsoft’s explanation is the one to learn: references are relative by default, so =B4*C4 copied from D4 to D5 becomes =B5*C5. Adding dollar signs, as in $B$4, makes the reference absolute so it does not change. A mixed reference locks only the column ($B4) or only the row (C$4). Selecting a reference in the formula bar and pressing F4 cycles through the types.
Learn: SUM, AVERAGE, MIN, MAX, COUNT and COUNTA; IF; relative, absolute and mixed references; basic error values and what causes them.
Practice task (illustrative): put a VAT or exchange rate in one cell, then calculate a converted price for 50 rows with a single formula filled down. If the rate cell is not locked, you will see the mistake straight away.
Stage 3: Summarise with conditions and lookups
Once your list is clean and your formulas are reliable, you can answer the questions managers actually ask: “How much did the Dubai branch sell in March?” or “What is the price of item 4471?”
Conditional totals
SUMIFS adds values that meet one or more conditions. Its syntax is SUMIFS(sum_range, criteria_range1, criteria1, ...), and Microsoft allows up to 127 range-and-criteria pairs. One trap: in SUMIFS the sum range comes first, but in the older SUMIF it comes third. Microsoft warns that copying a formula between the two without reordering the arguments causes errors.
=SUMIFS(D2:D500, B2:B500, "Dubai", C2:C500, "Mar")Lookups
XLOOKUP searches one column or row and returns the value in the same position from another. Unlike VLOOKUP, the column you return can sit to the left or right of the one you search.
=XLOOKUP(G2, A2:A500, E2:E500)You have finished this stage when you can build a small summary block (totals by region and month) from a raw sales list, and pull a price into an order sheet from a separate product list, and the results stay correct when you add new rows.
Stage 4: PivotTables and charts
A PivotTable turns thousands of rows into a summary in a minute, and it is a common dividing line between basic and intermediate users.
The steps Microsoft gives for Excel for Windows are short: select the data, go to Insert > PivotTable, confirm the range, choose where to place it and select OK. Then tick fields in the PivotTable Fields pane. By default, numeric fields go to Values, text fields to Rows and date or time fields to Columns. Numeric values are summed by default, but if Excel reads them as text they are counted instead, which is a common reason a PivotTable shows odd numbers.
Learn: building a PivotTable from a table, changing Sum to Count or Average in Value Field Settings, grouping dates, filtering, and creating a simple column or line chart from the result.
You have finished this stage when you can answer three different questions from the same dataset by rearranging one PivotTable, and produce one clear chart a manager could read without explanation.
Stage 5: Automate the clean-up
If you receive the same export every week and spend an hour fixing it, Power Query is the next step. Microsoft describes four phases: connect to the data, transform it (remove columns, change data types, filter rows) without altering the source, combine queries by appending or merging, and load the result to a worksheet or the Data Model. Next week you refresh instead of repeating the work.
Macros and VBA are worth learning only if your role involves repeated manual steps that Power Query cannot handle. Many office roles never need them.
A six-week plan you can fit around work
This plan assumes about four hours a week. It is a suggestion, not a requirement; move faster through stages you already know.
| Week | Focus | End-of-week check |
|---|---|---|
| 1 | Stage 1: tables, sorting, filtering, formatting | Clean a messy 200-row list into a table |
| 2 | Stage 2: core functions, IF, references | One formula filled down 50 rows, all correct |
| 3 | Stage 3: SUMIFS, COUNTIFS | A totals-by-region-and-month block |
| 4 | Stage 3: XLOOKUP or INDEX/MATCH | An order sheet that pulls prices from a product list |
| 5 | Stage 4: PivotTables and charts | Three answers from one PivotTable, plus one chart |
| 6 | Stage 5: Power Query basics; portfolio file | A refreshable clean-up of a sample export |
Use realistic practice data. Public datasets from government open-data portals work well, or build your own: a fictional shop’s sales for a year, an expense log, a staff rota. Practise on the version of Excel you will use at work where possible.
Choosing an Excel course (or not)
You do not need a paid course to reach Stage 4. Microsoft’s support articles, used with your own practice file, cover every function in this roadmap. A course helps when you want structure, deadlines or a certificate to show.
When comparing courses, check three things:
- Version: does it teach the Excel you use? A course built on Excel 2016 will not teach XLOOKUP.
- Practice files: do you work on real datasets, or only watch?
- Assessment: is there a test you can fail? A completion badge for watching videos says little to an employer.
The official certification route
Microsoft’s own credential is the Microsoft Office Specialist (MOS) programme. As checked on 3 November 2026 on Microsoft Learn:
- Excel Associate (Microsoft 365 Apps), exam MO-210: covers managing worksheets and workbooks, cells and ranges, tables, formulas and functions, and charts. Microsoft lists it as a 50-minute proctored exam with possible interactive components, and describes the target candidate as having about 150 hours of instruction and hands-on experience. No formal prerequisites are listed.
- Excel Expert (Microsoft 365 Apps), exam MO-211: weighted as workbook options and settings (10–15%), managing and formatting data (30–35%), advanced formulas and macros (25–30%), and advanced charts and tables (25–30%).
Microsoft does not publish one global fee; it says pricing depends on the country or region where the exam is taken, so confirm it with the exam provider. It also recommends registering with a personal Microsoft account rather than a work or school account, because records tied to an organisational account can be lost if you leave that organisation.
Is it worth it? The certificate is useful when a job advert asks for it, or when you have no work history to prove your skills. If you already use Excel daily, a portfolio file and specific CV bullets often say more.
Showing Excel skills on your CV
“Advanced Excel” on its own tells an employer nothing, and it invites a test you may not pass. Name what you did and what it achieved. Illustrative examples:
- Built a PivotTable report of monthly sales by branch, replacing a manual summary prepared by hand each month.
- Set up an XLOOKUP-based order sheet that pulls prices from the product list, removing copy-and-paste errors.
- Automated the weekly stock export clean-up with Power Query, cutting preparation from about an hour to a refresh.
Use real figures only. Put the tool names in your skills section as well (Excel: PivotTables, SUMIFS, XLOOKUP, Power Query) so a recruiter scanning for them finds them. If you are applying for office roles, the administrative assistant resume builder includes example skill lines you can adapt, and the data analyst resume builder suits analysis roles.
Expect to be tested. Some employers give a short practical Excel task at interview, so be ready to demonstrate any skill you list.
Frequently asked questions
How long does it take to learn Excel for work?
It depends on your starting point and the role. For a rough guide, Microsoft describes the MO-210 Associate candidate as having about 150 hours of instruction and hands-on practice. Many office tasks need only Stages 1 to 3, which take far less.
What should Excel beginners learn first?
Data layout and tables, then core functions and absolute references. Skipping these causes most errors later, even for people who know advanced functions.
Which Excel skills do jobs ask for most often?
Job adverts vary, but the recurring ones are lookups, conditional totals, PivotTables, charts and clean data handling. Read the adverts for your target role and match your practice to them.
Can I learn Excel for free?
Yes. Microsoft’s support articles explain every function in this roadmap, and practising on your own data costs nothing. You pay only if you want a structured course or a certification exam.
Do I need VBA?
Only for roles that involve repeated manual processes. Learn Power Query first; it handles much of the routine clean-up without code.
Sources
- XLOOKUP function, Microsoft Support
- About Power Query in Excel, Microsoft Support
- Switch between relative, absolute, and mixed references, Microsoft Support
- SUMIFS function, Microsoft Support
- Create a PivotTable to analyze worksheet data, Microsoft Support
- Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps), Microsoft Learn
- Exam MO-210: Microsoft Excel (Microsoft 365 Apps), Microsoft Learn
- Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps), Microsoft Learn