Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Series 1: Cleaning your dataset
1. Introduction- the importance of data quality and preparing your dataset
Intro video (0:53)
Excel workbook layout (4:05)
2. Excel features to help you quality check your data
2.1 Sort and Filter (13:26)
2.2 Find & replace (6:22)
Quiz
3. Equations to help clean and organise your data
3.1 Proper function (5:43)
3.2 Concatenate (8:12)
3.3 Trim to remove spaces (6:01)
3.4 Grouping with Vlookup (11:33)
3.5 Cell format - date, number, text (6:52)
Quiz
4. Creating easy pivot tables to summarise your data
4.1 Creating a pivot table - 1 variables - count, sum, average
4.2 Creating a pivot table - 2 variables & editing
4.3 Creating a pivot table - 2 variables with a filter
Quiz
5. Converting your pivot table to a simple chart
5.1 Creating a pivot chart
5.2 Editing your pivot chart - lables, heading, colour
Quiz
4.2 Creating a pivot table - 2 variables & editing
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock