One of the most powerful tools that Excel 2010 provides is a PivotTable that allows you to dynamically reorganise and display your data. PivotTables can summarise huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganising your spreadsheet. This course will introduce you to PivotTables and show you the many benefits they provide.

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

  • Create a PivotTable report
  • Rearranging data in PivotTable reports
  • Customise PivotTable reports
  • Modify a PivotTable report's design

Audience

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.

Individuals and business users with basic computer literacy

60 Minutes

365 Days

loading...