Product Image

Excel for Accounting Professionals Webcast Series

Type: Audio Webcast
Date: March 16, 2016
Time: 12:30 PM - 05:00 PM ET
Recommended CPE Credit: 16
See Below To Add To Cart
Web Event Calendar
Print This Page

The Excel for Accounting Professionals webcast series is designed to walk through the Excel features, functions and techniques that will save you time. Since the series is designed progressively, working through them in order ensures that you have all prerequisite knowledge to understand and implement the topics discussed.

This is a comprehensive Excel series, not just a quick "tips and tricks" webinar, and we are able to tackle real-world issues and build some fairly robust workbooks. The key to building powerful workbooks is understanding how to use many Excel items at the same time so that they work together to drive productivity. This series teaches many Excel topics individually, and then applies them collectively; for example, in the final webinar we use 10+ independent Excel items to build an automated reporting workbook.

The series introduces more than 30 Excel features, functions and techniques, including INDEX, SUMIFS, Mapping Tables, ErrorCk, Dynamic Headers, MATCH, VLOOKUP, Data Validation, Tables, Named References, Conditional Formatting, Skinny Row, Start Here, Input Cells, Selection Groups, Nested Functions, Workbook Design Principles, Boolean Values, AND, Comparison Formulas, VALUE, TEXT, IFERROR, List Comparisons, Multicolumn List Comparisons, Indenting, EOMONTH, DATE, CONCATENATE, and Horizontal Reports.

Save more than $240 with the purchase of this webcast series; each individual session in this 8-part series is also available to purchase separately.
Session #1: Excel for Accounting Professionals: Tables and Named References
Wednesday, March 16, 2016, 12:30 PM - 2:30 PM (ET)

Session #2: Excel for Accounting Professionals: Data Validation and Conditional Formatting
Wednesday, March 16, 2016, 3:00 PM - 5:00 PM (ET)

Session #3: Excel for Accounting Professionals: Workbook Design Principles and Organization
Friday, March 18, 2016, 12:30 PM - 2:30 PM (ET)

Session #4: Excel for Accounting Professionals: Conditional Summing and Lookups
Friday, March 18, 2016, 3:00 PM - 5:00 PM (ET)

Session #5: Excel for Accounting Professionals: Error Trapping and Improving Lookups
Wednesday, March 23, 2016, 12:30 PM - 2:30 PM (ET)

Session #6: Excel for Accounting Professionals: List Comparisons and Indenting
Wednesday, March 23, 2016, 3:00 PM - 5:00 PM (ET)

Session #7: Excel for Accounting Professionals: Date Driven Workbooks and Concatenation
Friday, March 25, 2016, 12:30 PM - 2:30 PM (ET)

Session #8: Excel for Accounting Professionals: Dynamic Headers, Mapping Tables and Error Check
Friday, March 25, 2016, 3:00 PM - 5:00 PM (ET)

The sessions are designed for you to work along. These hands-on workshops are an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. The link will be provided so you can download the Excel files. During the sessions, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the format is that the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor stops talking and provides time for you to complete many of the same exercises. Then, the instructor demonstrates the solutions for all of the exercise in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.

If you are sincere about wanting to improve your Excel skills, and to figure out how to use Excel to save time, this comprehensive Excel series is sure to help.

Learning Objectives:
Learn how to effectively use key Excel functions and features that are critical for accounting professionals.

Field of Study: Specialized Knowledge & Applications
Level: Intermediate
Prerequisites:Working knowledge of Microsoft Excel

Important Information on Your CPE Credit

IMTA and CITP Members save an additional $100:
When you log into this website with your AICPA member account, the section discount will be automatically applied during checkout. Section discounts cannot be combined with any other offer. Should you have any questions or encounter any issues, please contact the AICPA Service Center at 888-777-7077 or
Excel for Accounting Professionals Webcast Series
Bundle CPE
March 2016
Audio Webcast
Product# VCL2EXAP1603
Availability: Online Access
Live Webcast
AICPA Member:$599.00
Your Price:$749.00
To receive your AICPA member discount, Sign In now, or Register using your AICPA membership number.