Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MASTER EXCEL DATA CLEANING AND PREPARATION
LATEST LECTURES
CONCAT AND TEXTJOIN (3:22)
CONCATENATING NUMBER AND TEXT (2:53)
COUNT COUNTBLANK SUMIFS COUNTIFS (10:02)
CREATE AUTO SEQUENCE (3:09)
CUSTOM FORMATS (5:56)
DATA VALIDATION (8:23)
DEALING WITH ERRORS (5:39)
DOLLAR SIGNS REFERENCING (6:34)
DYNAMIC ARRAYS (4:31)
EXACT (1:13)
EXCEL SHORTCUTS (4:30)
FILL BLANK CELLS (3:26)
FIND AND REPLACE (5:26)
FIND INCENTIVE (6:59)
FIND TOP N CUSTOMERS (5:26)
FLASH FILL AND COLUMN FROM EXAMPLES (5:34)
HORIZONTAL SORT (3:42)
HOW DATE AND TIME WORKS (4:26)
LAMBDA (8:29)
LINE BREAK WITH CODE AND CHAR (2:46)
NEW WINDOW (3:10)
PASTE SPECIAL (3:46)
PUT COMMENTS IN CELLS (2:06)
RANDOM NUMBERS (3:50)
REMOVE DUPLICATES - GET UNIQUE VALUES (3:14)
ROUND (5:58)
SEPARATE FIRST MIDDLE AND LAST NAME (4:32)
SEPARATE FIRST NAME AND LAST NAME (6:43)
SORT AND FILTER (8:29)
TEXT PADDING (4:55)
TEXT TO COLUMNS (3:12)
TRIM (1:03)
UNPIVOT (3:09)
UPPER PROPER LOWER (2:38)
VALUE AND TEXT (1:52)
VLOOKUP (5:43)
VSTACK HSTACK (5:07)
WRITE BETTER FORMULAS (6:50)
GET YOUR CERTIFICATE
FILES
EXAMPLES - DEPRECATED
INTRODUCTION TO THE COURSE (2:41)
SEPARATE FIRST 3 CHARACTERS USING LEFT (1:45)
SEPARATE FIRST 3 OR 4 CHARACTERS LEFT AND FIND (2:22)
EXTRACT MIDDLE 2 CHARACTERS USING MID (3:03)
EXTRACT RIGHT 8 CHARACTERS USING RIGHT (0:47)
PADDING OF FIRST TWO AND LAST TWO NUMBERS (2:26)
REPLACE LAST 8 CHARACTERS WITH X USING REPT (3:43)
SEPARATE FIRST NAME AND LAST NAME (3:08)
EXTRACTING FIRST, MIDDLE AND LAST NAME (11:42)
JOIN FIRST NAME AND LAST NAME USING CONCATENATE (1:33)
CREATE COMPLETE ADDRESS USING TEXTJOIN (4:16)
CREATE A COMPLETE SERIES USING CONCAT (0:55)
CONCATENATE WITH LINE BREAK (3:35)
COMBINE DATE USING TEXT (2:31)
CHANGE CASE USING UPPER, LOWER, PROPER (0:57)
CONVERT TEXT INTO NUMBERS USING VALUE (2:30)
REMOVE EXTRA SPACES USING TRIM (1:59)
REMOVING UNWANTED CHARACTERS USING SUBSTITUTE (4:48)
COUNT NUMBER OF WORDS USING SUBSTITUTE (2:08)
EXTRACT FILE NAME (3:56)
SEARCH FOR PATTERN USING SEARCH (2:29)
CREATE AN ORDINAL NUMBER (2:17)
REMOVE TITLES FROM NAME (2:28)
TEXT TO COLUMNS (1:16)
USING FIND AND REPLACE (7:20)
GO TO SPECIAL (5:30)
FILL BLANK CELLS (2:20)
HORIZONTAL SORT (3:26)
CLEAR FORMATS (2:38)
FLASH FILL (8:50)
SOLUTIONS
SEPARATE FIRST 3 CHARACTERS USING LEFT
Complete and Continue