Professional Excel — Mastery & Productivity
Structure worksheets, make formulas reliable and turn working data into useful analysis, pivot tables and dashboards.
The right level. A practical goal.
Start at the level matching your experience. Every stage has prerequisites, workshops and a validation project.
Beginner
Become independent with a working workbook, from data entry to your first tracker.
Prerequisites: Basic computer skills; no previous Excel experience required.
01Working with a workbook
- Worksheets, cells and ranges
- Saving and organising files
- Shortcuts and navigation
02Entering clean data
- Text, numbers and dates
- Formats and units
- Copying, filling and correcting
03Building your first formulas
- Order of operations
- Relative and absolute references
- SUM, AVERAGE, MIN and MAX
04Organising a usable list
- Structured tables and headers
- Sorting and filters
- Basic validation and duplicates
05Presenting results
- Choosing a simple chart
- Conditional formatting
- Page layout and PDF export
06Delivering a reliable file
- Checking totals
- Separating input and calculations
- Documenting and handing over a workbook
Prove it through practice.
Create an expense tracker: a structured table, validated calculations, a chart and a printable view.
Success criteria- Consistent entries and correct data types
- Formulas copied without reference errors
- Totals reconciled to source data
Intermediate
Improve reliability and speed when working with lists, lookups and business summaries.
Prerequisites: Be comfortable with references and structured tables, or complete the beginner level.
01Combining useful functions
- IF, AND, OR and IFERROR
- SUMIFS and COUNTIFS
- Testing edge cases
02Connecting reference data
- XLOOKUP where supported
- INDEX/MATCH as an alternative
- Exact matches and unique keys
03Working with text and dates
- Cleaning and extraction
- Dates, deadlines and periods
- Detecting numbers stored as text
04Making input reliable
- Drop-down lists
- Conditional rules
- Cross-column consistency checks
05Summarising with pivot tables
- Fields, grouping and filters
- Slicers and pivot charts
- Refreshing and reconciling totals
06Sharing a maintainable tool
- Protection against accidental edits
- Separating sources, calculations and output
- User notes and a test dataset
Prove it through practice.
Build a sales tracker: a product reference table, input checks, a monthly summary and a pivot table.
Success criteria- Lookups explicitly handle missing matches
- Metrics verified on a sample
- Pivot tables refresh correctly after adding rows
Advanced
Design robust, reusable workbooks that refresh reliably, with automation suited to the task.
Prerequisites: Solid conditional formula, lookup and pivot-table skills; Excel supporting the selected features.
01Structuring advanced calculations
- Named formulas and readability
- LET and dynamic arrays where supported
- Filters, sorts and spilled results
02Preparing data with Power Query
- Importing a folder of files
- Types, nulls and errors
- Merging and appending queries
03Introducing the data model
- Fact and dimension tables
- Relationships and granularity
- Basic measures with Power Pivot where available
04Building a management dashboard
- Defining KPIs
- Navigation and visual reading
- Period comparisons and thresholds
05Choosing appropriate automation
- Power Query before code
- Introduction to VBA or Office Scripts depending on the environment
- Operation logs and error handling
06Auditing and handing over
- Finding fragile dependencies
- Testing volume and refresh
- File versioning and maintenance guide
Prove it through practice.
Deliver a refreshable management workbook: monthly import, integrity checks, metrics and maintenance documentation.
Success criteria- A new file is integrated without copying calculations
- Source errors are identified and documented
- Reference test cases produce consistent results
Recent desktop Excel recommended. XLOOKUP, LET, dynamic arrays, Power Query, Power Pivot and automation depend on version, operating system and licence; alternatives are confirmed before the session.
Start with a real lesson.
Before the chart, define what the figure measures.
An explained concept, a diagram or example, then an exercise to work through yourself.
Read the free lessonWhat you will learn to do
- Organise data in structured tables
- Use suitable formulas and references
- Summarise with pivot tables
- Build clear, verifiable reporting
Skills across the programme
01Worksheets, tables and data quality
02Formulas, references and checks
03Lookup functions and conditional calculations
04Pivot tables and charts
05Preparing data with Power Query
06Dashboard and measured automation
Start with the right foundations
Prerequisites
Basic computer literacy. Access to Excel; features are adapted to the version used.
Language and format
Discovery resources are available in French and English. Contact us to confirm the teaching language, format, materials and support for your chosen programme.
Connect knowledge to a project
Create a sales tracker with structured data, validated metrics, a pivot table and a dashboard.
Before you enrol
| Preview lesson | Free · no account |
| Full programme and materials | As confirmed for the session |
| Official exam | Separate registration |
| Cloud environment costs | Check for each lab |
The best way to find out?
Start learning.
One lesson, a real concept and an exercise. Discover our approach, without an account and at your own pace.