★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/academy'>https://exceloffthegrid.com/'>https://exceloffthegrid.com/academy
★ Get the example file ★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/automate...
★ About this video ★
Reconciliations are a common and timeconsuming activity for finance and data professionals. So, in this video, we look at how to automate reconciliations with Power Query.
A reconciliation is nothing more than comparing two pieces of information and ensuring they contain the same values. Unfortunately, reconciliations can be timeconsuming, as a user may need to work down each list and tick off the items that are the same (literally with a pen and paper or onscreen). Then, the remaining items that are not the same need to be investigated so that corrective action can be taken.
Where all inputs contain a shared reference, we can automate the reconciliation process with Power Query. It can't investigate the differences but can certainly find them in a few seconds.
0:00 Introduction
0:29 Method
0:56 Example Files
1:45 Step 1: Create unique list
3:30 Step 2: Merge back to unique list
6:09 Step 3: Calculate variance
7:17 Result
7:50 What if records are not unique?
8:57 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel