Advanced Excel: Practical Applications for Accounting Professionals

*CAW Network USA member discounts applicable at checkout

If you’re comfortable using Excel, but want to take your skills to the next level, you’ve found the right course.

Written by a CPA and Excel expert, this self-study course will help you be more efficient and productive. This course covers topics including:

• Advanced PivotTables
• External data ranges (ODBC)
• Visual basic: macros and user-defined functions.
• Once you know how to tap the software’s full potential, you’ll be able to quickly and easily perform accounting and finance tasks in Excel.

CPE Credit: 6.5

Topics Discussed

• 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 Objectives

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

Who will benefit

• Accounting and finance professionals