product review overlay image

Product Description

Excel Advanced – Modules I + J

Designed for experienced Excel users who want to analyse larger datasets, create professional reports and automate repetitive tasks. 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 I – Data Analysis & Reporting

Duration: 2 hours
Format: Face-to-face or live online

  • Using Advanced Filter to copy data to a new location
  • Using Automatic Subtotals
  • Creating PivotTable reports
  • Creating PivotChart reports

Outcome: Analyse large datasets quickly and summarise information into clear, meaningful reports and dashboards.

Module J – Modelling & Automation

Duration: 2 hours
Format: Face-to-face or live online

  • Using Goal Seek and Solver
  • Scenario Manager
  • Recording a simple macro
  • Automating repetitive tasks

Outcome: Build smarter spreadsheets, test different scenarios and automate everyday processes to save time.

Learning Path

Module I + Module J = Excel Advanced – Level 1
Half Day – 9:00am–1:00pm (face-to-face in Welwyn Garden City)

Condition
New

Customer Reviews

Excel Advanced Modules I + J

Places Available