Learn how to use PivotTable and filtering to summarise large amounts of data efficiently.
Description
This course introduces PivotTable, filtering, Slicer and other features to give you the tools to summarise large amounts of data efficiently. It also covers how to apply calculations to the data in PivotTables in the form of summary functions and custom calculations.
Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Learning objectives
- Use calculations in PivotTable reports
- Filter data in PivotTable reports
- Create and use slicers
- Identify the functions of elements of the PowerPivot interface
- Identify the features of PowerPivot for Excel add-in
- Change functions in PivotTable reports
- Create your own formula in a PivotTable report
- Enable multiple filters and apply a Report filter
- Use slicers to filter data in a PivotTable report
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level