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

• Handout
• Class Files (ZIP)
• Recorded Zoom Session (02/09/2021)

Excel Data 2: Advanced Filter and Basic PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session (02/16/2021)

Excel Data 3: PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session (2/23/2021)

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

• Handout
• Class Files (ZIP)
• Recorded Zoom Session (03/31/2021)

Excel Data 5: Substitution List vLookups/PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session (3/09/2021)

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