Content Provider
Excel u logo
Store exceluniv20
Handout Materials
Presentation Slides
Additional Materials
Supplementary Files
Webinar Technical FAQs
Excel3simple banner 050421


Cost Free
Presentation Length 1.5 hours

Recorded DateApril 10, 2024
CPE:Not available
(archived webinars do not offer CPE credits)
Course LevelBasic
Course Description

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.


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

Not logged

Jeff Lenning, CPA, CITP

Excel University
Author of Excel University
(949) 200-7688

Excel u logo

Award-winning instructor Jeff Lenning has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient.

User-added image

About Our Presenter

Excel u logo
If you could learn Excel simply and easily at your pace and could learn the features and functions that are relevant and practical to accounting professionals – would you want to? If you are an accounting professional and have taken Excel classes before, you know the pace can be too fast or too slow, and the content may not be relevant to your work. Excel University explores relevant features that allow you to get your work done quicker, in a self-paced, fun, and engaging way. Become more efficient, streamline processes, and save time with Jeff Lenning’s Excel University. Designed by a CPA for CPAs and accounting professionals, this series covers functions you need, and skips those you don’t. The content has been written from scratch integrating everything Jeff knows about Excel training learned over the past decade of providing continuing professional education.