Data handling training
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