product review overlay image

Product Description

Excel Intermediate – Level 1

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: Face-to-face or live online

  • Linking data between worksheets
  • Creating 3-D formulas 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: Face-to-face or live online

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

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

Learning Path

Module E + Module F = Excel Intermediate – Level 1
Half Day – 9:00am–1:00pm (face-to-face in Welwyn Garden City)

Condition
New

Customer Reviews

Excel Intermediate Module E + F

Places Available