Guide to Auditing Excel Spreadsheets 2018 is a webinar that covers topics such as:
- Enhancing Excel by creating the ability to display a formula within any worksheet cell in a cell comment
- Printing a list of all cell comments on a worksheet or printing visible comments
- Verifying sums and totals quickly by simply selecting cells with your mouse
- Learning the nuances of circular references in Microsoft Excel
- Understanding the difference between manual and automatic calculation modes in Excel
- Auditing all named cells in a workbook with ease by way of the INDIRECT function in all versions of Excel and the FORMULATEXT function in Excel 2013 and later
- Multiplying hours by hourly rates to summarize payroll information with a single formula with Excel’s SUMPRODUCT function
- Protecting sensitive information by marking key worksheets as VeryHidden
- Bring Excel’s green error-checking prompts under control by managing the underlying rules
- Understanding the nuances of Excel’s Allow Editing Directly in Cells setting
- Removing Conditional Formatting when it’s no longer needed within a spreadsheet
- Going beyond simply adding cell comments: easily hide, display, and locate all cells that contain comments
Guide to Auditing Excel Spreadsheets 2018 is intended for:
- CPA’s
- Accountants
- Controllers
- CFO’s
- Income Tax Preparers
- Excel Users
- Financial Consultants
- Enrolled Agents
- Auditors
- IT Professionals
- Bookkeepers
- Human Resource Personnel
- Government Personnel
- Marketers