## Video #1:

## Watch Now

## Video #3:

## Coming Soon

# VIDEO #2:

# Clean & Extract Data Using Formulas & Excel’s Analytical Tools

*In this training you are going to learn the following:*

**03:55**– Proper Function

**05:00**– Trim Function

**08:55**– Text Function

**13:30**– Left Function

**15:05**– Right Function

**17:00**– Substitute Function

**18:55**– Replace Function

**20:45**– Convert Text to Numbers – TIP!!!

**22:50**– Number Formats

**24:00**– Find Blank Cells With Color

**25:35**– Remove Duplicates

**27:30**– Text to Column – Split Names

**28:30**– Flash Fill