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
