Lesson 1 - Make Your Data Work For You
Maximize The Power of Pivot Table
Ask the Questions
Get The Answers
Review 1
Lunch
Lesson 2 - A Quick Tour
Determine What You Need To Know
The Source is Important
Ready, Set, Go
The PivotTable Layout
What Goes Where
Result of our PivotTable
Viewing Our Data Differently
Review 2
Practice 2
Lesson 3: Manipulating The Pivot table
Rearrange The Layout
What We Get
Add a New Field
Remove a Field
Rename A Field
Format Numbers
Change the Sort Order & Top 10 AutoShow
Refresh Data
Review 3
Practice 3
Lesson 4 – Digging Deeper
Create a Quarterly Group
Group Data Manually
Display Subtotals
Hide / Display Grand total
Format a PivotTable Report
Use a Slicer
:: Course 50448A ::
Format a Slicer
Review 4
Practice 4
Lesson 5 - Beyond The Basics
Creating a Second Data Field
Use Count To Summarize Data
Display Numerical Data as a Percentage of the Total
Create a Custom Calculation
More Functions in Custom Calculation
Review 5
Practice 5
Lunch
Lesson 6 - More Pivottable Calculations
Using Formulas
Create a Calculated Field
Create a Calculated Item
Use PivotTable Data Outside the Report
Use GETPIVOTDATA Function
Turn off GetPivotData Function
Review 6
Practice 6
Lesson 7 - Optional Topics
Create a PivotChart Report
Publish PivotTable Reports to the Web
Use Multiple Ranges as Source Data
Review 7
Programme scope, delivery arrangements and suitability are confirmed during enquiry.