MyWSCPA | Contact Us |News & Commentary
Advanced Excel: Practical Applications for Accounting Professionals

Advanced Excel: Practical Applications for Accounting Professionals

Quick Overview
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.

Credits - 5.00
Cart
My Cart

Price: 199.00
Required

Author(s)

Jeff Lenning, CPA, CITP

Field(s) of study

Specialized Knowledge and Applications

Level of difficulty

Advanced

Topics discussed

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

Objectives

Automate recurring processes, Use the most powerful features of Excel, Know which features and functions should be used for various high-level tasks

Designed for

Accounting and finance professionals in public practice or industry