Currently, all CPE and networking events are offered virtually only. Visit our updated catalog »

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

Description

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), and 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.

Format: Slides, No Audio

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
Online
Total CPE Credits
5
Format
On-Demand

MEMBER


$ (% off)
$165.00

NON-MEMBER


$ (% off)
$205.00
Become A Member

Purchase This Program

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


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×