Скачать с ютуб Stop Doing Manual Reconciliations in Excel: Use Power Query в хорошем качестве

Stop Doing Manual Reconciliations in Excel: Use Power Query

Download sample file: https://www.excel-university.com/yt_f... Are you spending hours every month reconciling your data in Excel? There is a better way. In this video, I show you how to use Power Query to automatically reconcile your data, and save yourself hours of work each month. Learning Microsoft Excel on YouTube is the slow way....Learn Excel the FAST way, find out how here 👉 https://www.excel-university.com/yt Subscribe here 👉 https://www.youtube.com/c/ExcelUniver... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive! Check out 7 Excel Time Hacks Everyone Should Know here    • 7 Excel Time Hacks Everyone Should Kn...   Watch VLOOKUP Hacks Playlist here    • VLOOKUP Hacks Series   Watch VLOOKUP vs SUMIFS Playlist here    • VLOOKUP vs SUMIFS Series   Watch Dynamic Arrays playlist here    • Dynamic Arrays Series   Watch Treasure Maps playlist here    • Treasure Maps Series   Watch Slow to Fast playlist here    • Slow to Fast Series   Table of Contents: 00:00 Reconciliations 00:06 Objectives 00:50 Overview 00:58 Step 1 - Cleared Checks 08:03 Step 2 - Outstanding Checks 09:06 Step 3 - Bank Charges 09:57 Step 4 - Deposits in Transit 13:00 Step 5 - Bank Additions 13:45 Step 6 - Retrieve Values 14:14 Refresh Future Periods 15:40 Summary Recap