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
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