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

Description

Learn about the features you need to achieve greater efficiency and automation. Written by a CPA who is recognized by other CPAs as an Excel expert, this course is for accounting and finance professionals who have a good grasp of Excel and want to take their skills to the next level. The course now includes Excel 2016.

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

Major Topics

▪ 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

Provider
AICPA - Durham
Course Level
Advanced
CPE Field of Study
Specialized Knowledge
5
Who Should Attend
Accounting and finance professionals in public practice or industry
Instructor(s)
Jeff Lenning
Prerequisites

None.

Advanced Preparation

None.

Purchase Now
When
Available 24/7
Location
Advanced Excel: Practical Applications for Accounting Professionals (On-Demand)
Total CPE Credits
5
Format
On-Demand
Instructor
Jeff Lenning

MEMBER


$ (% off)
$139.00

NON-MEMBER


$ (% off)
$179.00
Become A Member

Purchase This Program

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


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×