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
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.
More in this category
Microsoft Excel
1 day
Microsoft Excel
1 day
Microsoft Excel
2 days