Loading...

Highline Excel 2016 Class 18: Clean & Transform Data: Replace, Flash Fill, Text To Columns, Formulas

15,774 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 3, 2016

Download Files: https://people.highline.edu/mgirvin/A...
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

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...