Exploring Excel: Establishing Spreadsheet Internal Controls 2018

Exploring Excel: Establishing Spreadsheet Internal Controls 2018 is an event dedicated to excel features - Data Validation, Conditional Formatting, hide and protect features which can be used to protect our works.

Topics

• Overcoming VLOOKUP’s quirks by using SUMIF to look up numeric values.
• Ensuring proper VLOOKUP integrity by using Data Validation to create an in-cell drop-down list.
• Using Conditional Formatting to identify unlocked cells into which data can be entered.
• Creating an in-cell list by way of Excel’s Data Validation feature.
• Improving the integrity of spreadsheets with Excel’s VLOOKUP function.
• Using a custom number format to hide zero amounts within a specific area of a spreadsheet.
• Creating resilient SUM functions that won’t break when users insert additional rows.
• Protecting sensitive information by marking key worksheets as VeryHidden.
• Utilizing Data Validation to limit percentages entered in a cell to a specific range of values.
• Toggling the Locked status of a worksheet cell on or off by way of a custom shortcut.
• Using Excel`s IFERROR function to mask # sign errors like #N/A.

Who should Attend

• Accountants
• CFOs
• CPAs
• Excel User
• Controllers
• Enrolled Agents
• Income Tax Preparers
• IT Professionals
• Financial Consultants
• Human Resource Personnel
• Auditors
• Marketers
• Bookkeepers
• Government Personnel