CONTACT THE BUSINESS LEARNING INSTITUTE
Name*
Email Address*
Phone Number:
Message:
Please enter the following text in the box below:
captcha
ADDRESS: 901 Dulaney Valley Road, Suite 800
Towson, MD 21204
PHONE: 888-481-3500
FOLLOW BLI:
Microsoft Excel: Data Analysis, New Table Features, and Pivot Table EnhancementsCOURSE ID: EXCLDATA
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.

DESIGNED FOR: Accountants needing to enhance their Excel skillsFIELD OF STUDY: Computer ScienceLEVEL: IntermediatePREREQUISITES: Familiarity with ExcelCOURSE PRODUCER: Business Learning InstituteCREDITS: 2.0OBJECTIVES:
  • 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
HIGHLIGHTS:

* 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

Download the 2016 Business Learning Institute Course Catalog DOWNLOAD PDF
Business Learning Institute - Course Catalog
SUBSCRIBE TO THE BLI BLOG