Topics covered include: Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets; Using Excel's OFFSET function to dynamically reference data from one or more accounting periods; Creating an in-cell list by way of Excel's Data Validation feature, and then automating the addition of new items with a table; Discovering two different ways to locate tables anywhere within a workbook; Removing the Table feature from a worksheet if it's no longer needed; Managing cumbersome lists of data using the Table feature; Minimizing a data integrity risk within pivot tables by way of Excel's Table feature; Improving the integrity of spreadsheets with Excel's VLOOKUP function; Avoiding the need to write repetitive formulas using Excel's Data Table feature; Applying different filter settings with just a couple of mouse clicks using the Custom Views feature; Using the SUMIF function to summarize data based on a single criterion; Customizing table styles in Excel. Upon completing this course, you should be able to: Specify the key that you can hold down to efficiently group two or more consecutive worksheets; State the Excel feature that the Table feature disables within a given workbook; Identify the menu on the Data tab of Excel's ribbon that contains the Data Table feature.