Recently I had to deal with a weird data clean up scenario. My client (a large hotel chain) was getting room booking data with mixed format. The booking date column occasionally has a text value which needs to extracted and used for proper analysis. In this short tip video, let me show you how to deal with such problems using Excel.

⏱Video topics 👉
===============
0:00 - The text & numbers problem
0:39 - Avoiding the problem by removing text data
2:32 - How to separate and properly arrange data (with Power Query)

📗Sample file
============
If you want to practice this concept, here is a sample workbook.
[ Ссылка ]

👩‍💻👨‍🎓 LEARN MORE about Data Cleaning
=================================

📺 YOUTUBE VIDEOS:

on Power Query (complete tutorial, 80 mins, 260k views) - [ Ссылка ]
on Data cleaning (top 10 tips, 15 mins, 300k views) - [ Ссылка ]
More data cleaning (10 more tips, 15 mins, 50k views) - [ Ссылка ]


👩‍💻 COURSES:

💥Power Query mini-course (2 hours, full PQ with many practical examples) - [ Ссылка ]

📚FULL Excel (24+ hours, 100s of examples) - [ Ссылка ]

~

A data analyst walks in to the bar. A pretty lady smiles at him and walks over. She says, "You look cool. Here is my number. Text me your number."
The data analyst replies, "Sorry, but I don't TEXT() numbers" 🤦‍♂️😂

#datacleaning #excel

свернуть