Advanced Excel: Practical Applications for Accounting Professionals (Self-Study)
Valid for one year from purchase date
Specialized Knowledge - Technical (5.0)
Standard member fee
Standard nonmember fee
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
Advanced pivot tables
External data ranges (ODBC)
Visual basic: macros and user defined functions
Securing worksheets and workbooks
Vlookup() and related functions that Nest Offset(), Text(), Match()
IF function and other efficiency gains
Encryption and data validation
Automate recurring processes
Use the most powerful features of Excel
Know which features and functions should be used for various high-level tasks
NASBA ID#: 112891