Download sample file: https://www.exceluniversity.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.exceluniversity.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