Intermediate & Advanced Excel for the CPA (4 Hours)

Overview: 

Intermediate & Advanced Excel for the CPA is specifically designed to introduce CPAs and their staff to many of the unknown or rarely used capabilities of Microsoft Excel.

Objective: 

To provide CPAs and other financial professionals with the less known capabilities of Microsoft Excel.

 

SAVE $50 when you register at the same time for this seminar and Introduction to Excel for the CPA (4 Hours).

Emphasis: 
  • Conditional formatting
  • Cell styles
  • Find and select
  • Inserting graphs, sparklines, SmartArt, hyperlinks, pictures and shapes
  • Formulas tab: using, managing and creating names, formula auditing and the Watch Window
  • The power of the SUMIF, VLOOKUP and other formulas
  • The why and how of tables: the Quick Analysis tool
  • Text to columns
  • Flash Fill
  • Data validation
  • Pivot Tables
  • The Data Model
  • Power Pivot
  • Introduction to Power View
Bottom
Prerequisite: 

None. Required: Please bring laptop with Excel installed.

Preparation: 

No advance preparation required.

Level of Knowledge: 

Intermediate.

CPE Credit: 
4.00
NASBA Field of Study: 
Computer Software & Applications