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 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.
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.