12 Methods to Clean Data in Excel using Power Query
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
🟠 Books on Excel https://xlncad.com/excel-resources/
🟡 Get Office 365 Subscription https://microsoft-us.evyy.net/3NE6y
🔵 Download my free ebook on Excel Macros http://eepurl.com/gpT0RD
🟢 Read my articles on Excel https://xlncad.com/
Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!
#PowerQuery #PowerQueryTip #PowerQueryTrick
Видео 12 Methods to Clean Data in Excel using Power Query канала Ajay Anand
(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
🟠 Books on Excel https://xlncad.com/excel-resources/
🟡 Get Office 365 Subscription https://microsoft-us.evyy.net/3NE6y
🔵 Download my free ebook on Excel Macros http://eepurl.com/gpT0RD
🟢 Read my articles on Excel https://xlncad.com/
Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!
#PowerQuery #PowerQueryTip #PowerQueryTrick
Видео 12 Methods to Clean Data in Excel using Power Query канала Ajay Anand
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Power Query Course: Power Query Tutorial for Beginners10 Super Neat Ways to Clean Data in ExcelPower Query: Index and Modulo Functions6 FREE Add-Ins for Excel to Start Using NowExcel: Data Cleaning with Excel Part 1Power Query Tutorial - What is it, how to use it & 4 complete examples + Free downloadLearn Excel - Clean Data with Power Query - Podcast 2037Get Multiple Files Containing Multiple Sheets with Power QueryPower Query Overview - Automate Data Tasks in Excel & Power BIConsolidate & Clean Multiple Excel Sheets in One Pivot TableExcel Crash Course - Data Cleaning in Excel - Microsoft Excel TutorialExcel Power Query Data Cleansing Part 1 Different Ways to Format Data Using Power QueryAdvanced Excel Power Query - Case Study 5 : Clean Financial dataHow to easily automate boring Excel tasks with Power Query!Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)Properly Convert PDF to Excel25 Amazing Power Query Tips and TricksGetting Started with Power Pivot & Power Query in Excel - 1-Hour ClassPower Query Unpivot - fix 4 common data layouts (incl. workbook)How Power Query Will Change the Way You Use Excel