GBP £
EUR € USD $

  • Courses

Home / Microsoft Excel
product review overlay image
Excel Pivot Tables Modules M + N Online

Product Description

Excel Pivot Tables - Modules M + N Online

A specialist course for experienced Excel users who want to work with PivotTables in greater depth. Learn how to prepare data, build powerful reports and dashboards, and automate repetitive analysis 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? FREE – Training Needs Analysis

Module M – Building & Managing PivotTables

Duration: 2 hours
Format: Live online

  • Preparing data for analysis
  • Creating PivotTables
  • Refreshing data
  • Changing the data source
  • Importing and troubleshooting data
  • Consolidating multiple sheets or ranges
  • Changing report layouts
  • Filtering, sorting and formatting

Outcome: Create reliable PivotTables from clean data and manage changing datasets with confidence.

Module N – Interactive Reporting & Dashboards

Duration: 2 hours
Format: Live online

  • Using slicers
  • Adding timelines
  • Creating calculated fields
  • PivotCharts
  • Building dashboards
  • Automating PivotTables with macros

Outcome: Build interactive dashboards and automate reporting for faster, more efficient analysis.

Learning Path

Module M + Module N = Excel Pivot Tables
Half Day – 9:00am–1:00pm Live Online

Customer reviews

No reviews left yet
Write A Review

Customer Reviews

Excel Pivot Tables Modules M + N Online

Places Available

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