Microsoft Excel: Data Analysis,New Table Features, and Pivot Table Enhancements (17W009-15)
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 2010 or 2007 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
Understand 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
Learn new strategies to find
duplicates with Conditional Formatting and AutoFilter
Incorporate the
new Table feature in your work to save time updating lists
Understand
the rules for working successfully with Excel lists and test data for
accuracy
Apply automatic subtotals and copying visible cells only
Use new Pivot Table calculating enhancements and report layout features
