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