Course Description
Presenter: David Ringstrom, CPA
Ensure the accuracy and integrity of your Excel workbooks with practical auditing techniques designed for spreadsheets of all sizes and complexity levels. In this course, Excel expert and author David Ringstrom, CPA, demonstrates a variety of tools and methods that help you identify errors, validate formulas, and confidently review workbook calculations.
You'll learn how to use features such as Watch Window, Trace Precedents, Trace Dependents, Find Formulas, Evaluate Formula, and FORMULATEXT to better understand how data flows through a workbook. The course also explores techniques for identifying circular references, locating workbook links, managing error-checking settings, and using the Navigation task pane available in Microsoft 365.
Through real-world examples and step-by-step demonstrations, you'll gain practical skills for auditing spreadsheets more efficiently and ensuring the reliability of your work.
Learning objectives:
- Identify tools and features used to verify the integrity of Excel workbooks
- Determine whether a workbook contains external links and other auditing concerns
- Use Trace Dependents and related auditing tools to analyze spreadsheet relationships
- Interpret the results of the FORMULATEXT function and other formula auditing techniques
David H. Ringstrom, CPA, is an author, consultant, and nationally recognized Excel instructor with more than 30 years of experience helping professionals improve their spreadsheet skills. He has presented thousands of training programs and is the author or co-author of several books, including Microsoft Excel 365 For Dummies and Exploring Microsoft Excel’s Hidden Treasures.
David's training focuses on practical techniques that help users work more efficiently and accurately in Excel. His philosophy is simple: "Either you work Excel, or it works you." Through clear instruction and real-world examples, he empowers professionals to get more value from one of the world’s most widely used business tools.
Review our course policies and procedures page for further information