Advanced Excel: Practical Applications for Accounting Professionals (Self-Study)

Code: JI163143

Date Valid for one year from purchase date
Format Self-Study (On-Demand)
CPE credits CPE 5.0
of study
Specialized Knowledge - Technical (5.0)
Standard member fee $139.00
checkmarkStandard nonmember fee $179.00

Members: Please log in to receive member fee.


Learn about the features you need to achieve greater efficiency and automation. Written by a CPA who is recognized by other CPAs as an Excel expert, this course is for accounting and finance professionals who have a good grasp of Excel and want to take their skills to the next level. The course now includes Excel 2016.

Who should take this program?

Accounting and finance professionals in public practice or industry

Major subjects

  • Advanced pivot tables
  • External data ranges (ODBC)
  • Visual basic: macros and user defined functions
  • Digital workpapers
  • Securing worksheets and workbooks
  • Named ranges
  • Vlookup() and related functions that Nest Offset(), Text(), Match()
  • IF function and other efficiency gains
  • Encryption and data validation

Learning objective(s)

  • Automate recurring processes
  • Use the most powerful features of Excel
  • Know which features and functions should be used for various high-level tasks


Course code Code JI163143
Sponsor AICPA
NASBA ID#: 112891
Level Advanced
Format Self-Study (On-Demand)
Prerequisites Prereq. None