My Shopping Cart
There are no items in your shopping cart.

A Detective's Guide to Auditing Excel Spreadsheets (IME350E)

Presented by: David Ringstrom, CPA
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Audio Conference
90 minutes
Event Description
See the sneak peek before you buy!

Learn How To Optimize the Use of Excel's Formula Auditing and Error Checking Tools For Reducing Spreadsheet Risks and Errors.

Spreadsheets in Excel are part of every organization's arsenal and are utilized by practically every employee who analyzes data or develops financial models. Excel is a fluid, intuitive, flexible and cost effective way to analyze the information in businesses on a day-to-day basis.

Spreadsheets often have errors in formulae or in data entry costing the organization in terms of loss of productivity as well as increased audit costs. Spreadsheet errors can also cost your organization business revenues and potentially lead to non-compliance with regulations. Avoid these spreadsheet risks and the consequent loss to your organization by learning the techniques needed to conduct a thorough Excel audit.

In this session Excel expert David Ringstrom, CPA shares forensic techniques for verifying any Excel workbook. This audio conference focuses on Excel's formula auditing and error checking tools, as well as techniques you can use to verify which cells contain formulas versus values. You'll even discover techniques for accessing password protected workbooks.

David will teach from primarily from Excel 2010, but will demonstrate Excel 2013's new features where different from Excel 2010, as well as disclose the differences from Excel 2007. Excel 2003 will only be covered if questions are raised by the audience.

Training Objective

  • Verify sums and totals quickly and simply by using your mouse
  • Use the Watch window to easily monitor the consequences of even minor changes to your workbooks
  • Learn Excel features and keyboard shortcuts to trace dependents and precedents
  • Learn to display all formulas instantly within a worksheet using two different ways.
  • Bring Excel's green error-checking prompts under control by managing the underlying rules
  • Step through formulas in slow-motion with the Evaluate Formulas feature
  • Learn to use the N function to annotate formulas within the Formula bar, when a cell comment won't do
  • Learn how to find out if a workbook contains links, identify how links can hide within Excel features, and find out the risks of linked workbooks
  • Go beyond simply adding cell comments: hide, display, and locate all commented cells with ease
  • Print a list of all cell comments on a worksheet, or print visible comments
  • Learn how to minimize errors and save time in Excel through range names. Also find out how they serve as navigation aids, and how they can store information in a hidden location
  • Simplify formula auditing with the Apply Names feature
  • Audit all named cells in a workbook with ease with the INDIRECT function in all versions of Excel, and the new FORMULATEXT function in Excel 2013.
  • Use Excel's Watch Window feature as a mechanism for auditing and monitoring key cells in workbooks
  • Use Excel's Trace Precedents and Dependents features, as well as alternatives that offer similar functionality
  • Use FORMULATEXT function in Excel 2013 to display the formula from any cell in a workbook

Who should attend

Practitioners who review spreadsheets created by others, or who wish to improve the integrity of their own spreadsheets

  • MIS Professionals
  • Accountants
  • Investment Bankers
  • Other Professionals in Financial industry
  • Management Consultants
  • Strategic Consultants
  • Business Intelligence Analysts
  • Marketers
  • HR professionals
  • Payroll Executives
  • Others
About Our Speaker(s)

David Ringstrom | Microsoft Excel Courses  SpeakerDavid Ringstrom CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but shou... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: A Detective's Guide to Auditing Excel Spreadsheets
    Presenter(s): David Ringstrom, CPA

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team