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
#PowerQuery #excel #exceltutorialforbeginners
Watch video Power Query Tips and Tricks - Excel Tutorial for Beginners online without registration, duration hours minute second in high quality. This video was added by user Ajay Anand 31 May 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 46,551 once and liked it 1 thousand people.