How to Clean Data in Excel, using Power Query

File for practicing: https://www.dropbox.com/s/2mce2witdud...
In this movie, I will explain to you how to clean data in Excel fast using Power Query
This movie is a part of my online Power Query for Management Consultants: https://bit.ly/PowerQueryConsultants
Check also other resources:
1. How to combine data from different sheets: How to Combine Data From Multiple Wor...
2. Unpivot data: Unpivot Data in Excel (Convert column...
3. How to Add Conditional Column: How to add a Conditional Column in Po...
4. How to Add a Column from Examples: How to add a Column from Examples in ...
5. How to copy a Power Query: How to copy a Power Query?
6. My playlist on Essential Excel: http://bit.ly/ExcelPlaylistForU
7. Most useful Excel functions: https://badassconsultants.com/2018/10...

• #education
• #data_quality
• #clean_data
• #data_analysis
• #excel
• #power_query
• #management_consulting_projects
• #consulting_project
• #mckinsey
• #occ
• #pwc
• #ey
• #bain
• #bcg
• #alvarez_marsal