Microsoft Excel Auditing Features and Techniques
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
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@onlinecompliancepanel.com
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@onlinecompliancepanel.com
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@onlinecompliancepanel.com
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@onlinecompliancepanel.com
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 Q&A sessions via chat Get certification of attendance.
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
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@onlinecompliancepanel.com
Get Connected With Us:
www.onlinecompliancepanel.com
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com