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

Are you an accounting or finance professional with a good grasp of Excel who wants to take your skills to the next level? This CPA designed course is for you. Learn about the Excel features that will help you achieve greater efficiency and automation. Each exercise presented in the book is available as an interactive Excel Workbook file so you can follow along in Excel as you read.

Learning Objectives:
This course will prepare you to:

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

Key Topics:

  1. Advanced pivot tables
  2. External data ranges (ODBC)
  3. Visual basic: macros and user defined functions
  4. Digital working papers
  5. Securing worksheets and workbooks
  6. Named ranges
  7. Vlookup() and related functions that Nest Offset(), Text(), Match()
  8. IF function and other efficiency gains
  9. Encryption and data validation

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

Prerequisite: Working knowledge of Excel

Advance Preparation: None

NASBA Field of Study: Specialized Knowledge and Applications
Level: Advanced
Recommended CPE Credit: Text - 8.5; On-Demand - 7
Advanced Excel: Practical Applications for Accounting Professionals
Text , 2016
Product# 745757
Availability: In Stock
AICPA Member:$239.00
Your Price:$299.00
Advanced Excel: Practical Applications for Accounting Professionals
CPE On-Demand , 2016
Product# 163142
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.