WEBCAST :Microsoft Excel: Data Analysis New Table Features and New Pivot Table Enhancements (17W395-12)
Description
Tips covered in this program help you achieve mastery over many Excel
data analysis features, including Pivot Tables, and will save you time
each day. As a Microsoft Certified Trainer and CPA, Judy Borsher
enthusiastically shows you how to use many of the time-saving “need to
know” data analysis features in Excel.
Learning Objectives
Become proficient with "need to know data analysis features in MS
Excel 2007 or 2010 including identification of duplicates, automatic
subtotals, the new Table feature, new features in AutoFilter, Pivot
Table enhancements and functions for testing data in lists
Learn Excel
shortcuts and tips
Major Topics
Understanding some of the most valuable productivity features related
to analyzing data in lists in any version of Excel
Generate reports
using the time-saving Pivot Table Report Filter
New strategies to find
duplicates with Conditional Formatting and AutoFilter
Incorporate the
new Table feature in your work to save time updating lists
Understanding the rules for working successfully with Excel lists and
test data for accuracy
Applying automatic subtotals and work on
visible cells only
Using new Pivot Table calculating enhancements and
report layout features.
