This course looks at both basic and advanced features of Excel's PivotTable tool, which can be used to rearrange and summarise huge data sets efficiently, negating the need for complex formulas. You will also explore PowerPivot, one of Excel's most popular power tools. Equipped with its own language, PowerPivot enables you to analyse data across multiple tables or data sets, from different data sources.
This course will enable you to:
- use basic filters and sort data on multiple levels
- extract subsets of data
- set up a pivot table and apply summaries and calculations to it
- create and modify a pivot chart
- use Data Analysis Expressions (DAX)