Excel Pivot Tables and Data Analysis

Course Content

Holding Data in Excel
Sorting data
Filtering data
Creating sub totals within the datasheet
Using the Excel data Form
Getting Started with Pivot Tables
Creating a pivot table
Fields to create row headings
Fields to create column headings
Data in the summary area
Dynamically building a pivot table
Rearranging fields in a pivot table
Number formatting of the data area
Creating more than one pivot table on the same data
Moving pivot tables from one sheet to another or around the same sheet
Deleting a pivot table
Connecting to an External Source
Sorting and Filtering
Drilling down into a summary value
Carrying out a top ten only
Sorting the rows by values of the data
Filtering to exclude values in rows or columns
Using the page filter option
Formatting
Grouping and hiding of multiple row/column groupings
Removing autoFormat
Autoformat
Pivot Table Options
Turning off the summary rows and columns
Activating automatic refresh options
Refreshing a pivot table
Dealing with empty cells
Advanced Options
Setting the number format for a calculated field
Limitations on calculated fields
Adding a calculated field to a pivot table
Creating calculating fields
Pivot Charts
Using the table options seen earlier on the chart
Exploring the chart options
Changing the chart type
Using a pivot chart as opposed to a normal chart
A picture tells a thousand words