course description
in this illuminating session, excel expert david ringstrom, cpa, shares techniques you can use to verify the integrity of even the most complicated excel workbooks. david demonstrates excel’s formula auditing and error-checking tools, as well as how to verify which cells contain formulas versus values. in addition, david explains how to: find buried worksheets; access password-protected workbooks; use the conditional formatting feature to identify duplicates in a list; monitor even minor changes to your workbooks; hide, display, and locate cells that contain comments; and much more.
david demonstrates every technique at least twice: first, on a powerpoint slide with numbered steps, and second, in the subscription-based microsoft 365 (formerly office 365) version of excel. david draws your attention to any differences in the older versions of excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. david also provides an excel workbook that includes most of the examples he uses during the course.
microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. conversely, the perpetual licensed versions of excel have feature sets that don't change. perpetual licensed versions have year numbers, such as excel 2021, excel 2019, and so on.
who should attend:
practitioners who review and audit excel spreadsheets created by others, or those who wish to improve the integrity of their own spreadsheets.
level: intermediate
topics covered:
- auditing portions of a formula by using the f9 key to temporarily convert part of a formula to a value
- bringing excel’s green error-checking prompts under control by managing the underlying rules
- determining whether it’s safe to edit or delete a cell by way of the trace dependents feature
- displaying all formulas in a worksheet at once with the show formulas feature
- identifying duplicates in a list using conditional formatting
- identifying other cells a formula relies on by way of the trace precedents feature
- printing a list of all cell comments on a worksheet or printing visible comments
- removing conditional formatting when it’s no longer needed within a spreadsheet
- selecting all formulas within a worksheet with just two mouse clicks
- stepping through formulas in slow motion with the evaluate formulas feature
- using the workbook statistics feature to determine the number of worksheets, formulas, cells with data, and more in each workbook
learning objectives:
- recognize if a file has links to other workbooks or not and remove unwanted links
- identify how to add, review, and print worksheet comments with ease
- apply excel tools and techniques that allow you to evaluate portions of a formula or entire formulas
review our course policies and procedures page for further information