With the addition of the Table tool in Excel, we now have a dynamic control to place on standard lists of data. We can combine it with functions, data validation, formatting, and other tools to simplify our lives significantly. In this session, we’ll demonstrate six major ways that using Tables improves your daily efforts.

Topics include:

• Integrating functions with tables
• Leveraging dynamic named ranges
• Validating data entry
• Adding consistent formatting