Beginning Pivot Tables in Excel 2007

Table of contents

1. Title Page
2. Contents at a Glance
3. Contents
4. About the Author
5. About the Technical Reviewer
6. Acknowledgments
7. Introduction
   1. Who This Book Is For
   2. How This Book Is Structured
   3. Prerequisites
   4. Downloading the Code
   5. Contacting the Author
8. CHAPTER 1: Introducing Pivot Tables
   1. What Is a Pivot Table?
   2. Understanding the Benefits of Using Pivot Tables
   3. Preparing to Create a Pivot Table
   4. Creating an Excel Table
   5. Exploring the Excel Table Features
   6. Summary
9. CHAPTER 2: Creating a Pivot Table
   1. Exploring an Insurance Policy Example
   2. Changing the Pivot Table Layout
   3. Charting the Data in a Pivot Table
   4. Summary
10. CHAPTER 3: Modifying a Pivot Table
    1. Changing a Pivot Table
    2. Adding a Report Filter
    3. Updating the Pivot Table
    4. Changing the Summary Function
    5. Applying a PivotTable Style
    6. Deleting a Pivot Table
    7. Summary
11. CHAPTER 4: Summarizing Data
    1. Exploring a Work Orders Example
    2. Using the Summary Functions
    3. Showing or Hiding Grand Totals
    4. Creating Subtotals
    5. Grouping Numbers and Dates
    6. Summary
12. CHAPTER 5: Formatting a Pivot Table
    1. Controlling the Report Layout
    2. Adding Blank Rows in the Layout
    3. Using a Pivot Table Style
    4. Adding Row and Column Shading
    5. Formatting the Row and Column Headers
    6. Removing a Pivot Table Style
    7. Creating a Pivot Table Style
    8. Applying a Custom Pivot Table Style
    9. Modifying a Custom PivotTable Style
    10. Duplicating a Pivot Table Style
    11. Deleting a Custom Pivot Table Style
    12. Using Themes
    13. Saving the File
    14. Summary
13. CHAPTER 6: Sorting and Filtering in a Pivot Table
    1. Adding Report Filters
    2. Arranging Report Filters
    3. Clearing All Filters
    4. Moving Labels
    5. Sorting Labels
    6. Sorting Values
    7. Sorting Automatically When the Pivot Table Changes
    8. Sorting Labels in a Custom Order
    9. Filtering Row and Column Labels
    10. Viewing Filter and Sort Information
    11. Removing Filters
    12. Filtering Values
    13. Filtering for a Date Range
    14. Applying a Manual Filter
    15. Including New Items in a Manual Filter
    16. Filtering by Selection
    17. Showing Top and Bottom Items
    18. Summary
14. CHAPTER 7: Creating a Pivot Table from External Data
    1. Creating a Pivot Table from a Text File
    2. Creating a Pivot Table from an Access Query
    3. Creating a Pivot Table from an OLAP Cube
    4. Summary
15. CHAPTER 8: Updating a Pivot Table
    1. Updating an Excel Table
    2. Changing an Excel Data Source
    3. Refreshing All Pivot Tables in a Workbook
    4. Retaining Deleted Items
    5. Changing an Access Data Source
    6. Refreshing the Pivot Table Regularly
    7. Saving Source Data with the File
    8. Summary
16. CHAPTER 9: Creating Calculations in a Pivot Table
    1. Creating Custom Calculations
    2. Creating Formulas
    3. Summary
17. CHAPTER 10: Enhancing Pivot Table Formatting
    1. Applying Conditional Formatting
    2. Setting Format Options
    3. Summary
18. CHAPTER 11: Creating a Pivot Chart
    1. Creating a Default Pivot Chart
    2. Creating a Line Pivot Chart
    3. Summary
19. CHAPTER 12: Printing and Extracting Data from a Pivot Table
    1. Using the Show Details Feature
    2. Using Show Report Filter Pages
    3. Printing a Pivot Table
    4. Using the GetPivotData Function
    5. Summary
20. APPENDIX: Key Skills
    1. Downloading the Sample Files
    2. Saving a File
    3. Converting a File from an Earlier Version
    4. Sharing Files with Users of Earlier Versions
    5. Turning On the ScreenTips Feature
    6. Turning On Contextual Tips
    7. Adjusting Regional Options
    8. Adjusting Security Settings
21. Index