Download sample file: https://www.excel-university.com/yt_fxm8ay8sudu/
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/ExcelUniversityInc?sub_confirmation=1 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 https://youtu.be/90RmBAmNnG0
Watch VLOOKUP Hacks Playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5EwVI-6MxpSZOVcoz9eEPVI
Watch VLOOKUP vs SUMIFS Playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5EprSnwbRF8_jCVQKde7cjr
Watch Dynamic Arrays playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5FmzOe_Pb-zapkM4cX6PDC_
Watch Treasure Maps playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5FTN2vOk-J55wsCej9l-8Dn
Watch Slow to Fast playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5HZ7zlZdmYrEUVAW9jYAWzE
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