Tag not monitored by Microsoft.
Excel training is primarily available through the Excel help & learning hub rather than under a “Spreadsheets” category in Microsoft Learn.^1^
Recommended learning order
- Refresh the Excel basics
- Open Excel help & learning.
- Start with Get started, then continue to Format data and Formulas & functions.
- The same hub includes sections for importing and analyzing data, PivotTables, XLOOKUP, IF, and other current features.^1^
- Learn formulas
- Work through Overview of formulas in Excel. It covers:
- Formulas beginning with
= - Cell and range references
- Relative references such as
A1 - Absolute references such as
$A$1 - Built-in functions
- Newer functions such as
XLOOKUP
- Formulas beginning with
- It also provides a downloadable tutorial workbook for practicing common formulas.^2^
The formula examples library also groups exercises by conditional, lookup, date/time, financial, and statistical formulas.^3^=SUM(B2:B20) =AVERAGE(B2:B20) =COUNT(B2:B20) =IF(B2>=100,"Target met","Below target") =XLOOKUP(E2,A2:A20,B2:B20,"Not found") - Work through Overview of formulas in Excel. It covers:
- Learn tables and tabulation
For summarizing or “tabulating” a list, the relevant Excel feature is usually a PivotTable. A PivotTable calculates, summarizes, and analyzes data to reveal comparisons, patterns, and trends.^4^ In Excel for Windows:
- Arrange the source data in columns with one header row.
- Select the data.
- Choose Insert > PivotTable.
- Select New Worksheet.
- Select OK.
- In PivotTable Fields, place descriptive fields in Rows and numeric fields in Values.
- Explore newer Excel capabilities
After refreshing formulas and PivotTables, continue with dynamic array formulas. These allow one formula to return several results that “spill” into adjacent cells.^5^ For example:
For broader modern analytics, Microsoft Learn has an intermediate Excel and Power BI module covering=F10:F19*G10:G19XLOOKUP(),FILTER(),LET(), PivotTables, and Excel reports connected to Power BI datasets. It assumes prior Excel and PivotTable knowledge, so it is best used after the refresh above.^6^
The general Microsoft 365 training catalog is also available, but it covers the full Microsoft 365 ecosystem rather than providing a dedicated beginner Excel curriculum.^7^
References
- Excel help & learning
- Overview of formulas in Excel
- Examples of commonly used formulas | Microsoft Support
- Create a PivotTable to analyze worksheet data | Microsoft Support
- [Microsoft 365](https://support.microsoft.com/excel/guidelines-and-examples-of-array-formulas)
- Transcend data analysis together with Power BI and Excel - Training
- Browse all training