Excel Data

Excel Data 1: Sorting and Filtering

Excel Data 2: Advanced Filter and Basic PivotTables

Excel Data 3: PivotTables

Excel Data 4: Text Files, Text to Columns, and Flash Fill

Excel Data 5: Substitution List vLookups/PivotTables

Excel Data 6: Pivot Charts, Slicers, and Dashboards

  • Handout
  • Class Files (ZIP)
  • Recorded Zoom Session
  • Dashboard1 0:48 – PivotTable; PivotChart; Linked Drawings
  • Dashboard2 24:21 – Pivot Tables, Pivot Charts, Slicers
  • Dashboard3 44:15 – Formatted Table, Sparklines; Conditional Formatting, Charts