Product Image

Advanced Excel: Practical Applications for the Accounting Professional

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

A CPA designed this 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 (download at clickconsulting.com), 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

Prerequisite: Working knowledge of Excel and some practical application experience.

Advanced Preparation: None

NASBA Field of Study: Specialized Knowledge and Applications
Level: Advanced
Recommended CPE Credit: Text - 10; On-Demand - 9.5
Advanced Excel: Practical Applications for the Accounting Professional
Text , 2014
Product# 745755
Availability: In Stock
Regular:$193.75
AICPA Member:$155.00
Your Price:$193.75
Advanced Excel: Practical Applications for the Accounting Professional
CPE On-Demand , 2014
Product# 163140
Availability: Online Access 1 Year
For registered users only
Regular:$193.75
AICPA Member:$155.00
Your Price:$193.75
To receive your AICPA member discount, Sign In now, or Register using your AICPA membership number.