GBP £
EUR € USD $

  • Courses

Home / Microsoft Excel
product review overlay image
Excel Intermediate Module G + H Online

Product Description

Excel Intermediate Module G + H Online

Designed for users who want to improve workbook control, accuracy and presentation using advanced referencing, validation, sorting 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 G – Advanced References & Data Control

Duration: 2 hours
Format: Live online

  • Mixed referencing
  • Worksheet-specific named ranges
  • Data validation
  • Data validation using INDIRECT

Outcome: Build more reliable spreadsheets, control user input and create structured workbooks that reduce errors.

Module H – Sorting, Filtering & Professional Formatting

Duration: 2 hours
Format: Live online

  • Custom conditional formatting – Watch Video
  • Sorting by colour
  • Sorting using a custom list
  • Advanced filtering with AutoFilter – Watch Video
  • Styles and templates

Outcome: Analyse data more efficiently and produce consistent, professional-looking spreadsheets using sorting, filtering and custom styles.

Learning Path

Module G + Module H = Excel Intermediate – Level 2
Half Day – 9:00am–1:00pm (Live online)

Customer reviews

No reviews left yet
Write A Review

Customer Reviews

Excel Intermediate Module G + H Online

Places Available

© Clearwater IT Training
Pay with American ExpressPay with CirrusPay with DeltaPay with MaestroPay with MastercardPay with VisaPay with Visa Electron