Excel Learning Resources
Practising with real data is one of the best ways to improve your Excel skills. Here are my structured courses, books and selected practice files to help you put the techniques to work.
Choose your learning path
- Excel Formulas: build confidence with calculations, references and functions.
- Dynamic Arrays: create flexible results with FILTER, SORT, HSTACK and related functions.
- Power Query: turn repetitive data preparation into a refreshable process.
- PivotTables: summarise data and explore useful reporting techniques.
- VBA & Macros: automate workbook tasks with code.
Learn with me
- The Ultimate Excel Course: a structured route from beginner skills to more advanced Excel work.
- Next-Gen Excel Formulas: my LinkedIn Learning course on dynamic arrays, structured references, modern lookups and reusable formulas.
- Excel VBA for Beginners: learn to write macros and automate spreadsheet tasks.
- ChatGPT and AI for Microsoft Excel: learn practical ways to use AI with your workbooks.
- Creating Sports League Tables and Tournaments in Excel: build tables that update as results are entered.
My Excel books
- Advanced Excel Formulas: develop your understanding of logical functions, text, dates, lookups and modern arrays.
- Advanced Excel Success: explore techniques for taking your spreadsheet skills further.
Download practice workbooks
Use these files to explore the examples and test your own variations.
- HSTACK practice workbook: combine columns and build formula-driven reports.
- Array constants practice workbook: work with multiple values inside a formula.
- TEXTSPLIT practice workbook: split and extract text for further calculations.
- XLOOKUP troubleshooting workbook: investigate data types, spaces, duplicates and search settings.
- ChatGPT for Excel practice workbook: explore data checks, cleaning and analysis.
Live learning
Join my free Work Smarter in Excel webinar for practical demonstrations covering formulas, Power Query, AI, Tables and interactivity. The registration page lists available sessions.
For community presentations from Excel specialists, see the London Excel Meetup group. You can also find more of my free tutorials and training at Computergaga.