Maximize Excel: Spreadsheet Forensics

Date: 10/16/2024
Time: 3:00 PM - 5:00 PM EST
CPE Credit: 2 hours

In this session Excel expert David Ringstrom, CPA shows you techniques that you can use to verify the integrity of even the most complicated Excel workbook. This webcast demonstrates Excel’s formula auditing and error checking tools, as well as techniques you can use to verify that a spreadsheet is providing the desired results.

Topics Covered

• Using Excel’s formula auditing tools
• Using the Go To special command to identify cells with formulas or hard-coded values
• Excel’s Comments feature
• Excel’s Error Checking feature
• Using Excel’s Watch Window to monitor the values of key cells in a spreadsheet

Learning Objectives:

• Understand how Excel’s Evaluate Formulas tool makes it easier to comprehend complex formulas
• Understand keyboard shortcuts that help with auditing
• Master unfamiliar worksheet functions through online help and formula tips
• Be able to make auditing easier by retrofitting range names into an existing spreadsheet