Microsoft Excel: Data Analysis,New Table Features and Pivot Table Enhancements
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
Upon completion of this webcast, participants will be able to:
Become proficient with "need to know data analysis features in MS Excel 2010 or 2007 (The features covered also apply to Excel 2013 and 2016. ) 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
Provider
Business Learning Institute
Course Level
Intermediate
Professional Area of Focus
Technology
CPE Field of Study
Computer Science*
2
Who Should Attend
Accountants needing to enhance their Excel skills.
