Colorado Society of CPAs names Alicia Gelinas, CPA, President and CEO - Read More.

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

MEMBER


$ (% off)
$135.00

NON-MEMBER


$ (% off)
$165.00
Become A Member

Purchase This Program

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


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×