Advanced Certificate in Microsoft Excel

Twelve modules, 125 lessons and about 30 hours of video, with written notes under every lesson and practice questions throughout. The longer walkthroughs are split into parts, with questions in between. The first half is formulas, and from module 6 the second half makes a correct sheet readable. There are twelve checkpoints of eight questions and a final assessment of twenty questions at 80 per cent, drawn from both halves of the course, which is what issues the certificate.

You are if you can already enter data, write a basic formula such as SUM and build a simple chart without help. Module 1 tightens up references and error values before anything leans on them. If formulas and references still feel shaky, start with our Microsoft Excel course.

Yes, for the whole course. Power Query and macros need the desktop app, which comes with Microsoft 365 or a one-off licence, though free Excel for the web covers much of the rest.

This course goes deep on Excel itself: formulas, lookups, PivotTables, charts and dashboards. Excel for Data Analysis is about answering business questions from a dataset, with Power Query, Power Pivot, dynamic arrays and VBA doing the work. If you want both, the Microsoft Excel Bundle puts them together.

Yes, your own spreadsheets or free sample data. You build as you watch, the module 5 dashboard included, and practising on a report you really produce at work is closer to the job anyway.

You'll record your first macros, store them where they belong and read the code they produce, which is the practical start of automation. It isn't a programming course: if you want to write VBA yourself, Excel for Data Analysis goes further.

Yes. Pass the twenty-question final assessment at 80 per cent and you get the Advanced Certificate in Microsoft Excel, an OBA certificate of completion that an employer can verify online. It isn't a Microsoft certification. The dashboards and reports 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.