Tables and PivotTables for Beginners

Many users assume that Microsoft Excel information is already in a Table. It has lines and rows and columns – oh my! Truthfully, the core power of Excel only comes out when you convert that information into Tables and PivotTables. It’s so easy to filter and sort your information that you’ll never look at an Excel data range the same way again.

  1. Best Practices for Data Storage
  2. Text to Columns
  3. Data Validation by Text Length
  4. Dropdown Lists
  5. Data Ranges vs. Tables
  6. Summarize a Table with a PivotTable
  7. Adding and Removing Data in a PivotTable
  8. PivotTable Values
  9. Recommended PivotTables
  10. Refreshing a PivotTable