1. Pivot Table Basic
- A View of the Pivot table Report
- Create a Pivottable Report from an Excel List
- Change the Layout of a Pivot Table
- Filter a Field
2. Presenting and Customizing Data under Pivot Table
- Group Pivot table Data Items
- Changing Summary Calculations
- Adding and Removing Subtotals
- Add Another Data Area Calculation
- Change the Calculation of a Data Field
3. Getting more from Pivot Table
- Add a Calculated Field
- Add a Calculated Item
- Retrieve a Value from a Pivot table Report
4. Setting Table Options
5. Pivot Charts
- Creating a Pivot Chart
- Layout Optimization
- Chart Limitations
6. Disparate and External Data Sources
- Disparate Data Sources
- Multiple Consolidation Ranges
- Importing & Exporting Data
7. OLAP Cubes
- Data Warehouses
- Connecting to an OLAP
- OLAP Pivot Table
|
