SS724  |  On Demand  |  Advanced  |  Self-Study

Advanced Excel: Practical Applications for Accounting Professionals

Thursday, March 1, 2018 - Tuesday, April 30, 2019

Download to calendar

A CPA designed this CPE course specifically for accounting and finance professionals who have a good grasp of Excel and want to take their skills to the next level. Learn about the features you need to achieve greater efficiency and automation. Also, each exercise presented in the book is available as an interactive Excel Workbook file, so you can follow along in Excel as you read.

Objectives

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

Instructors


Designed For

Accounting and finance professionals in public practice or industry


Highlights

  • 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

Your Price: $179.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations.

Members log in and save $40.00 on this event. Not a member? join today.


Instructors

Jeff S. Lenning

Jeff Lenning, CPA, CITP, of Click Consulting, Inc., is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. His firm specializes in providing computer consulting services to CPA firms and their clients.


Register for this course