Duration
1 day
Lesson 1: Make Your Data Work for You
Maximize the Power of PivotTable
Ask the Questions You Choose
Get the Answers You Want
Lesson 2: A Quick Tour
Determine what you want to know
The source is important
Ready, set, go!
The PivotTable layout
What goes where
Our PivotTable Report
Viewing our data differently
Practice 2
Additional Practice 2
Lesson 3: Manipulating PivotTable
Rearrange the layout
What We Get
Add a new field
Remove A Field
Rename A Field
Format Numbers
Change the Sort Order
Refresh Data
Practice 3
Additional 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
Format A Slicer
Practice 4
Additional Practice 4
Lesson 5: Beyond The Basics
Create a Second Data Field
Count The Orders
Display Numerical Data As A Percentage Of The Total Dollars Sold
Create a Custom Calculation
Practice 5
Additional Practice 5
Lesson 6: More PivotTable Calculations
Using Formulas
Calculated Field
Calculated Item
Use GETPIVOTDATA Function
Turn GETPIVOTDATA Function Off
Practice 6
Additional Practice 6
Lesson 7: Optional Topics
Create a PivotChart Report
Publish PivotTable Reports to the Web
Use Multiple Ranges as Source Data
Practice 7
Programme scope, delivery arrangements and suitability are confirmed during enquiry.