12 Methods to Clean Data using Power Query in Excel are explained in this video.
(00:00) 1. Remove Duplicates
(03:02) 2. Add an Index Column
(06:35 ) 3. Fill Blank Cells
(09:09) 4. Remove Special Characters
(13:16) 5. Change Letter Cases
(15:31) 6. UnPivot Data
(17:31) 7. Remove Columns
(19:52) 8. Transpose Data
(21:58) 9. Text to Columns
(24:41) 10. Remove Extra Spaces
(29:35) 11. Remove Line Breaks
(31:13) 12. Remove Errors

If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
buymeacoffee.com/ajayanand

Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
Check these Books on Excel - https://xlncad.com/excel-resources/
Read my articles on Excel - https://xlncad.com/

#powerquerytutorial #excellence #exceltutorialforbeginners