Microsoft Excel is a powerful spreadsheet application in the Microsoft Office suite, widely used to organise data, perform calculations, and create charts and reports.
If you are interested in individual or small-group face-to-face Excel training, please visit my Training Solution page:
Microsoft Excel Basics – Training Solution
You can also build your skills with this free Excel tutorial series from LearnFree.org. These lessons cover workbook basics, formatting, formulas, functions, charts, sorting, filtering, PivotTables, and more.
The lessons below open on LearnFree.org in a new tab, so you can easily return to this Excel topic list at any time.
Explore the full topic list below.
- 1
- 2
Understanding OneDrive for Excel
Learn how to work with your Microsoft account and OneDrive in Excel.
🕑 3 min - 3
Creating and Opening Workbooks
Learn how to create new workbooks and open existing Excel files.
🕑 10 min - 4
- 5
- 6
Modifying Columns, Rows, and Cells in Excel
Learn how to resize and adjust rows, columns, and cells in a worksheet.
🕑 13 min - 7
Formatting Cells in Excel
Learn how to format text and improve the appearance of worksheet content.
🕑 17 min - 8
Understanding Number Formats in Excel
Learn how to format numbers for dates, currency, percentages, and more.
🕑 12 min - 9
Working with Multiple Worksheets
Learn how to add, delete, copy, move, group, and ungroup worksheets.
🕑 12 min - 10
- 11
- 12
- 13
- 14
- 15
Relative and Absolute Cell References
Learn how relative and absolute references work in Excel formulas.
🕑 10 min - 16
- 17
Basic Tips for Working with Data
Learn practical ways to organise and work with spreadsheet data more effectively.
🕑 6 min - 18
Freezing Panes and View Options
Learn how to freeze panes and adjust worksheet views to focus on key content.
🕑 10 min - 19
- 20
- 21
Groups and Subtotals
Learn how to group data, create subtotals, and build worksheet outlines.
🕑 12 min - 22
- 23
- 24
- 25
Comments and Co-authoring
Learn how to use comments and collaboration features when reviewing workbooks.
🕑 11 min - 26
- 27
- 28
Doing More with PivotTables
Learn how to extend PivotTables to better summarise and explore data.
🕑 10 min - 29
- 30
- 31
New Features in Office 2019 for Excel
Discover some of the newer features introduced in Office 2019.
🕑 4 min - 32
- 33
Office Intelligent Services for Excel
Learn more about features available through Intelligent Services.
🕑 4 min - 34
- 35
- 36
Source: Excel: Foundations | LearnFree