Short Course

Microsoft 365 Excel – Level 3

ShortMSO-XL3

Advanced Excel skills set you apart in any reporting, finance or analysis role. Microsoft Excel Level 3 develops the analysis and automation skills you need to build accurate, efficient workbooks and to produce reports that decision makers trust.

In this course, you will learn advanced and nested functions, and what-if analysis tools such as Goal Seek, Scenarios and Data Tables. You will also master advanced PivotTable techniques, import, clean and consolidate data from different sources, audit formulas to find and fix errors, and record and run macros to automate repetitive tasks.

Microsoft Excel Level 2, or equivalent experience, is recommended before you begin. On completion, you will be equipped for roles such as Reporting Analyst, Data Analyst, Financial Analyst and Management Accountant Assistant. Become the Excel expert in your organisation and book your place today.

What you'll learn
  • Advanced and nested functions
  • What-if analysis: Goal Seek, Scenarios and Data Tables
  • Advanced PivotTable techniques
  • Importing, cleaning and consolidating data
  • Auditing formulas and finding errors
  • Recording and running macros
Useful for Roles Such As
  • Reporting Analyst
  • Data Analyst
  • Financial Analyst
  • Management Accountant Assistant
Programme details
Entry
Microsoft Excel – Level 2 or equivalent experience.
Accreditation
Certificate of Completion
Delivery
Full-time, part-time, or online · Umhlanga Ridge campus
Related programmes

← Browse the full programmes & qualifications catalog