Pivot Table Data Crunching for Microsoft Office Excel 2007 - page 1
- 1
- 2
- Pivot Table Data Crunching
- Pivot Table Data Crunching
- Table of Contents
- Copyright
- About the Authors
- Acknowledgments
- We Want to Hear from You
- Introduction
- What You Will Learn from This Book
- Skills Required to Use This Book
- The Invention of the Pivot Table
- Conventions Used in This Book
- Chapter 1. Pivot Table Fundamentals
- What Is a Pivot Table?
- Why Should You Use a Pivot Table?
- When Should You Use a Pivot Table?
- The Anatomy of a Pivot Table
- Pivot Tables Behind the Scenes
- Limitations of Pivot Table Reports
- Next Steps
- Chapter 2. Creating a Basic Pivot Table
- Preparing Your Data for Pivot Table Reporting
- Creating a Basic Pivot Table
- Keeping Up with Changes in Your Data Source
- Next Steps
- Chapter 3. Customizing Fields in a Pivot Table
- The Need to Customize
- Displaying the PivotTable Field Dialog Box
- Customizing Field Names
- Applying Numeric Formats to Data Fields
- Changing Summary Calculations
- Adding and Removing Subtotals
- Using Running Total Options
- Next Steps
- Chapter 4. Formatting Your Pivot Table Report
- Using AutoFormat
- Applying Your Own Style
- Setting Table Options
- Next Steps
- Chapter 5. Controlling the Way You View Your Pivot Data
- Showing and Hiding Options
- Sorting in a Pivot Table
- Producing Top 10 Reports
- Grouping Pivot Fields
- Next Steps
- Chapter 6. Performing Calculations Within Your Pivot Tables
- Introducing Calculated Fields and Calculated Items
- Creating Your First Calculated Field
- Creating Your First Calculated Item
- Rules and Shortcomings of Pivot Table Calculations
- Managing and Maintaining Your Pivot Table Calculations
- Next Steps
- Chapter 7. Creating and Using Pivot Charts
- What Is a Pivot Chart Really?
- Creating Your First Pivot Chart
- Rules and Limitations of Pivot Charts
- Alternatives to Using Pivot Charts
- Next Steps
- Chapter 8. Using Disparate Data Sources for Your Pivot Table
- Working with Disparate Data Sources
- Using Multiple Consolidation Ranges
- The Anatomy of a Multiple Consolidation Range Pivot Table
- Creating a Pivot Table from an Existing Pivot Table
- Next Steps
- Chapter 9. Using External Data Sources for Your Pivot Table
- Building a Pivot Table Using External Data Sources
- Importing and Using External Data Without the PivotTable Wizard
- Creating Dynamic Pivot Table Reporting Systems
- Pivot Table Data Options
- Next Steps
- Chapter 10. Leveraging the Power of OLAP Cubes
- Defining OLAP?
- Benefits of OLAP Cubes
- Introduction to Data Warehouses and OLAP Cubes
- Connecting to an OLAP Cube
- Working with an OLAP Pivot Table
- Comparing OLAP Cubes Pivot Tables to Excel Data
- Other Considerations When Using OLAP Cubes
- Next Steps
- Chapter 11. Enhancing Your Pivot Table Reports with Macros
- 1
- 2
Similar products
Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf)
Microsoftu00ae Office Excelu00ae 2007: Data Analysis and Business Modeling (Bpg -- Other)
Learn Excel 2007 Essential Skills with The Smart Method: Courseware tutorial for self-instruction to beginner and intermediate level
Learn Excel 2007 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques