Online Excel training · Excel 365 · MOS MO-210 & MO-211 · ICDL
Excel training courses that take you from beginner to certified expert.
Four complete Excel training courses in one online path: Beginner, Advanced, Expert & AI, and Certification prep. Go from your very first workbook to PivotTables, Power Query, dashboards, Copilot and VBA, and prepare for the certifications recruiters recognise: Microsoft Office Specialist (MOS) Associate and Expert and ICDL Core and Advanced Spreadsheets.
- Every objective of the MO-210 and MO-211 exams covered, module by module
- Built on the official ICDL Core Spreadsheets 6.0 and Spreadsheets Advanced 3.1 syllabi
- Timed, project-based MOS practice exams completed in real Excel
$147 $197 · Save 25% · Start learning right after purchase
4
Excel training courses in one path
24
chapters
225
step-by-step modules
4
ICDL and MOS practice exams
“I know Excel” is no longer enough.
Almost every job description lists Excel. Very few candidates can show what they actually master. A recognised certification turns a vague line on your CV into evidence a recruiter can check in seconds.
That is why these Excel training courses were built around certification from day one. You don’t just learn features: you learn exactly what the exams test, practise it on real files, and arrive on exam day knowing what to expect.
And because the training keeps going well past the exams, the skills you build are the ones that make you faster, more reliable and harder to replace at work.
Four Excel training courses. One clear path.
Most people looking for Excel training courses end up stitching together a beginner video here and an advanced tutorial there. Here, every level builds on the one before, so nothing is skipped and nothing is repeated.
Course 1 · Beginner
Excel for beginners
Your first workbook, data entry, formulas and functions, formatting, charts and printing. Follows the ICDL Core Spreadsheets syllabus.
Course 2 · Advanced
Advanced Excel
XLOOKUP, dynamic arrays, advanced charts, PivotTables, what-if analysis, data validation, macros and collaboration. Follows the ICDL Spreadsheets Advanced syllabus.
Course 3 · Expert & AI
Expert Excel and AI
Power Query, Power Pivot and DAX, a complete dashboard project, generative AI, Copilot in Excel, Office Scripts and VBA.
Course 4 · Certification
MOS exam preparation
How the MOS exams work, plus timed, project-based MO-210 and MO-211 practice exams completed in real Excel.
Every level ends with a quiz, a review exercise or a practice exam, so you always know when you’re ready for the next one.
Excel training that prepares you for two certifications
Microsoft Office Specialist (MOS)
The Microsoft certification employers ask for most when they want proof of Excel skills.
- MO-210 Excel Associate: the core skills every office role relies on
- MO-211 Excel Expert: advanced formulas, data analysis, macros and workbook management
- Every exam objective flagged with a MOS badge in the module that teaches it
- Two timed, project-based practice exams in real Excel, one for each exam
ICDL Spreadsheets
The international digital skills standard, recognised by employers and institutions around the world.
- Course 1 follows the ICDL Core Spreadsheets 6.0 syllabus
- Course 2 follows the ICDL Spreadsheets Advanced 3.1 syllabus
- A review exercise and a practice exam at the end of each one
- The same foundations then carry you straight into MOS Expert level
The training prepares you for the exams. The official MOS and ICDL certification exams are booked and taken separately through an authorised test centre.
What you’ll be able to do after this Excel training
- Build clean, reliable workbooks with formulas that don’t break when you copy them
- Use XLOOKUP, INDEX/MATCH, IFS, LET, FILTER, SORT and dynamic arrays with confidence
- Summarise thousands of rows in seconds with PivotTables, slicers and timelines
- Import and clean messy data automatically with Power Query
- Model data with Power Pivot and write DAX measures with CALCULATE
- Build an interactive sales dashboard from scratch
- Let Copilot and generative AI write, explain and fix formulas and macros for you
- Automate repetitive tasks with Office Scripts and VBA
The certificate gets you noticed. Course 3 makes you indispensable.
Most Excel training courses stop where the exam stops. This one doesn’t. Course 3 goes beyond both syllabi with the skills that set advanced users apart at work today:
- Power Query: import and transform data from files, folders and the web
- Power Pivot and the Data Model: relationships, DAX measures, KPIs
- A complete dashboard project, from raw data to a shareable report
- Generative AI for Excel: prompts that produce error-free formulas and macros
- Copilot in Excel: cleaning, analysing, charting and building PivotTables by asking
- Office Scripts and VBA: automate the monthly report you currently build by hand
Online Excel training designed so you actually finish
1. Watch
Every module opens with a short video that shows the skill in action. No hour-long lectures.
2. Follow
Step-by-step screens with annotated screenshots walk you through every click, so you never get lost.
3. Practise
Download the practice file, do it yourself in Excel, then lock it in with a quick quiz.
4. Prove it
Chapter quizzes, review exercises and practice exams show you exactly where you stand before the real thing.
Excel training course syllabus
4 courses, 24 chapters, 225 modules. Open a course to see every chapter.
Course 1 · Excel for beginners (ICDL Core Spreadsheets, chapters 1 to 7)
- 1. Getting started and managing workbooks: interface, saving, options, Document Inspector, accessibility and compatibility checks
- 2. Entering and organizing data: selection, find and replace, fill handle and series, sorting
- 3. Rows, columns and worksheets: sizing, hiding, freeze panes, managing sheets
- 4. Your first formulas and functions: relative and absolute references, SUM, AVERAGE, IF, COUNTIF, SUMIF, error values
- 5. Formatting your worksheets: number formats, styles, Format as Table, structured references
- 6. Creating your first charts: choosing, building and formatting column, bar, line and pie charts
- 7. Page setup and printing, plus a review exercise and an ICDL Core practice exam
Course 2 · Advanced Excel (ICDL Spreadsheets Advanced, chapters 8 to 16)
- 8. Advanced formatting: conditional formatting, custom number formats, templates, duplicates
- 9. Advanced functions (22 modules): nested IF, IFS, SWITCH, XLOOKUP, INDEX/MATCH, financial and database functions, LET, dynamic arrays, FILTER, SORT, UNIQUE, SEQUENCE
- 10. Advanced charts: combo charts, secondary axis, sparklines, histogram, Pareto, waterfall, funnel, sunburst
- 11. Sorting, filtering and outlining: custom sorts, advanced filter, subtotals, Flash Fill
- 12. PivotTables: layout, slicers, timelines, grouping, calculated fields, PivotCharts
- 13. What-if analysis: data tables, Scenario Manager, Goal Seek, consolidation
- 14. Data validation and formula auditing: drop-down lists, tracing, Watch Window
- 15. Productivity and automation: named ranges, Paste Special, linking workbooks, recording and editing macros
- 16. Collaboration and security: protection, passwords, co-authoring, version history, plus an ICDL Advanced practice exam
Course 3 · Expert Excel and AI (chapters 17 to 23)
- 17. Power Query: importing from files, folders and the web, cleaning, merging and appending queries, parameters
- 18. Power Pivot and the Data Model: relationships, DAX measures, CALCULATE, date tables, hierarchies, KPIs
- 19. Project: building a dashboard from raw data to a protected, shareable report
- 20. Excel and generative AI: effective prompts, error-free formulas, generating and fixing VBA
- 21. Copilot in Excel: setup, cleaning data, insights, charts, PivotTables and dashboards
- 22. Office Scripts: recording, editing, running and sharing scripts
- 23. Introduction to VBA: procedures, variables, conditions, loops, and a monthly report automation project
Course 4 · MOS exam preparation (chapter 24)
- How the MOS exams work: format, project-based tasks and what to expect on the day
- MO-210 practice exam: timed and project-based, in real Excel
- MO-211 practice exam: timed and project-based, in real Excel
Who these Excel training courses are for
- Job seekers who want a recognised Excel certification on their CV
- Office, admin, sales and finance professionals who use Excel every day and want to work faster
- Career changers moving into data, accounting, logistics or management roles
- Self-taught users who want to fill the gaps and finally master the advanced features
- Candidates preparing for MOS Associate (MO-210), MOS Expert (MO-211) or ICDL Spreadsheets
What you need
A computer with Excel for Microsoft 365 (module 1.1 shows you how to get it). No prior Excel experience required: Course 1 starts from the very first workbook.
Get all four Excel training courses
$147
$197 · Save 25% · Instant access after purchase
- 4 Excel training courses: Beginner, Advanced, Expert & AI, MOS exam prep
- 24 chapters and 225 step-by-step modules
- A short video and annotated screenshots in every module
- Downloadable practice files to work on in real Excel
- 22 chapter quizzes to check your progress
- ICDL Core and ICDL Advanced review exercises and practice exams
- Timed, project-based MO-210 and MO-211 practice exams
Excel training courses: frequently asked questions
Which Excel training course is right for me?
You don’t have to choose. The path starts at beginner level and goes all the way to expert, so complete beginners start with Course 1, and confident users get the advanced, expert and certification material they’re missing.
Does this Excel training really prepare me for the MOS certification?
Yes. Every objective of both MOS Excel exams, MO-210 (Associate) and MO-211 (Expert), is covered and flagged with a MOS badge in the module that teaches it. Course 4 explains how the exams work and includes a timed, project-based practice exam for each one, completed in real Excel, just like the real test.
And for the ICDL certification?
Courses 1 and 2 follow the official ICDL Core Spreadsheets 6.0 and Spreadsheets Advanced 3.1 syllabi. Each one ends with a review exercise and a practice exam so you can check you’re ready.
Do these Excel training courses come with a certificate?
The certificates employers actually look for are the official ones: Microsoft Office Specialist (MOS) and ICDL. These courses are your complete preparation for both. The official exams are booked separately through an authorised test centre, so you take them when you feel ready.
How much does Excel training cost?
All four Excel training courses are included for one price: $147 instead of $197, with instant access after purchase.
Can I learn Excel in 7 days?
With a week of regular practice, you can be comfortable with the fundamentals covered in Course 1: entering data, writing formulas, formatting and creating charts. Advanced and expert skills take longer to master. The training is self-paced, so you move at the speed that suits you.
Can Excel be self-taught?
Yes, as long as you practise. That’s why every module combines a short video and annotated screens with a downloadable practice file and a quiz: you learn by doing, not just by watching.
Can ChatGPT do my Excel work for me?
AI can write formulas, macros and summaries, but only if you know what to ask and can check the result. Course 3 has two chapters on exactly this, generative AI for Excel and Copilot in Excel, so you learn to use AI as an assistant rather than a black box.
I’m a complete beginner. Is this for me?
Absolutely. Course 1 starts with getting Microsoft 365 and opening Excel for the first time. You then progress step by step, at your own pace, all the way to expert level.
I already use Excel. Will I really learn something new?
Almost certainly. Course 2 covers dynamic arrays, LET, XLOOKUP, statistical charts and what-if analysis, and Course 3 adds Power Query, Power Pivot, DAX, Copilot, Office Scripts and VBA: skills most self-taught users have never touched, and exactly the ones that make a difference at work.
Which version of Excel do I need?
The training is built on Excel for Microsoft 365, the version the MOS exams are based on. Module 1.1 shows you how to get it. Copilot requires an eligible Microsoft 365 licence; module 21.1 explains the requirements.
How is the training delivered?
100% online, here on Gnosarium. Each module combines a short video, step-by-step screens with annotated screenshots, a downloadable practice file and a quiz. You learn whenever it suits you.
When can I start?
Right away. Your access opens as soon as your purchase is complete.
What language is the training in?
The courses are in English and use the English Excel interface.
Your next job interview starts with proof.
Join the Excel training courses that prepare you for MOS and ICDL, and walk into your exam knowing exactly what to expect.