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
![](https://s2.save4k.ru/pic/bSaLlNLAW44/maxresdefault.jpg)