Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Debra Dalgleish
Beginning Pivot Tables in Excel 2007
Title Page
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Who This Book Is For
How This Book Is Structured
Prerequisites
Downloading the Code
Contacting the Author
CHAPTER 1: Introducing Pivot Tables
What Is a Pivot Table?
Understanding the Benefits of Using Pivot Tables
Preparing to Create a Pivot Table
Creating an Excel Table
Exploring the Excel Table Features
Summary
CHAPTER 2: Creating a Pivot Table
Exploring an Insurance Policy Example
Changing the Pivot Table Layout
Charting the Data in a Pivot Table
Summary
CHAPTER 3: Modifying a Pivot Table
Changing a Pivot Table
Adding a Report Filter
Updating the Pivot Table
Changing the Summary Function
Applying a PivotTable Style
Deleting a Pivot Table
Summary
CHAPTER 4: Summarizing Data
Exploring a Work Orders Example
Using the Summary Functions
Showing or Hiding Grand Totals
Creating Subtotals
Grouping Numbers and Dates
Summary
CHAPTER 5: Formatting a Pivot Table
Controlling the Report Layout
Adding Blank Rows in the Layout
Using a Pivot Table Style
Adding Row and Column Shading
Formatting the Row and Column Headers
Removing a Pivot Table Style
Creating a Pivot Table Style
Applying a Custom Pivot Table Style
Modifying a Custom PivotTable Style
Duplicating a Pivot Table Style
Deleting a Custom Pivot Table Style
Using Themes
Saving the File
Summary
CHAPTER 6: Sorting and Filtering in a Pivot Table
Adding Report Filters
Arranging Report Filters
Clearing All Filters
Moving Labels
Sorting Labels
Sorting Values
Sorting Automatically When the Pivot Table Changes
Sorting Labels in a Custom Order
Filtering Row and Column Labels
Viewing Filter and Sort Information
Removing Filters
Filtering Values
Filtering for a Date Range
Applying a Manual Filter
Including New Items in a Manual Filter
Filtering by Selection
Showing Top and Bottom Items
Summary
CHAPTER 7: Creating a Pivot Table from External Data
Creating a Pivot Table from a Text File
Creating a Pivot Table from an Access Query
Creating a Pivot Table from an OLAP Cube
Summary
CHAPTER 8: Updating a Pivot Table
Updating an Excel Table
Changing an Excel Data Source
Refreshing All Pivot Tables in a Workbook
Retaining Deleted Items
Changing an Access Data Source
Refreshing the Pivot Table Regularly
Saving Source Data with the File
Summary
CHAPTER 9: Creating Calculations in a Pivot Table
Creating Custom Calculations
Creating Formulas
Summary
CHAPTER 10: Enhancing Pivot Table Formatting
Applying Conditional Formatting
Setting Format Options
Summary
CHAPTER 11: Creating a Pivot Chart
Creating a Default Pivot Chart
Creating a Line Pivot Chart
Summary
CHAPTER 12: Printing and Extracting Data from a Pivot Table
Using the Show Details Feature
Using Show Report Filter Pages
Printing a Pivot Table
Using the GetPivotData Function
Summary
APPENDIX: Key Skills
Downloading the Sample Files
Saving a File
Converting a File from an Earlier Version
Sharing Files with Users of Earlier Versions
Turning On the ScreenTips Feature
Turning On Contextual Tips
Adjusting Regional Options
Adjusting Security Settings
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset