Beginning Pivot Tables in Excel 2007: From Novice to Professional (Paperback)

Description

Beginning Pivot Tables in Excel 2007 explains what Pivot Tables 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

What you’ll learn

• Summarize thousands of records in a Pivot Table with a few clicks of the mouse.
• Quickly change the Pivot Table layout to view a different summary of the data.
• Filter a Pivot Table to focus on one region or the top 10 products.
• Add colors or icons to highlight the high or low results.
• Use calculations to enhance the Pivot Table summaries.
• Create visual impact with a pivot chart.