OverviewExcel expert David Ringstrom, CPA often likens Excel spreadsheets to the old West, where anything goes. Users are generally free to enter anything they like in any worksheet cell, often at the expense of data integrity. In this webinar David will show you how to use features and techniques in Excel to future-proof spreadsheets and ensure that users work within the required constraints. Why Should You AttendSpreadsheet templates are often like the Wild West where anything goes. Users are free to type anything they wish into any worksheet cell, and in many cases overwrite formulas or input invalid data. In this webinar you’ll see how to manage this risk by implementing internal control procedures that enforce proper spreadsheet usage. Areas Covered In This WebinarUnderstand VLOOKUP function in Excel, including argument structure and shortcuts. Look-up formulas save users from having to copy and paste data from one area of as spreadsheet to another. Instead, Excel does the work by finding requested data, such as a product ID in the first column of a supporting list and then returning related data, such as product description or priceIdentify situations where VLOOKUP will return #N/A errors. If the user has not yet entered the necessary criteria or types in an entry that doesn’t appear on the list then VLOOKUP will return an errorUse Excel’s IFERROR function to make a cell appear blank instead of returning a #N/A or other error, along with an alternative that provides compatibility with Excel 2003 and earlierExplore Excel’s Table feature and see how this simple feature makes formulas easier to audit and maintain. The Table feature adds automation to areas of spreadsheets so that named lists expand automating. Learn spreadsheet design techniques such as separating supporting lists onto separate worksheets. This prevents users from overwriting standardized data, and also ensures that making changes to worksheets don’t inadvertently cause problems with the supporting listsUse Excel Data Validation list to restrict data entry to a list of permissible choices. The Data Validation feature can limit users to a set of choices from a list or a range of numbers, such as a quantity between 1 and 100. See how the Locked Cells feature can protect formulas and allow users to only affect certain cells in the spreadsheet.  Learning ObjectivesUse look-up formulas to look up data automatically from listsUse Excel's Table feature to future-proof elements of your spreadsheetUse Excel's Data Validation feature to restrict data entry to a list of permissible choices Who Will BenefitThe following job titles/ positions will benefit from attending this seminar:HR/ ControllersPayroll ProfessionalsAccounting and Finance PersonnelCFOsAuditorsManagersAdminAnyone that builds spreadsheets for use by othersLevelIntermediate