Loading
Loading
Technology & AI courses
Intermediate levelThis Excel for data analysis course turns the spreadsheet already on your desktop into a proper analysis tool. You'll clean raw exports, summarise them with pivot tables, reshape and combine files in Power Query, model them in Power Pivot and build reports from dynamic array formulas, then write VBA that does the monthly clicking for you. By the end, next month's report is a refresh, not an afternoon.
Course overview
This course takes you from tidying a raw export to answering a manager's questions five different ways. Ten modules and about 35 hours of video: the first seven are data analysis, from pivot tables through Power Query, Power Pivot and dynamic arrays to a capstone solved once with each tool. The last three are VBA, so Excel starts doing the repetitive work itself.
By the end you can check a dataset before you trust it, pick the right tool for the question in front of you, and build reports that update themselves when the data changes. You'll also have macros that build, save and tidy workbooks at the press of a button. If your week involves rebuilding the same report from the same export, this is the course that ends it.
Free course guide
Every module and what it covers, the price, how you're assessed and where the course can take you.
10-page PDF, free
Curriculum
10 modules and 78 lessons, with around 35 hours of video. Work through them in order, at your own pace.
Key benefits
Everything you need to learn the skill, prove it and put it to work.
All 3 for £189 instead of £297
Getting started
There is no application, no waiting for a start date and no sales call in the way.
Pay once. Instant access, yours for life.
Career outcomes
Analyst roles are won by turning a messy file into an answer you've checked a second way, and that's exactly what this course drills. The certificate opens the conversation, and a workbook you can walk an interviewer through shows your working.
Source: National Careers Service (gov.uk), September 2026.
An example of the certificate for the Certificate in Excel for Data Analysis.
If you've never written a formula, start with Microsoft Excel and come back to this one next. And if what you really want is dashboards other people click through, Power BI will get you there sooner.
A course advisor will talk it through with you free, and will say so if a different course fits your goal better.
Good to know
Ten modules, 78 lessons and about 35 hours of video. Every lesson carries a written summary, notes and a key-takeaways panel, and 48 of them carry an interactive step. There are ten checkpoints of eight questions and a final assessment of twenty questions at 80 per cent, which is what issues the certificate.
Modules 8 to 10 get Excel doing the repetitive work for you. You'll record and read your first macros, build menus and controls, write code that opens, saves and tidies workbooks, use variables and data types properly, and structure it all into procedures. They pick up where the analysis modules stop, and the final assessment draws on both.
Microsoft 365 covers everything. Excel 2021 handles the core dynamic array formulas, while the newer ones such as TEXTSPLIT need 365 or Excel 2024. The Power Pivot lessons need Excel for Windows, because Excel for Mac doesn't include Power Pivot.
Yes. You need desktop Excel, which comes with a Microsoft 365 subscription or a one-off licence. The free web version won't run Power Pivot or VBA, so it isn't enough. If you'd rather not pay for software at all, our SQL course is another route into analysis, and the software it uses is free.
Advanced Microsoft Excel if you want sharper formulas, charts and dashboards. Excel for Data Analysis if you want to take raw data apart with Power Query, Power Pivot and dynamic arrays, then automate the repeats with VBA. Advanced Microsoft Excel takes a first look at Power Query and VBA, and this course goes much further with both, which is why the Microsoft Excel Bundle includes the two courses.
Yes: a spreadsheet of your own or a free public dataset. The notes set out every exercise in words you can follow on your own data, which makes for better practice, because you already know what the right answer should look like.
It's built for people who know the basics. If you can write a basic formula and move around a worksheet, you're ready, and the first module tunes up your lookups and nested formulas before the analysis starts. If not, our Microsoft Excel course covers those foundations first.
Yes. Pass the twenty-question final assessment at 80 per cent and you get an OBA certificate of completion that an employer can verify online. It isn't a Microsoft certification such as the Microsoft Office Specialist exams. The workbooks you build along the way are the other half of the proof.
Download the free info pack first. It walks you through every module, what you'll build and what you need before you start, so you can enrol knowing exactly what you're getting. If you'd like to talk it through, get in touch and we'll help you choose.
Free guides
What data analysts actually do, the skills to learn and in what order, whether you need a degree, what the job pays, and a six-step plan you can start this week.
9 min read
Use XLOOKUP if everyone who opens the file has a recent version of Excel. Here's how both functions work, the four traps VLOOKUP sets, and when the old one still earns its place.
8 min read
Keep exploring
Beginner
Beginner
Beginner
Beginner
Free info pack
Every module, the price, how you're assessed and where it can take you. Yours free, and it opens straight away.
Takes 30 seconds
