The course will cover:
- Prepare the Data Source
- Summarise Data in a PivotTable
- Functions in a PivotTable
- Filter, Group Fields
- Adding Calculated Fields
- Filter Data with Slicers
- Analyse Data with PivotCharts
Courses in this Series:
- Microsoft Excel – Formulas and Functions (A)- Tutor led training
- Microsoft Excel – More Formulas and Functions (B)- Tutor led training
- Microsoft Excel – Logical and Look-up Functions (C)- Tutor led training
- Microsoft Excel – Data Sets and Tables- Tutor led training
- Microsoft Excel – Charts- Tutor led training
- Microsoft Excel – Pivot Tables- Tutor led training