Certificate in Microsoft Excel

Ten modules, 96 lessons and about 14 hours of video, so most lessons fit into a lunch break. Every lesson has written notes under the video, with practice questions through the course. There are ten checkpoints of eight questions and a final assessment of twenty questions at 80 per cent, which is what issues the certificate.

Excel for Microsoft 365 is the simplest choice, because it has every function the course uses. Excel 2021 or later and the free web version also have the modern functions in module 9, such as XLOOKUP, FILTER and LET. Excel 2019 and earlier don't, but they handle most of the course.

You need Excel, though not necessarily a paid copy to start. It comes with a Microsoft 365 subscription or a one-off licence, and Microsoft's free web version, with fewer features, covers most of this course. If your team works in Google's free tools instead, Google Docs, Sheets & Slides teaches Sheets.

Start here unless you can already write a formula that fills down correctly and build a chart without help. Advanced Microsoft Excel assumes all of that and goes on to PivotTables, Power Query, macros and dashboards. If you know you want both, the Microsoft Excel Bundle includes them, along with Excel for Data Analysis.

Mostly not. Most sheets start blank: you build the times table grid, the Battleships game and the budget planner yourself. A few lessons, the gradebook among them, import a file of data, and a spreadsheet from work (with anything personal taken out) or free sample data does the job.

Yes. It starts at the very first cell, with worksheets, workbooks and the ribbon, and builds up to XLOOKUP, FILTER and LET. Each lesson is a video with written notes underneath, and the questions along the way show you what has stuck before the next module leans on it.

About 14 hours of video for the whole course, plus the time you spend building along. It's self-paced with lifetime access, so there's no deadline, and a lesson or two a day is enough to finish in a couple of months.

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