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-800-223-8720
Pre Recorded Audio Conference
90 minutes
  •  Wed, March 11, 2015
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, Excel ExpertDavid Ringstrom CPA
David is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career David has spoken at conferences on Excel, and written dozens of freelance articles about spreadsheets. David\'s webinars receive rave reviews, and attendees particularly lik... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: A Detective's Guide to Auditing Excel Spreadsheets
    Presenter(s): David Ringstrom , CPA Protection Status