November 22, 2022


4 Total CPE Credits


Excel Essentials for Today's Accountant: How To Become an Expert in One Day - NEW

Learning Objectives

  • Apply a variety of advanced formulas to analyze and manipulate data
  • Identify solutions to data analysis problems
  • Identify how Excel can be used as a tool to address data analysis problems you encounter in your professional and personal endeavors
  • Evaluate lesser-known but powerful Excel functions
  • Assess your mindset of professional skepticism that helps you explore the edges of Excel’s capabilities

Major Topics

  • Using formulas to manipulate and transform data
  • Using formulas and reference formulas such as =VLOOKUP
  • Using pivot tables
  • Understanding Solver to perform multivariate analysis
  • Awareness of advanced functions
  • Creative methods for data manipulation
  • Using intellectual curiosity and professional skepticism to develop a problem-solving mentality
  • Real-life examples of innovative ways to analyze and report data with Excel
  • Using Excel to perform e-mail merges
  • Enhance creativity in your approach to developing Excel models Computer software and application 

CPE Credits Available

Total CPE

Things to Know About This Course

Course Level

  • Intermediate


A high level of proficiency with Microsoft Excel

Advanced Preparation


Intended Audience

Practitioners, members in industry and other accounting professionals a better understanding of the advanced features of Microsoft Excel



This event has ended.