Ultimate Automation using Power Query - Reconciliation of 2 Datasets in Ms-Excel

Join into "The Excelism" Telegram Public Group for Learning FREE Excel: https://t.me/TheExcelism Visit our website https://www.excelism.in View All #1MinuteSnippets here:    • 1 Minute Snippets - Learn Excel Trick in l...   Reconciliation of 2 Datasets in Ms-Excel using Consolidate Feature, Filters and SUMIF() watch here:    • How to Reconcile 2 Datasets Using Ms-Excel...   In this video, you will be learning the following: 1. Using Power Query 2. Using Reference Queries 3. Importing Data from Table to the Queries 4. Using Group by in Power Query 5. Using Sort in Power Query 6. Using Add Conditional Column in Power Query 7. Using Add Custom Column in Power Query 8. Using Merge Feature in Power Query 9. Using Append Feature in Power Query 10. Using Load to Table into Excel from Power Query 11. Using Remove Duplicates in Power Query 12. Using Filters in Power Query 13. Changing the Table format in Excel 14. Changing the Properties of the Table in Ms-Excel and many more..