Excel Data

If you have issues downloading the ZIP files, you can download the files here: https://training.health.ufl.edu/zoom/zoom-files.  If you have any questions, please feel free to contact us – training@health.ufl.edu.

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 (11/18/2020)
  • Dashboard1 1:35 – PivotTable; PivotChart; Linked Drawings
  • Dashboard2 15:26 – Pivot Tables, Pivot Charts, Slicers
  • Dashboard3 32:05 – Formatted Table, Sparklines; Conditional Formatting, Charts