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.
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level