Advanced Excel: Practical Applications for Accounting Professionals (On-Demand) 2022

Description

Tap into Excel’s full potential.

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.

Learning Objectives

Understand how to automate recurring processes.
Utilize the most powerful features of Excel.
Identify which features and functions should be used for various high-level tasks.

Major Topics

Advanced PivotTables
External data ranges (ODBC)
Visual basic: macros and user-defined functions
Digital workpapers
Securing worksheets and workbooks
Named ranges
VLOOKUP and related functions, Nest Offset, Text, Match
“IF” function and other efficiency gains
Encryption and data validation

Provider

AICPA - Durham

Course Level

Advanced

CPE Field of Study

Specialized Knowledge and Applications

6.5

Who Should Attend

Accounting and finance professionals

Instructor(s)

Jeff Lenning

Prerequisites

Working knowledge of Excel

Purchase Now

When

Available 24/7

Location

Online

Total CPE Credits

6.5

Format

On-Demand

$135.00

$165.00

Become A Member

Purchase This Program