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