Cleaning Messy Data in an Excel Spreadsheet

Here's a link to the same data in a Google sheet. I recommend a copy/paste into MS Excel to follow-along: https://docs.google.com/spreadsheets/d/1tcWfBYkmarE_LXy730ORWMQDcuutiViIVHODV2kxZG4/edit?usp=sharing

In this session we'll cover:
- Copy/Pasting/Renaming Tabs
- Cell formatting and cell errors
- IFERROR formulas
- DATE formulas
- Text-to-Columns Tools with delimiters
- IF logic with LEN and LEFT formulas to clean Zip Codes

Видео Cleaning Messy Data in an Excel Spreadsheet канала Andrew Lockwood