Power Query Tips and Tricks - Excel Tutorial for Beginners

Published: 31 May 2020
on channel: Ajay Anand
46,551
1k

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.