Practical Excel Executing Spreadsheet Internal Controls 2019 is a webinar that covers topics such as:
- Ensuring proper VLOOKUP integrity by using Data Validation to create an in-cell drop-down list
- Creating self-expanding drop-down lists with Excel’s Data Validation feature
- Improving the integrity of spreadsheets with Excel’s VLOOKUP function
- Future-proofing VLOOKUP by using Excel’s Table feature versus referencing static ranges
- Overcoming VLOOKUP’s quirks by using SUMIF to look up numeric values
- Limiting users to entering whole numbers in a worksheet cell by way of Data Validation
- Protecting hidden sheets from within a workbook
- Preserving key formulas using hide and protect features
- Removing the Table feature from Excel spreadsheets once it’s no longer needed, or simply erasing the alternate row shading
- Protecting sensitive information by hiding formulas within an Excel workbook
- Tweaking the Data Validation settings for a given range of cells
- Toggling the Locked status of a worksheet cell on or off by way of a custom shortcut
Practical Excel Executing Spreadsheet Internal Controls 2019 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
- Every Practitioner who wish to learn how to create error-free Excel spreadsheets