About This Training Course

Microsoft Excel 07/03/02/00 - Pivot Tables Training Course (1-day) course is designed to develop experience and confidence in using Excel Pivot Tables to analyse data and produce sophisticated management reports.

Learn to create and work with Pivot Tables to view and analyse your data in a variety of ways. Discover how to perform a variety of calculations with Pivot Table Data. Learn to save time by re-using Pivot Table Reports as templates. You will learn how to construct Pivot Tables and Charts to consolidate and summarise your data.

Subjects Covered

This Microsoft Excel 07/03/02/00 - Pivot Tables Training Course will cover the following subjects:

Understanding Databases and Lists
• Understanding Databases in Excel
• Sorting and Filtering Data
• Subtotals
• Grouping and Outlining
• Using a Data Form to manage data in a list
• Summarising Data with COUNTIF and SUMIF

PivotTable Fundamentals

• What is a PivotTable?
• Why should I use a Pivot Table?
• What are the advantages?
• PivotTable Terminology
• Preparing your data for use in a PivotTable

Creating a PivotTable

• Selecting the Data Source
• PivotTable Fields List
• Filterering data with Page Fields
• Adding Fields
• Removing Fields
• Understanding the Field icons

Presenting Data in PivotTables

• PivotTable Toolbar
• Hiding and Unhiding Items
• Sorting Data in a PivotTable
• Using AutoSort
• Advanced AutoSort
• Refreshing a PivotTable Report
• Inserting Data into the Data Source
• Formatting Numerical Data
• Selecting Parts of a PivotTable
• PivotTable Formats
• PivotTable Options
• Change the Summary Function
• Adding Multiple Data Fields
• Changing Calculations
• Hiding and Showing Row/Column Details
• Displaying Data Details

Grouping Data
• Grouping Data
• Group by Dates
• Group by Number
• Ungrouping Data

Calculations in PivotTables
• Changing custom calculations
• Creating Calculated Fields
• Calculated Items
• Using GetPivotData() function to extract information from the PivotTable

Using Other Sources of Data
• Selecting data from another Excel workbook
• Connecting to an Database i.e. Microsoft Access database
• Using a Saved Query as the data source
• Using a Comma-delimited text file as the source of a PivotTable

Using PivotCharts
• PivotChart terms
• Modifying the Chart
• Caution - Loss of Formatting in PivotCharts

Publishing PivotTables to the Web
• Saving a PivotTables as a web page
• Creating Interactive PivotCharts - Web
• Adding Fields to a PivotChart - Browser

Analysing Data from Multiple Ranges
• Setting up the PivotTable using multiple ranges
• Using Multiple Page Fields

Re-using PivotTables
• Requerying data
• Using Saved queries
• Automating PivotTable Updates
• Saving a PivotTable Template

Training Course Outcomes

At the end of this Microsoft Excel 07/03/02/00 - Pivot Tables Training Course participants will learn how to construct Pivot Tables and Charts to consolidate and summarise your data.

Prerequisites

Participants must be confident users of Excel who have equivalent knowledge of topics covered in an Excel 2000/2002/2003 Intermediate course

Other Information

If you need more information contact Startnextweek.com.au on 1300 728 102