Highest grossing concert tours dataset cleaned

🎯Goal: clean data to make it ready to use for analysis.

✅Plan: use Excel to clean the data.

⏱️Time: 30min.

🌐Source: Kaggle. 

I turned this initial dirty raw data from Kaggle about the highest-grossing concert tours...

... into this clean data ready-to-use...

... in 30min, using these Excel functions & features used:

1. CHAR
2. CLEAN
3. CONCATENATE
4. Define Name
5. FIND
6. Format as table
7. IF
8. IFERROR
9. IFERROR
10. ISNUMBER
11. LEFT
12. MID
13. NUMBERVALUE
14. REPLACE
15. SEARCH
16. TEXT
17. TRIM
18. Wildcards

You can download the Excel file here. The file´s "2_cleaning" sheet contains comments with the cleaning actions needed for each field, like this: