Microsoft Excel Auditing Features and Techniques

FREMONT, Calif. - Jan. 2, 2015 - PRLog -- 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.

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.

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.

Who can Benefit:

Accountants
Finance specialists
CFOs
Controllers

Contact:
Toll free: ‎+1-510-857-5896‎
Email: webinar@onlinecompliancepanel.com
OnlineCompliancePanel LLC,
38868 Salmon Ter,
Fremont, CA 94536, USA
Use For Registration:http://www.onlinecompliancepanel.com/ecommerce/webinar/~p...