Intermediate

Data Design and PivotTables

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.

  • Best Practices for Data Storage
  • Text to Columns
  • Data Validation by Text Length
  • Dropdown Lists
  • Data Ranges vs. Tables
  • Summarize a Table with a PivotTable
  • PivotTable Values
  • Recommended PivotTables