MASTER EXCEL DATA CLEANING AND PREPARATION
Course Curriculum
LATEST LECTURES
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Please purchase from:
https://www.havishmconsulting.com/shop
Login details will be shared immediately once payment is received.