Course ID: EXCLDATA

Microsoft Excel: Data Analysis, New Table Features, and Pivot Table Enhancements

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

DESIGNED FOR
Accountants needing to enhance their Excel skills

FIELD OF STUDY
Computer Science

PREREQUISITES
Familiarity with Excel

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
2.0

LEVEL
Intermediate

This course is available for your group as:

Webcast
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org