Product Image

Excel for Accounting and Finance Professionals: Level 2

Author/Moderator: Jeff Lenning, CPA, CITP
Publisher: AICPA
Availability: In Stock
See Below To Add To Cart
View Online Catalog
Print This Page


Available Formats:  Text | See All

This course focuses on preparing reporting workbooks. Building on the foundations covered in Excel for Accounting Professionals: Level 1, this next installment explores many worksheet functions useful in building formula-based reports. The techniques and functions covered enable workbooks that allow you to paste-and-go. That is, you paste in the updated data, and the report values update automatically.

Topics Discussed:

  • Conditional summing
  • Lookups
  • Error trapping
  • Error checking
  • Multicolumn list comparisons
  • Text functions
  • Date functions
  • Dynamic headers
  • Mapping tables
  • Horizontal reports

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

  • Explore relevant Excel functions.
  • Discover methods for setting up reporting workbooks.
  • Demonstrate ideas that promote efficiency

Who Will Benefit?

  • Accounting and finance professionals in public practice or industry

Prerequisite: None.

Advanced Preparation: None.

Table of Contents


Videocourse Details

NASBA Field of Study: Specialized Knowledge and Applications
Level: Intermediate
Recommended CPE Credit: 16.5
Excel for Accounting and Finance Professionals: Level 2
Text , 2014
Product# 746090
Availability: In Stock
AICPA Member:$175.00
Your Price:$218.75
To receive your AICPA member discount, Sign In now, or Register using your AICPA membership number.