Say goodbye to late nights and spreadsheet struggles! Your ticket to freedom has arrived with Excel University Speed Challenge excel-university.com/challenge ️ Unlock hidden Excel tricks and hacks, and become a time-saving Excel pro. ️ Don’t miss out, join now! excel-university.com/challenge

Subscribe here https://www.youtube.com/@ExcelU and turn on all notifications for MS Excel formula hacks that will make you more productive!

This video shows how to use Excel’s Power Query to compare two lists. Specifically, it demonstrates:
– comparing two single-column lists
– show which values appear in both lists
– show which values appear in only one list
– matching on multiple columns
– matching on multiple columns and computing the difference between the amount values from both tables

Chapters in this video:
00:00 – Introduction
00:17 – Single Column
02:26 – Multiple Column Tables
04:05 – Compare Amounts

Please take the opportunity to connect and share this video with your friends and family if you find it useful.