Make Excel do the heavy lifting. Sort, clean and analyse real data with the tool you already have on your desktop.
Outcomes
Curriculum
10 modules and 78 lessons, with around 35 hours of video. Work through them in order, at your own pace.
Portfolio
A certificate proves you finished. The work you build along the way is what gets you hired.
The capstone: several inconsistent files turned into one summary, three questions answered, and a scenario worked through. The course shows it done five ways, once with each tool.
A working dashboard built from dynamic array formulas and Power Query steps, so next month is a refresh rather than an afternoon.
Fit
When not to buy this course
If you have never written a formula, start with our Microsoft Excel course instead. This one assumes you already know your way around a worksheet.
Better together
All 3 for £189 instead of £297
Good to know
Some. If you can write basic formulas and move around a worksheet, you are ready. If not, our Microsoft Excel course covers those foundations first.
78 video lessons across 10 modules, about 35 hours of video, with written notes and key takeaways on every one. 49 lessons carry an interactive step, and there are 10 checkpoints of eight questions plus a 20-question final assessment. Modules 1 to 7 are data analysis; modules 8 to 10 are VBA, taught by a different presenter, and they are a genuinely separate subject.
No, and we would rather say so. The videos work from a set of practice workbooks that were not part of what we received, so the exercises are described in the notes rather than handed to you. Every technique is shown on screen and the lessons are written to be followed on your own data, which is better practice anyway because you already know what the right answer looks like.
Most of the course works on any recent version. The dynamic array module genuinely needs Microsoft 365 or Excel 2021, and Power Pivot is an add-in you switch on rather than a separate purchase. Where an older version behaves differently, the lessons say so.
Yes. Excel is where most analysts start, and this course leads naturally into SQL and Power BI. Those three together make up our Data Analyst Bundle.
Yes. When you finish, you earn a certificate employers can verify online, plus the workbooks you built as portfolio proof.
Every course comes with a 7-day money-back guarantee. If it does not fit, we refund you.
Keep exploring
Beginner
Beginner
Bundle · Best valueFree info pack
Every course side by side, with prices and career pathways, so you can decide in your own time.
