Course Content
Introduction
Fiidiyowga Casharka hordhaca koorsadan
0/1
All you need to know about cleaning data
09:41
Prepare data for analysis by removing unwanted values & formatting
0/13
Adjust Column Width & Row Heights
05:16
Clean blanks and bad formatting in Data
05:53
Remove Rows containing some blank cells
05:00
Format numeric data properly & remove duplicates
05:46
Change case of text data and trim off extra spaces
07:00
Run spell check and name your table of data
05:18
Replace unwanted values & tabulate your data
04:15
Import text file into excel and transform
06:00
Clean and Transform text file
10:00
Convert Numbers into percentage
03:00
Introduction to Power Query & importing data
10:45
Removes columns/values, split values, rename columns etc.
10:37
Basic Analysis, additional sales data & refresh Query
07:00
Advanced Data Cleaning Course in Excel
Please complete previous Lesson first
All you need to know about cleaning data
0% Complete