IN-STEP V.I.S.I.O.N. - Excel Interactive Dashboard Mastery

1 day

HRD Corp claimable

Runs in-house for your team

Overview

This workshop shows executives, managers, analysts, administrators and finance staff how to turn raw Excel data into reports and interactive dashboards with PivotTables.

The first session covers data preparation and why a table makes a better PivotTable source than a plain range. Participants then sort, filter and refresh reports, change layouts and grand totals, pull values out with GETPIVOTDATA and group text, dates and numbers. The final session adds slicers, timelines and PivotCharts, with a chart title that updates through an Excel formula.

The end result is a dashboard in which one slicer controls several reports.

Module topics

  • Preparing data for PivotTables
  • Inserting PivotTables and fields
  • Sorting and filtering PivotTable reports
  • Report layouts and grand totals
  • GETPIVOTDATA and grouping
  • Slicers and timelines
  • PivotCharts and interactive chart titles

Who runs this programme

Anne Hui San Teoh

Excel, Power Query and Copilot trainer

At a glance

1 day

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry