Practical Excel – Executing Spreadsheet Internal Controls 2019

Topics

• 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

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
• Every Practitioner who wish to learn how to create error-free Excel spreadsheets