product review overlay image

Product Description

Excel Intermediate – Module E + F Online

Designed for users who have completed an introductory course (or have equivalent knowledge) and want to build stronger, more flexible spreadsheets using decision-making functions, lookups and formatting tools. Delivered as flexible 2-hour modules that can be taken individually or combined into a half-day session.

Not sure if this course is right for you? Quick Quiz or FREE – Training Needs Analysis

Module E – Working Across Worksheets

Duration: 2 hours
Format: Live online

  • Linking data between worksheets
  • Creating 3-D formula across worksheets
  • Password protecting data
  • Creating custom number formats

Outcome: Build organised workbooks that work across multiple sheets, apply consistent formatting and protect key data.

Module F – Decision Functions, Lookups & Formatting

Duration: 2 hours
Format: Live online

  • IFS and lookup functions
  • Using nested functions
  • Predefined conditional formatting

Outcome: Use functions to make spreadsheets more intelligent, combine formula effectively and highlight key values using conditional formatting.

Learning Path

Module E + Module F = Excel Intermediate – Level 1
Half Day – 9:00am–1:00pm (Live online)

Customer Reviews

Excel Intermediate Module E + F Online

Places Available