In this presentation author and Excel expert David H. Ringstrom, CPA, will guide you through essential techniques for creating error-proof spreadsheets. Topics include placing headers in a single row, comparing relative and absolute references, assigning names to key input cells, creating smarter SUM formulas, preventing double-counting with SUBTOTAL, handling errors with IFERROR, unlocking and conditionally formatting input cells, removing conditional formatting, and protecting a worksheet. This comprehensive webinar is designed to enhance your Excel skills and ensure your spreadsheets are both accurate and efficient.

In his webinars, David demonstrates every technique twice: first on a PowerPoint slide with numbered steps, and then live in Excel for Microsoft 365 for Windows. He highlights any differences in Excel 2024, 2021, or 2019 during the presentation and in his detailed handouts. Attendees also receive an Excel workbook containing most of the examples he uses, making it easy to follow along and apply the techniques later. David additionally supports Excel for Mac users by answering their follow-up questions via email.

Topics typically covered:

• Hiding and unhiding multiple rows and columns on worksheets with Custom Views
• Assigning names to cells to streamline formulas and bookmark key inputs within a workbook
• Improving SUM integrity with a simple design technique
• Using Conditional Formatting to identify unlocked cells for data entry
• Building resilience into spreadsheets by avoiding daisy-chained formulas
• Summing sections quickly with the SUBTOTAL function
• Mastering the IFERROR function to display alternate values in lieu of a # sign error
• Course Admin
• Improving spreadsheet integrity by limiting column headers to a single row
• Understanding how the VLOOKUP function allows you to look up data
• Toggling cell lock status with a custom shortcut
• Most features and functions work in Excel for Mac as well but expect differences

Learning objectives:

• Identify how to improve the integrity of SUM-based formulas in Excel
• State which XLOOKUP argument causes an alternate value to be displayed in lieu of #N/A
• State what SUMIF returns if a match cannot be found

Who should attend:

Professionals seeking to use Microsoft Excel more effectively.