Book description
Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.
Table of contents
- Title
- Contents at a Glance
- Copyright
- Table of Contents
- About the Authors
- Dedication
- Introduction
- 1. Pivot Table Fundamentals
- 2. Creating a Basic Pivot Table
- 3. Customizing Fields in a Pivot Table
- 4. Formatting Your Pivot Table Report
- 5. Controlling the Way You View Your Pivot Data
- 6. Performing Calculations Within Your Pivot Tables
- 7. Creating and Using Pivot Charts
- 8. Using Disparate Data Sources for Your Pivot Table
- 9. Using External Data Sources for Your Pivot Table
- 10. Leveraging the Power of OLAP Cubes
- 11. Enhancing Your Pivot Table Reports with Macros
- 12. Using VBA to Create Pivot Tables
- A. Solutions to Common Questions and Issues with Pivot Tables
- Index
Product information
- Title: Pivot Table Data Crunching
- Author(s):
- Release date: June 2005
- Publisher(s): Que
- ISBN: 0789734354
You might also like
book
Excel 2013 Pivot Table Data Crunching
CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES! Use Excel …
book
Beginning Pivot Tables in Excel 2007
Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, …
book
Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open …
book
Excel Pivot Tables Recipe Book: A Problem-Solution Approach
Excel Pivot Tables Recipe Book: A Problem-Solution Approach is for anyone who uses Excel frequently. This …