Self-Study

Advanced Excel Applications for Accounting Professionals

  • Tuesday, May 1, 2018 – Thursday, April 30, 2020

  • 5
    CREDITS
    Specialized Knowledge

A CPA designed this CPE course specifically for accounting and finance professionals who have a good grasp of Excel and want to take their skills to the next level. Learn about the features you need to achieve greater efficiency and automation. Also, each exercise presented in the book is available as an interactive Excel Workbook file, so you can follow along in Excel as you read.

Objectives

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

Highlights

  • 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

Additional Information

Designed For

Accounting and finance professionals in public practice or industry

Vendor

American Institute of CPAs

Field of Study

Specialized Knowledge

Course Number

18AIS0003

Level of Knowledge

Advanced

Add to Cart

View All Courses