Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm
In this video learn about:
1. (00:13) Introduction
2. (01:08) Find & Replace feature (Clean Data)
3. (03:49) Flash Fill: Clean Data (10 Examples)
4. (11:14) Text To Columns (TTC)
5. (12:16) Text To Columns (TTC) to split data apart into multiple columns based on a delimiter (Transform Data Set)
6. (15:31) Text To Columns (TTC) to convert ISO Text Dates to Serial Number Dates (Clean Data)
7. (16:11) Text To Columns (TTC) to convert Text Numbers back to Numbers (Clean Data)
8. (17:13) Review of Formulas to Clean and Transform Data.
9. (18:47) When to use Formulas for Data Cleaning and Transforming.
10. (19:36) Extract First Name automatically when source data changes with Formula (Clean Data). See LEFT & SEARCH functions.
11. (20:28) Formula for Last Name when some names have middle name and some do not (Clean). See functions: SUBSTITUTE, REPT, LEN, RIGHT functions.
12. (23:31) Summary