Ultimate Automation using Power Query Reconciliation of 2 Datasets in MsExcel

YOUR LINK HERE:

http://youtube.com/watch?v=erdBhCvMYBc

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

#############################

New on site