You are previewing Beginning Pivot Tables in Excel 2007.
O'Reilly logo
Beginning Pivot Tables in Excel 2007

Book Description

Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data.

  • Carefully explains the benefits of using Pivot Tables for fast data analysis

  • Provides a step-by-step approach to those new to Pivot Tables

  • Offers tips and tricks that cannot be found elsewhere

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