Maximising Pivottable - Microsoft® Office Excel® 2010
Course Content
Module 1: Making Data Work For You
In this module students are shown a variety of lookup function and examples where lookup functions are needed. The basic knowledge given here is then extended throughout the course. The whole spectrum of functions that are explained in detail in future Modules are introduced here.
Lessons
Maximize the Power of PivotTable
Ask the Questions
Get the Answer
Module 2: A Quick Tour
This module explains how to use determine the source needed to create its PivotTable report.
Lessons
Determine What You Need to Know
Identify the Source
Creating the Pivot Table
Working with Pivot Table Layout
Module 3: Manipulating the PivotTable
This module explains how to rearrange the layout of the PivotTable.
Lessons
Rearranging the Layout
Adding New Field
Renaming a Field
Formatting Numbers
Changing Sorting Order
Showing Top 10
Refreshing Data
Module 4: Digging Deeper
This module explains how to group item, display subtotals and grandtotals within the PivotTable. It also introduce the feature of Slicer to display item in PivotTable.
Lessons
Grouping Items
Displaying Subtotals
Hiding/Showing Grand Totals
Formatting PivotTable
Using Slicer
Formatting Slicer
Module 5: Beyond the Basics
This module explains how to create a second data field and changing the summary function with the PivotTable.
Lessons
Creating Second Data Field
Changing the Summary Function
Displaying Numerical Value as a Percentage of the Total
Creating a Custom Calculation
More Function in Custom Calculation
Module 6: More PivotTable Calculations
This module explains how to insert formula within the PivotTable.
Lessons
Using Formulas
Creating a Calculated Field
Creating a Calculated Item
Using GetPivotData Function
Turn off GetPivotData Function
Module 7: Optional Topics
This module explains how to create a PivotChart, Publishing PivotTable to the Web and using multiple source range for the PivotTable.
Lessons
Creating PivotChart
Publishing PivotTable to the Web
Using Multiple Source Ranges