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
• Filters Exercises start at 28:15

Excel Data 2: Advanced Filter and Basic PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Advanced Filters – 3:40; SubTotals 19:37; PivotTable 37:40

Excel Data 3: PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Sales 1:20; Survey 33:06; Customers 39:40; Kangaroo Rats 44:23

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

• Handout
• Class Files (ZIP)
• Recorded Zoom Session

Excel Data 5: Substitution List vLookups/PivotTables

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Accounts 2:00; Sales 12:37; Sessions 22:45

Excel Data 6: Pivot Charts, Slicers, and Dashboards

• Handout
• Class Files (ZIP)
• Recorded Zoom Session
• Dashboard1 1:35 – PivotTable; PivotChart; Linked Drawings
• Dashboard2 15:26 – Pivot Tables, Pivot Charts, Slicers
• Dashboard3 32:05 – Formatted Table, Sparklines; Conditional Formatting, Charts