Microsoft Excel Auditing Features and Techniques

1

• Microsoft Excel Auditing Features and Techniques

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
2

• Instructor Profile
• David H. Ringstrom is a CPA
  and owner of Accounting Advisors, Inc., an
  Atlanta-based spreadsheet consulting firm that he
  started in 1991. David speaks at conferences and
  presents dozens of webinars annually on Excel and
  other topics. He has written numerous articles on
  spreadsheets, some of which have been published
  internationally. He has served as the technical
  editor for other 30 books on accounting software,
  and is the Tech Editor-at-Large for Accounting
  WEB and Going Concern. David offers Excel
  training and consulting services nationwide.

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
3

• Description
• In this session Excel expert David
  Ringstrom, CPA shows you how to verify 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 which cells contain formulas versus
  values. You'll be able to discover hidden
  worksheets, objects, and data.
• In this session David teaches from Excel 2010.
  The techniques shown work in the same fashion in
  Excel 2007 and 2013, and his handouts include
  alternate instructions for Excel 2003 where
  applicable. 

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
4

• Objectives of the Presentation
• Learn the nuances of tracing dependents and
  precedents by way of both Excel features and
  keyboard shortcuts.
• Learn two ways to instantly display all formulas
  within a worksheet.
• Use the Watch window to easily monitor the
  ramifications of even minor changes to your
  workbooks.
• Step through formulas in slow-motion with the
  Evaluate Formulas feature.
• When a cell comment won't do, use the N function
  to annotate formulas within the Formula bar.
• 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 range names minimize errors, save time
  in Excel, serve as navigation aids, and can store
  information in a hidden location.
• Simplify formula auditing by way of the Apply
  Names feature.
• Audit all named cells in a workbook with ease by
  way of the INDIRECT function in all versions of
  Excel, and the new FORMULATEXT function in Excel
  2013.

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
5

• Why Should you Attend?
• Learn techniques that allow you to
  audit Microsoft Excel workbooks. This webinar
  covers areas such as Excel's Trace Dependents
  and Trace Precedents features, cell comments,
  range names, INDIRECT and FORMULATEXT functions,
  Evaluate Formulas feature, Watch Window
  feature. 
• Who can Benefit?
• Accountants
• Finance specialists
• CFOs
• Controllers

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
6

• Live Session - How it works?
• Username and Password will be sent to you 24
  hours prior to the webinar
• Presentation handouts in pdf format will be
  mailed to you
• Login to the session using the username and
  password provided to you
• Get answer to your queries through interactive
  QA sessions via chat
• Get certification of attendance.

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
7

• Recorded Session - How it works?
• A link will be provided to you upon purchase of
  the recorded session
• Please click on the link to access the session
• Presentation handouts in pdf format will be
  mailed to you
• Get certification of attendance.

www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com
8

• Get Connected With Us

www.onlinecompliancepanel.com
www.onlinecompliancepanel.com 510-857-5896
customersupport_at_onlinecompliancepanel.com