MENU

Fun & Interesting

How To Compare Data in Excel Files and Find Differences - Bump Files Like a Pro!

Sharon Smith 6,193 3 months ago
Video Not Working? Fix It Now

How to compare data in Excel files and find differences between Excel worksheets! Have you heard people say, "Just bump that file against this one" or "Bump those files together?" Well, there are many ways we can do this in Excel. In this video, I'll show you three real-life examples, including: How to find missing data between two Excel files using XLOOKUP; How to find differences between two Excel reports using IF Formulas and Conditional Formatting; and How to detect duplicates in your data using Excel's built-in highlight duplicates feature. First, we'll use XLOOKUP to find which employees are missing work assignments in our HR system. Second, we'll use Conditional Formatting and formulas to highlight employee data changes on a new HR report compared to an older report. Third, we will detect duplicate job codes that were created when we removed a leading character from our job code. TIMESTAMPS ⏰ 00:00 Compare Data Between Excel Files and Worksheets 00:31 XLOOKUP to Find Missing Data Between Two Excel Files 04:18 IF Formula to Find Salary Changes in Excel Worksheets 06:06 Conditional Formatting to Find Data Changes Between Two Reports 08:51 Detect Duplicates with Highlight Duplicates Feature in Excel COURSE 🎒 Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: https://www.youtube.com/playlist?list=PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs WATCH NEXT 📺 Match Names on Two Sheets in Excel with VLOOKUP: https://youtu.be/_2HODd8Gq3A CHANNEL LINK 📺 https://www.youtube.com/@SharonSmith Visit my Channel page on YouTube to see all my videos, playlists, community posts and more! TEMPLATES 📄 Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv Thank you for supporting my channel! 🌟 FREE DOWNLOADS ⬇️ ✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals. CONNECT WITH ME 📎 Visit my website: https://www.sharonsmithhr.com for more information, tools and resources. LinkedIn: https://www.linkedin.com/in/sharonsmithhr Twitter: https://twitter.com/SharonSmithHR Instagram: https://www.instagram.com/sharonsmithlearning/ Facebook: https://www.facebook.com/SharonSmithLearning GEAR ⚙️ 🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!) 🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!) 🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b 📗 Green Screen: https://amzn.to/2DnHsY2 📸 Camera: https://amzn.to/39KvpQA 🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam) RESOURCES 📚 ✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog 🖥️ TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel! SUPPORT THIS CHANNEL 🙌 - Hit the "$Thanks" button on any video, or - Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills. You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️ PLAYLISTS 🎥 ➤ Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD ➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv ➤PowerPoint Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM ➤ Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90 ➤ Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW ➤ Word Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

Comment