Excel
Three levels · taught in Excel/VBA Foundations and Excel/VBA Advanced
Level 1 of 3
Fundamentals
The interface and the basics
8 topics
- Excel walkthrough: workbooks, worksheets, ribbon and toolbar
- Formatting data: conditional formatting, filters and sorting
- Basic formulas (SUM, AVERAGE, COUNT) and error checking
- First charts and pivot tables
- Protecting workbooks and worksheets
- Access walkthrough: database design, tables and fields
All 8 topicsFewer topics
- Access queries, filters and data entry forms
- Relationships between tables and database documentation
You build: A formatted sales workbook with formulas, a pivot table and a chart, and a small Access database behind it.
7 assignments and 1 end-to-end live structured project
Level 2 of 3
Advanced
Building projects
8 topics
- Advanced charts and customised pivot tables
- Nested formulas and logical functions
- Lookups: VLOOKUP, HLOOKUP and XLOOKUP
- Power Query: connecting and importing external data
- Formula errors, data validation and auditing
- VBA fundamentals: macros, variables, constants and data types
All 8 topicsFewer topics
- VBA programming: loops, branching, user forms and controls
- Automating reports and data processing with VBA; debugging
You build: An Excel data capture tool, and a monthly report that builds itself with VBA.
7 assignments and 1 end-to-end live structured project
Level 3 of 3
Expert
Integrations and advanced use
9 topics
- Office Scripts: recording and editing a script
- Running a script on a schedule with Power Automate
- When to use VBA and when to use Office Scripts
- Automating emails with Power Automate
- Python in Excel: Python in a cell, pandas on a worksheet range
- Batch automation scripts
All 9 topicsFewer topics
- Connecting SharePoint lists with Excel
- Dynamic arrays and LAMBDA: FILTER, UNIQUE and LET
- Power Pivot and the Excel data model
You build: A report that refreshes from its sources and is emailed on a schedule, with no manual step.
7 assignments and 1 end-to-end live structured project




