On-Demand

6.5 CPE

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

On-Demand
6.5 CPE

  • Instructor

    Jeff
    Lenning

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

CPE Credits Available

6.5 CPE
6.5
Specialized Knowledge

Things to Know About This Course

Course Level

  • Advanced

Prerequisites

Working knowledge of Excel

Intended Audience

Accounting and finance professionals

Provider

AICPA - Durham

This can not be purchased at this time.