In Excel 2007: Pivot Tables for Data Analysis, Microsoft Most Valuable
Professional Curt Frye helps dispel the common fear of the Pivot Table
feature, by demonstrating how to use this powerful tool to discover
valuable business intelligence. Curt shows how to create Pivot Table
reports from internal Excel data and outside data sources, use filters
to focus on the most important data in the sheet, and make visual
presentations of data using Pivot Chart reports.
Exercise files accompany this course.
Topics include:
* Sorting across data sources to show relative importance
* Adding, removing, and positioning subtotals and grand totals
* Creating conditional formats to highlight subsets of data
* Using color scales to emphasize specific information
* Adding a trendline to a PivotChart report
* Updating and refreshing PivotTable data sources
Download File Size:201.82 MB