Intermediate & Advanced Excel for the CPA Webinar (4 Hours)


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.


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 webcast and Introduction to Excel for the CPA Webcast (4 Hours).

  • 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

None. Required: Please bring laptop with Excel installed.


No advance preparation required.

Level of Knowledge: 


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