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:
Take Your Excel Spreadsheets to the Next Level with Advanced FeaturesCOURSE ID: EXCL016L
DESCRIPTION

Chances are you use Excel on an everyday basis. If so, this course is designed to teach you a plethora of powerful features that Excel has to offer to take your data analysis and presentation to the next level. If you’re doing a lot with Excel already, this course will be invaluable because of the tools you will learn to help you build them quicker, more accurately and to provide more powerful data analysis. This IS NOT a hands-on course, but to get the most out of the presentation we recommend that you bring your laptop to follow along. The instructor example files will be available prior to class.

DESIGNED FOR: Anyone who uses Excel and wants to build better spreadsheets.FIELD OF STUDY: Accounting, Computer ScienceLEVEL: IntermediatePREREQUISITES: A good understanding of ExcelCOURSE PRODUCER: CPA CrossingsCREDITS: 8.0OBJECTIVES:
  • Upon completing this course, you will have the ability to:
  • Debug formulas and find spreadsheet errors.
  • Design spreadsheets with greater efficiency.
  • Setup spreadsheets for easy data analysis.
  • Use advanced analytical tools to present detailed data.
HIGHLIGHTS:

Some of the specific topics that will be covered include: * How to audit your spreadsheets to detect errors in formula logic. * Advanced formula building and debugging. * Best practices for setting up your spreadsheets for data analysis and reporting. * Introduction to the new Excel Power Business Intelligence tools. * Learn to use conditional formatting to make your data stand out. * Best practices for creating accurate spreadsheets. * Learn to use Pivot Tables to slice & dice your data.

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