Advanced Certificate in Microsoft Excel

• XLOOKUP from the ground up
• INDEX and MATCH, and when to prefer them
• Handling errors and missing values

• Building and rearranging pivot tables
• Grouping, filtering and slicers
• Calculated fields and pivot charts

• FILTER, SORT and UNIQUE
• Spill ranges and how they behave
• Combining arrays into live reports

• Importing from files and folders
• Cleaning and reshaping data with repeatable steps
• Refreshing a report in one click

• Recording your first macro
• Editing recorded macros safely
• Knowing what to automate, and what to leave alone

• Data validation and protection
• Auditing and fixing broken formulas
• Your portfolio report, end to end

It picks up where everyday Excel ends: lookups, pivot tables, dynamic arrays, Power Query and the first steps into macros. If you can already build a basic spreadsheet with formulas and charts, you are ready.

For much of the course the free web version works, but Power Query and macros need the desktop app, which comes with a Microsoft 365 subscription or a one-off licence.

No. This course goes deep on the tool itself. Excel for Data Analysis focuses on analysing datasets and answering business questions. They sit together in the Microsoft Excel Bundle for a reason: many learners take both.

You will record and edit basic macros, which is the practical start of automation. This is not a full programming course, and for most office jobs recorded macros cover the real need.

Yes. You earn the Advanced Certificate in Microsoft Excel, and employers can verify it online. The reports you build during the course are the other half of the proof.

Every course has a 7-day money-back guarantee. Try it, and if it does not fit, we refund you.