Product Image

Advanced Excel: Practical Applications for Accounting Professionals

Author/Moderator: Jeff Lenning, CPA, CITP
Publisher: AICPA
Availability: Varies by Format (See Below)
See Below To Add To Cart
View Online Catalog
Print This Page
Available Formats:  Text | On-Demand | See All

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.

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

Learning Objectives
When you complete this course you will be able to:

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

Who Will Benefit?
Accounting and finance professionals in public practice or industry

Prerequisite: Working knowledge of Excel.

Advanced Preparation: None

NASBA Field of Study: Specialized Knowledge and Applications
Level: Advanced
Recommended CPE Credit: Text - 8.5; On-Demand - 7.5
Advanced Excel: Practical Applications for Accounting Professionals
Text , 2015
Product# 745756
Availability: In Stock
AICPA Member:$239.00
Your Price:$299.00
Advanced Excel: Practical Applications for Accounting Professionals
CPE On-Demand , 2015
Product# 163141
Availability: Online Access 1 Year
For registered users only
AICPA Member:$209.00
Your Price:$269.00
To receive your AICPA member discount, Sign In now, or Register using your AICPA membership number.