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

???? Read my articles on Excel – https://xlncad.com/
???? Free calculators for everyday life – https://quickeasycalculators.com/

#powerquerytutorial #excel #powerbi