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.