Topic outline

• Introduction

  Collapse all Expand all

  Welcome to the Advanced Excel Course!

  
  Master the tools that power professional spreadsheets.

  Are you ready to take your Excel skills to the next level? Whether you're analysing complex data, building dashboards, or streamlining tasks, this course will help you unlock Excel’s full potential.

  This advanced course is designed for those who are comfortable with the basics and intermediate tools—and now want to dive deeper. You’ll explore advanced features that support powerful data analysis, automation, and reporting, so you can work faster and more efficiently.

  In this course, you’ll learn how to:

  • Use cell references for dynamic and reliable formulas

  • Apply COUNT functions to quantify specific values in your data

  • Work with logical functions to make intelligent, rule-based decisions

  • Perform complex financial calculations like loan and investment analysis

  • Run what-if analysis using Goal Seek and Data Tables

  • Set up data validation to keep your inputs clean and controlled

  • Use filters to isolate the data that matters

  • Apply conditional formatting to visualise trends and outliers

  • Build and customise charts to represent data visually

  • Add headers and footers to enhance printed reports

  • Calculate subtotals to summarise grouped data efficiently

  • Create links between worksheets and workbooks for real-time data updates

  • Prepare for printing with professional formatting

  • Use protection tools to secure sensitive data and restrict access

  • Master freeze panes to navigate large datasets with ease

  Not available unless: You are a(n) Student

• Freeze Panes

  

  Not available unless: You are a(n) Student

• Removing Duplicates

  

  Not available unless: The activity 2 Freeze Panes Example 2 is marked complete

• Match

  

  Not available unless: The activity 3 Remove Duplicate Values is marked complete

• Logical Functions

  

  Not available unless: The activity 5 Match is marked complete

• Count

  

  Not available unless: The activity 9 Nested IF is marked complete

• Lookups

  

  Not available unless: The activity 12 CountIFS Scenario 2 is marked complete

• Tables

  

  Not available unless: The activity 17 HLookup Scenario 2 is marked complete

• Slicers

  

  Not available unless: The activity 21 Quick Analysis - Pivot Chart is marked complete

• Sparklines

  

  Not available unless: The activity 23 Applying the Slicer is marked complete

• Sheet Very Hidden

  

  Not available unless: The activity 24 Sparklines is marked complete

• Pivot Tables

  

  Not available unless: The activity 25 Very Hidden is marked complete

• Macro's

  

  Not available unless: The activity 32 Defer Layout Update is marked complete

• Assessment

  

  Not available unless: The activity 39 Edit the Macro with Visual Basic is marked complete

• Certificate of Completion
  Not available unless: The activity Quiz: Excel Advanced Assessment is marked complete