How to Compare Two Excel Sheets (and find the differences)
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.
----------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:27 Compare Two Sheets in Different Excel Workbooks
03:48 Compare Two Excel Sheets in the Same Workbook
07:14 Compare Two Sheets in Highlight Differences
11:03 Compare Sheets in Fetch the Differences
----------------------------------------------------------------------------------------------------------------------
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/
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Видео How to Compare Two Excel Sheets (and find the differences) канала TrumpExcel
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.
----------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:27 Compare Two Sheets in Different Excel Workbooks
03:48 Compare Two Excel Sheets in the Same Workbook
07:14 Compare Two Sheets in Highlight Differences
11:03 Compare Sheets in Fetch the Differences
----------------------------------------------------------------------------------------------------------------------
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/
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Видео How to Compare Two Excel Sheets (and find the differences) канала TrumpExcel
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Compare Two Excel Sheets and Find Differences](https://i.ytimg.com/vi/nrDOQ_VDmQA/default.jpg)
![Vlookup simply explained](https://i.ytimg.com/vi/OoNEoSARCh4/default.jpg)
![25 AWESOME Excel Keyboard Shortcuts (You Should Know)!](https://i.ytimg.com/vi/TWYXcNm1I-Q/default.jpg)
![Compare Two Columns in Excel (for Matches & Differences)](https://i.ytimg.com/vi/fVut66RTIWQ/default.jpg)
![3 EASY Ways to Find and Remove Duplicates in Excel](https://i.ytimg.com/vi/ADArCWLz55Y/default.jpg)
![50 Ultimate Excel Tips and Tricks for 2020](https://i.ytimg.com/vi/FXs3WG7M-qk/default.jpg)
![](https://i.ytimg.com/vi/h8ad7bMoMAs/default.jpg)
![Excel Tutorial to Quickly Reconcile two sets of Data](https://i.ytimg.com/vi/T3nrEfQqgaI/default.jpg)
![Compare Two Sheets for Duplicates with Conditional Formatting](https://i.ytimg.com/vi/ksc6W2n5HRQ/default.jpg)
![10 Excel XLOOKUP Function Examples (Better than VLOOKUP & INDEX/MATCH)](https://i.ytimg.com/vi/hjfGyo6fe18/default.jpg)
![Combine Data From Multiple Worksheets into a Single Worksheet in Excel](https://i.ytimg.com/vi/dse9h2W4ejw/default.jpg)
![क्या है Vlookup? (हिंदी में)](https://i.ytimg.com/vi/caPp_I0mNL8/default.jpg)
![Compare Two Lists Using the VLOOKUP Formula](https://i.ytimg.com/vi/GdrOFBBEMQ8/default.jpg)
![10 Super Neat Ways to Clean Data in Excel](https://i.ytimg.com/vi/e0TfIbZXPeA/default.jpg)
![Excel - Find Matching Values in Two Worksheets, Tables or Columns Tutorial - Part 1](https://i.ytimg.com/vi/SdAHOMgutfU/default.jpg)
![Consolidate & Clean Multiple Excel Sheets in One Pivot Table](https://i.ytimg.com/vi/FI4HkCzMaIk/default.jpg)
![COMBINE Multiple Excel WORKBOOKS into One | ExcelJunction.com](https://i.ytimg.com/vi/JiAYngRcN0s/default.jpg)
![INDEX MATCH Explained (An Alternative to VLOOKUP)](https://i.ytimg.com/vi/yH_ArqoB0no/default.jpg)
![👉 2 Easy Way to Compare Lists in Excel in Hindi](https://i.ytimg.com/vi/vdvbRn8d25c/default.jpg)
![How to use Excel Index Match (the right way)](https://i.ytimg.com/vi/F264FpBDX28/default.jpg)