Duration
1 day
Outline
9:00am-10:30am
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
10:30am-10:45pm Morning Break
10:45pm-12:30pm
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
12:30pm-1:30pm Lunch
1:30pm-3:30pm
Lesson 4: Digging Deeper
- Automatic Time Grouping
- 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
3:30pm-3:45pm Afternoon Break
3:45pm-5:00pm
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
- Drill-Down PivotChart
- Publish PivotTable Reports to the Web
- Practice 7
Programme scope, delivery arrangements and suitability are confirmed during enquiry.