Guide to Auditing Excel Spreadsheets 2018

Topics

• 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

Who should Attend

• 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