Skip to main content

Excel Roadmap 2026

Get strong in Excel: formulas, functions, tables, charts, PivotTables, lookups, Power Query and automation.

4 stages · 6 units · Beginner · about 40 hours · Last reviewed 19 November 2026

What is a excel?

Excel is Microsoft's spreadsheet application for storing, calculating and analysing data in a grid of cells. People use it for budgets, reports and data cleaning. It offers formulas and functions, tables, charts, PivotTables, Power Query for importing and reshaping data, and macros to automate repeated work.

Step-by-step excel roadmap

  1. 1

    Spreadsheet Basics

    Cells and formulas.

    • Foundations

      Excel foundations are the basics of working in a workbook: sheets, cells, number and date formatting, and formulas that start with an equals sign. Cell references can be relative, such as A1, or absolute, such as $A$1, and the difference controls what happens when a formula is copied.

  2. 2

    Data Skills

    Organise and analyse.

    • Data

      Working with data in Excel means keeping information in a clean tabular layout, with one header row, one record per row and one field per column. Excel Tables add filtering, sorting and structured references, and cleaning tools such as Remove Duplicates, Text to Columns and TRIM fix messy imports.

    • Functions

      Excel functions for logic and lookups let a sheet make decisions and find related data. IF, AND and OR test conditions, SUMIFS and COUNTIFS aggregate by criteria, and lookup functions such as XLOOKUP and VLOOKUP return a value from another table by matching a key.

  3. 3

    Reporting

    Show insights.

    • Analysis

      Excel analysis is summarising and presenting data. A PivotTable groups and totals rows by fields you drag into rows, columns, values and filters, without writing formulas. Charts such as column, line and pie then turn those summaries into visuals, and slicers add interactive filtering.

    • Modern Excel

      Modern Excel refers to newer features: dynamic array functions such as FILTER, SORT, UNIQUE and XLOOKUP that return many values and spill into neighbouring cells, and Power Query, a tool that imports data from files and databases, cleans it through recorded steps and loads it into the workbook.

  4. 4

    Automation

    Save time.

    • Automation

      Excel automation is making repeated work run by itself. A macro records actions or is written in VBA, Excel's built-in programming language, and can be attached to a button, while workbook sharing, protection and co-authoring control who can view or change a file.

Frequently asked questions

Ready to practise for interviews?

Practise excel questions with an AI mock interviewer and get feedback on your answers.

More roadmaps