In this video, I will show you a couple of methods to compare two Excel sheets for differences or compare two Excel files.
There are some in-built features in Excel, such as View side-by-side and New Window that make the comparison of sheets easy. It allows you to open each sheet as a separate file and view these side-by-side.
This is a good method when you want to manually compare the sheets.
In case you have huge datasets, you can also use the conditional formatting method, or the formula method covered in this video.
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).
This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #ExcelTutorial