Digital Office SkillsIntermediateOnline

Microsoft Excel Intermediate

Step up to pivot tables, lookups, validation and multi-sheet workbooks in Excel.

About this program

The bridge between everyday Excel and true power use. You work with nested and lookup functions, named ranges, data validation, conditional formatting, pivot tables and workbooks that link several sheets together.

What you'll walk away with

  • Use lookup, logical and text functions with confidence
  • Summarise data quickly with pivot tables and charts
  • Protect data quality with validation and conditional formatting
  • Build multi-sheet workbooks that stay consistent