Course ID: EXCL016L

Take Your Excel Spreadsheets to the Next Level with Advanced Features


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.


LEARNING OBJECTIVES
  • 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.

MAJOR TOPICS

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.

DESIGNED FOR
Anyone who uses Excel and wants to build better spreadsheets.

PREREQUISITES
A good understanding of Excel

COURSE PRODUCER
CPA Crossings

CPE CREDITS
8.0

LEVEL
Intermediate

This course is available to be scheduled as:

Group Live
 

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