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...  

Reconciliation of 2 Datasets in Ms-Excel using Consolidate Feature, Filters and SUMIF() watch here:    • How to Reconcile 2 Datasets Using Ms-...  

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..