×

Web Events

Excel for Accounting Professionals Webcast Series

Speakers: Jeff Lenning
DeliveryType:  Online Subscription
  • $599.00-$749.00
    Excel for Accounting Professionals Webcast Series 12:30 pm - 05:00 pm ET Product #: VCL2EXAP1612
    Add to Calendar 12/05/2016 12:30:00 12/05/2016 17:00:00 America/New_York AICPA Webcast: Excel for Accounting Professionals Webcast Series
    Monday, December 5 - The Excel for Accounting Professionals webcast series is designed to walk through the Excel features, functions and techniques that will save you time.
    Register at http://www.aicpastore.com/CareerPersonalDevelopment/excel-for-accounting-professionals-webcast-series/PRDOVR~PC-CL2EXAPSERIES/PC-CL2EXAPSERIES.jsp AICPA noreply@aicpastore.com false MM/DD/YYYY AICPA WebEvent aiEQlNoFjzFNtMgVwmLn20911
    AICPA Member: $599.00
    Non-Member: $749.00

Your registration includes access to the entire Excel series webcasts. If you are unable to attend one or more broadcasts in the series, you will be able to attend a later session and still earn the CPE credit.

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.

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.

Webcasts included in this series:

Session 1: Tables and Named References

Session 2: Data Validation and Conditional Formatting

Session 3: Workbook Design Principles and Organization

Session 4: Conditional Summing and Lookups

Session 5: Error Trapping and Improving Lookups

Session 6: List Comparisons and Indenting

Session 7: Date Driven Workbooks and Concatenation

Session 8: Dynamic Headers, Mapping Tables and Error Check

Important Information on Your CPE Credit

Discounts

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 service@aicpa.org

Speaker Bio

Jeff Lenning
CPA CITP

Author of Excel University
In his live CPE training sessions, Jeff Lenning CPA CITP has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient. Several publications have featured his Excel articles, including the Journal of Accountancy and California CPA Magazine.

Highlights
After graduating from the University of Southern California, Jeff began his career in the audit practice at Arthur Andersen's Orange County office. He was a senior financial analyst at Gateway computers and the accounting manager at Interpore Cross International. In 2000, he founded Click Consulting Inc., a technology-consulting firm that specializes in Excel training, consulting, development, and personal coaching.

Professional Involvement
He is a past president of the CalCPA OCLB Chapter, the former chair of the California CPA State Technology Committee, co-chair of the California CPA OCLB Chapter Technology Committee, a board member of the California CPA OCLB Chapter, on the California Society of CPAs Council, and an instructor for the AICPA and the California CPA Education Foundation. A Microsoft Office Certified Excel Expert, he is a nationally recognized speaker and trainer. He was recently recognized with the California CPA Education Foundation's Award for Instructor Excellence.



System Requirements

For best results, webcast attendees should meet the following requirements:

  • Windows 7 with IE 8+, Firefox 40.x, or Chrome 44.x
  • Windows 8 with IE 10+, Firefox 40.x, or Chrome 44.x
  • Windows 8.1 with IE 11+, Firefox 40.x, or Chrome 44.x
  • Mac OS 10.9.x with Safari 7.x, Firefox 40.x, or Chrome 44.x
  • Mac OS 10.10.x with Safari 8.x, Firefox 40.x, or Chrome 44.x
  • Linux Ubuntu 10.x with Firefox 40.x or 44.x
  • Browser configuration must accept cookies and have javascript enabled.
  • Adobe Flash 14+ (Click on link to install/upgrade): http://get.adobe.com/flashplayer/
  • Computer with Speakers / Headset, resolution 1024x768 minimum, 1 GHz+ CPU, 512+ Mb RAM
  • High speed internet connection

Mobile Support:

  • Apple iPad / iPhone running HTML5
  • Android Device running Flash (Note: Android Jelly Bean currently does not support Flash).
  • Not all features that are available to PC/Mac attendees are available to mobile device attendees.