Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Cleaning
EXERCISE - 1 ➔ Understanding and Preparing the Dataset
Understand the dataset
Resize Columns
Renames column names
Convert date - data type
Select and treat all blank cells
Convert numbers stored as text into numbers
EXERCISE - 2 ➔ Text Manipulation and Extraction:
TRIM function
PROPER function
Extract pack size from product name using flash fill
Extract first word from product name using LEFT and FIND functions
Data parsing from text to columns
EXERCISE - 3 ➔ Data Cleaning
Remove duplicates
Add dollar sign to total sales column
Delete All formatting
Spell Check
Highlight errors
Find and replace
EXERCISE - 4 ➔ Data Filtering
Apply filters to columns
Advanced filtering
Filter by Colour or Icon
Sorting data
Extract first word from product name using LEFT and FIND functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock