Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Cleaning in Excel - Must for further data analysis
Instructions Manual
Manual
Downloadable Files:
Excel Data Cleaning Case Studies- Please download for practice
Self Assessment Quiz
Data Cleaning Self Assessment Quiz
Super Data Cleaning in Excel Handbook
Super Data Cleaning in Excel Handbook
Go To (Special)
0501 Go To (Special) in Excel- Formulas with Errors (2:39)
0502 Go To (Special) in Excel- Formulas without Errors (2:01)
0503 Go To in Excel (Special) w. Ctrl+Enter (2:07)
0504 Go To (Special) in Excel- Fill Intermittent Blank Cells - Case 1 (5:58)
0505 Go To (Special) in Excel- Fill Intermittent Blank Cells - Case 2 (2:03)
0506 Go To (Special) in Excel- Visible Cells w. Shortcut (2:23)
Data Cleaning / "Sanitizing" & Text Formulas in Excel
1201 Text Formulas in Excel– Change Case using UPPER(), PROPER() & LOWER() (1:41)
1202 Text Formulas in Excel– Remove Leading, Trailing & excess Intermittent spaces using TRIM() (1:43)
1203 Text Formulas in Excel– Using LEN() & TRIM() together (1:32)
1204 Text Formulas in Excel– T(), N() & VALUE() (3:15)
1205 Text Formulas in Excel– REPT() for artificial Column Chart in a Cell (1:14)
1206 Text Formulas in Excel– REPT() & LEN() for adding leading zeroes before incomplete Cheque Nos. (4:28)
1207 Join cell contents using Concatenate (&) (4:55)
1208 Find & Replace in Excel– Using Wildcard character ( ) (3:07)
1209 Find & Replace in Excel– Using Wildcard character ( ) (2:22)
1210 Find & Replace in Excel– Neutralising Wildcard characters to remove them from data (2:37)
1211 Find & Replace in Excel– Word vs. Excel (6:04)
1212 Find & Replace in Excel– Cell Format (4:29)
1213 Text to Columns in Excel– Basics (Delimited) (2:49)
1214 Text to Columns in Excel– Basics (Fixed Width) + Hidden Trick (4:04)
1215 Text to Columns in Excel– Cleaning up numbers w. trailing minus sign (2:32)
1216 Text to Columns in Excel– Cleaning up numbers w. leading DrCr text (2:01)
1217 Text to Columns in Excel– Correcting invalid Dates (DMY) (3:23)
1218 Text to Columns in Excel– Correcting invalid Dates (YMD) (3:17)
1219 Text Formulas in Excel– LEFT(), RIGHT() & SEARCH() - 1 of 2 (4:17)
1220 Text Formulas in Excel– LEFT(), RIGHT() & SEARCH() - 2 of 2 (2:25)
1221 Text Formulas in Excel– MID() & LEN() (3:41)
Review our Excel Course on Data Cleaning
Flash Fill in Excel 2013 (7:21)
Data Cleaning Self Assessment Quiz
Complete and Continue