Excel – Pivot tables Short-Shot
Course EXPT: 0.5 Days; Instructor-led by Michael Ouchi (Master Office Instructor)
PivotTables allow you to analyze huge amounts of data very quickly and easily. This short shot will give you the skillsets to create a PivotTable, PivotChart, use a Slicer to allow for easier user interaction. You will also explore the potential of the DataModel to work with multiple datasources.
- Singular datasource
- create/edit a pivot table
- use multiple fields
- Create a Pivot Chart
- Work with Slicer object
- Multiple datasources (Excel 2013 or newer)
- Intro to the Data Model
- link multiple datasource
- use DAX to create custom column or measure
- create a KPI