Excel Spreadsheet Auditing Techniques 2019

  • 15 Apr 2019
  • Webinar

Description

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

Past Events

Important

Please, check "Excel Spreadsheet Auditing Techniques" official website for possible changes, before making any traveling arrangements

Event Categories

Business: Finance
Technology: Software & Applications

Other Events with Similar Categories

Other Events with Similar Location or Organizer

Featured Conferences & Exhibitions