Let me ask you a question. What is your #1 most used Excel function of all time? Is it the sum function? Well, it shouldn’t be if your goal is to reduce errors in your recurring-use workbooks. We’ll explore a powerful alternative to the SUM function that allows us to perform better summing.

Let me ask you another question. When you insert new data rows, are they automatically included in your formulas? If not, you probably have errors in your workbook because the formulas don’t include everything they should.

Anticipating how your workbooks may change over time and addressing the related risks upfront can help reduce your workbook errors. In this webinar, we’ll explore three simple ways to improve the reliability of your recurring-use workbooks.

COMPLIMENTARY BLOG SUBSCRIPTION

Participants of this webinar will automatically receive a complimentary subscription to the Excel University blog! After the webinar, you'll receive a welcome email with links to the resources included in the presentation. You'll be notified via email whenever I write a new Excel article or blog post, typically 2-3 per month. You can unsubscribe anytime, but I hope you'll stick around to learn more about how to use Excel.

Learning Objectives:

• Recognize ways to reduce errors in workbooks


• Identify how to automate workbook formulas


• Determine ways to update workbooks and workbook formulas


• Identify three ways to improve the reliability of your recurring-use workbooks

NASBA Approved

CPAacademy.org (Sponsor Id#: 111889) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

CPAacademy.org 1685 S. Colorado Blvd, Suite #205, Denver, CO 80222