| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 Ajay Anand | 2020-05-31 12:30:02 |  47,481 Views |
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
(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
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
