Automate reconciliations with Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ https://exceloffthegrid.com/automate-reconciliations-with-power-query/ ★ About this video ★ Reconciliations are a common and time-consuming 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 time-consuming, 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 on-screen). 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/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel