Data Handling covers the basic "must know" items for transforming your data using Excel and Sublime. Basic understanding of Excel is recommended prior to taking this course.
Excel Topics Covered
- Bringing Data into Excel
- Making it easier to view & understand your data
- Categorizing raw data
- Creating a basic calculation
- Vlookup
- Totals
- Tables
- Pivot tables
Sublime Topics Covered
- Finding data
- Editing multiple rows of data at once
- Cleaning Data
Individuals with disabilities are encouraged to attend all University of Iowa–sponsored events. If you are a person with a disability who requires a reasonable accommodation in order to participate in this program, please contact Joe Spring in advance at 319-353-6229 or joseph-spring@uiowa.edu.