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 |
Sort – order the data is displayed
Filter – hide rows based on criteriaSingle, Multiple Levels, by Color, Sort Horizontally, Copy Filters |
|
| Excel Data 2: Advanced Filter and Basic PivotTables |
| Advanced Filter for Complex Filters. SubTotal() Function for Math with Filtered Data. Introduction to Pivot Tables to Create Summary Reports. |
|
| Excel Data 3: PivotTables |
| Build, Filter, and Arrange Data in a PivotTable. Retrieve data from a PivotTable, find the Number of Occurrences, Working with Text, Grouping Dates, and Multiple Values |
|
| Excel Data 4: Text Files, Text to Columns, and Flash Fill |
| Using TXT and CSV files, Import Wizard, Merging Multiple Excel Files, changing Text to Numbers and Numbers to Text, Text to Columns and Flash Fill |
|
| Excel Data 5: Substitution List vLookups/PivotTables |
| Create substitution lists – copy values to a new sheet, remove duplicates, create a new list of values to substitute or group, use vLookup for the new values. |
|
| Excel Data 6: Pivot Charts, Slicers, and Dynamic Dashboards |
| Create Dashboards to summarize your data into one sheet. PivotTables, PivotCharts, Linked Drawings, Slicers, Sparklines, Tables, Conditional Formatting, Charts |
|
| Excel Text Functions |
| Working with Text Functions – Change Case, Specific Parts of the Cell, Formatting Numbers as Text, Working with Special Characters, and Clean up Data with functions like Trim and Substitute. Math 3 or equivalent recommended. |
|
