High Impact Excel: Using Tables

• Use Excel's Table feature to simplify data analysis
  
• Explore common data integrity risks that the Table feature eliminates
  
• See how the Table feature allows you to transform filtering tasks
  
• Avoid writing repetitive formulas with Excel's Data Table feature
  
• Manage lists of data with the Table feature
  
• Use tables to filter multiple lists on a single worksheet
  
• Dig deeper into the numbers by using the Report Filter command to create break-out tables
  
• Understand how to use the Slicers feature in Excel 2013 to streamline analyzing data within tables
  
• Determine whether formulas within tables use cell references or field names
  
• Use the Table feature in Excel 2007 and later to create charts that expand or contract automatically as your source data changes
  
• See how the Table feature can vastly improve the integrity of Pivot Tables in Excel
  
• Learn the basics of pivot table creation
  
• See how pivot tables differ from worksheet formulas and the importance of the Refresh command
  
• Improve the integrity of spreadsheets with Excel's VLOOKUP function
  
• Future-proof VLOOKUP by using Excel's Table feature instead of referencing static ranges
  
• Minimize ongoing spreadsheet maintenance with Excel's Table feature
  
• Learn which features you can't use when one or more tables exist in a workbook, such as Custom Views
  
• Use Excel's Custom Views feature to hide and unhide multiple worksheets with ease

The live versions are interactive, meaning that participants can ask questions in real time, plus are a very cost-effective form of training because 1) you receive fast, convenient learning without any out-of-office time; 2) you can invite as many colleagues as you'd like to listen in on a single phone line; 3) you incur no travel expenses; and 4) you and your colleagues are back at work immediately after the session ends!

And though with recorded versions you do lose the ability to ask questions, you gain the ability to hear the presentation numerous times and to share it with others in your office.

Handout materials and the phone number for live presentations are made available to you prior to the event via email from the presenter and from the "MyAccount" link on the menu bar. Copies of the presentations are included with recorded versions.