Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
1. Pivot Table Basics
Downloading the Sample Workbook
Data Requirements for Pivot Tables
Creating Pivot Tables
Laying Out Pivot Tables
Refreshing Pivot Tables
Formatting Pivot Tables
Showing a Value’s Source Data
Changing a Pivot Table’s Source Data
2. Nesting Fields
Adding Nested Fields
Showing and Hiding Levels
3. Grouping Items
Grouping by Selected Items
Grouping by Time Periods
Grouping by Numbers
4. Calculations and Custom Formulas
Calculating Common Statistics
Calculating Multiple Statistics
Adding Custom Calculations
5. Filtering Data
Report Filters
Slicers
Group Filters
6. Charting Pivot Tables
Creating Pivot Charts
Customizing Pivot Charts
7. Tricks with Pivot Tables
Creating a Frequency Tabulation
Unlinking a Pivot Table from its Source Data
Converting a Summary Table to a List
Controlling References to Pivot Table Cells
Replicating a Pivot Table for Report Filter Items
Sorting a Pivot Table Manually
← Prev
Back
Next →
← Prev
Back
Next →