Web
Analytics
Connect with us

Tips

How to Compare Two Excel Files?

Published

on

How to use Microsoft excel

By being an Excel wizard, you can indeed save a heck lot of your time and can do complex tasks easily. Did you know that you can compare excel files with some simple tweaks and options? If not, then this article is for you.

So, do you want to know how to compare two excel files? If yes then you are certainly at the right place. Comparing the two data graphically can also make the data more representable and easy to understand. You can create charts to show the data. Here is how to create charts in Excel. So, let’s get started with the same:

How to Compare Two Excel Files?

Method 1: Using compare feature.

If you are using Microsoft Excel 2013 edition, then you can easily access the compare feature. So, as it is clearly stated that the prerequisites of this method are Excel 2013, and two workbooks that you want to compare. This is it.

Step #1: You know the obvious step, right. You need to open both the workbooks on Excel and then proceed to the next steps which will guide you how to compare two excel files?

Step #2: Once you have both the workbooks opened in your excel dashboards then you require navigating to the inquire tab. Once you are there, then you need to select “Compare Files” option from the ribbon itself.

This will open a “Select files to compare” dialog box for you.

On the dialog box, all that you require is to select both the Excel files that you want to compare. You will see two fields as “Compare” and “To”.

Step #3: After successfully going through the previous steps, you now require clicking on “Compare” button which is positioned at the bottom of the “Select files to compare” dialog box.

Now, your part has come to an end. Excel will now do the rest for you. It will highlight all the differences like formulas, data, formatting and others. There is a total of fourteen factors where the Excel compare tool pays utmost heed to. To be more precise, it highlights the difference based on these 14 factors. However, you can certainly choose what differences should be emphasized and what not.

The fourteen areas are:

1: Macros.

2: Entered Values.

3: Formulas.

4: Calculated Values.

5: SysGen Formulas.

6: Structural.

7: Names.

8: SysGen Formula errors.

9: SysGen Names.

10: SysGen names errors.

11: Cell format.

12: Cell Protection.

13: Sheet/Workbook protection.

14: Data connection.

This way you can easily compare two excel files. You can also compare two excel data using Bar graphs. Bar graphs can make the representation more appealing. If you don't know how to make a bar graph, see the link.

Method 2: Using Side by Side.

Unlike the previous method which does the needful for you, this method will allow you to compare your workbooks manually. You will have to check manually for the all the differences by scrolling down for each and every page of the two workbooks. This method will also work on the previous version of Microsoft Excel. So, let’s get started:

Step #1: In this very first step, you need to launch both the workbooks. Once you are done with the same, then you are ready to go to the next steps.

how-to-compare-two-excel-files

Step #2: Now, from the top navigation bar, you need to navigate to the “View” tab. Once you have navigated the same then, you need to click on it.

how-to-compare-two-excel-files

Step #3: From the “view” ribbon, you now need to locate “View Side by Side”. The “view side by side” option can be seen in the “Window” section of the view tab. This will open a dialog box for you. On the dialog box, you have to select the workbook which you want to compare with the currently active workbook. Once you are done with the same, then all that you require is to click on “OK” button.

how-to-compare-two-excel-files

Step #4: The previous step of yours will open the two workbooks side by side. Now, you can manually scroll and can easily spot the differences. When you scroll the window, both the workbooks will be scrolled together in sync. This way you can easily compare the two file and spot the contrast.

Additionally, if you want to turn off the synchronous scrolling, then you can go for the “Synchronous Scrolling” option from the Window section and turn it off.

how-to-compare-two-excel-files

Step #5: The moment you are done with the comparison of two Excel files then you now need to turn off the View side by side option and revert to the normal mode. You can easily do this by clicking again on “View Side by Side” option and this way you will be back to the normal mode.

[Additional Information]: How to create drop-down menu in excel?

It may seem a little off topic, but we thought that you might be interested in know how to create a drop-down menu in Excel? This is why you are brought to this additional information section. So, here we go:

Step #1:   Open Excel sheet and select the cell or range for which you want to drop-down list. You can even select multiple cells or even a full column. If you want to select a handful of columns then you will have to press control while selecting the desired ones.

how-to-compare-two-excel-files

Step #2: After step #1, you now need to select Excel data validation. For this, you will have to follow the following route: Data tab -> Data tools. This will result in an appearance of a list from which you are required to select “Data Validation.”

how-to-compare-two-excel-files

Step #3: A new window will appear after you select “Data Validation” in the previous step. From the window, you have to select “list” in the allow box.

how-to-compare-two-excel-files
After this type those entities which you want to appear on your list.

Make sure that you have checked the box next to which “In-cell dropdown” is written.

Step #4: Now, as the final step, you are required to click on OK and this way you can easily create a drop-down menu in excel.

how-to-compare-two-excel-files

We hope that this might be of some help for you. You can also compare two datas by calculating the average. Here is you can calculate the average in Excel.

This brought us to the end of this article on “How to compare two excel sheets?

Do you know any other method by which you can easily compare two excel sheets? If yes, then do tell us by dropping a line through the comments section. Your addition is highly valuable.

If you liked this article then do not forget to share it. Thank you.

A student of life, writer, technology freak, and a thinker.

Continue Reading
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Tips

How To Use Google Advanced Image Search For Finding Royalty FREE Images

Published

on

Let us start with a simple question, what's the most common way that you use to find images? Most of the people just Google about the topic, save the images that they like and use them for their purpose.

Many people even put their own watermarks on the images they found on Google, well all these things are actually wrong you may have to pay a fine of almost 1000$ per image.

You never know that the image you downloaded from Google is copyrighted or not. Personally speaking, many of my fellow blogger friends have already faced an issue because of using copyrighted images.

Sometimes you may even have to shut your blog down.

You must be thinking that the best way is to generate the images yourself. Well, this is not the only solution, no doubt this is one of the best ways. I

n this article, I will be showing you How To Use Google Advanced Image Search For Finding Royalty FREE Images.

You must be wondering what do I exactly mean by Royalty free images, these are some images which are not acclaimed/copyrighted by any online firm or blog.

It means you guys can use these images in any way you want, no one will charge you even if you put on your own watermark on these images.

These images also prove to be pretty handy to the people who design flyers/posters for different firms and educational agencies.

So without any further delay lets get down to the main topic, below are given the steps using which you will easily be able to find some useful and royalty free images.

Follow the steps as listed below:-

  1. Google whichever topic that you want to search the image on and select the images tab.
  2. Now all the right you will see a gear icon, all you need to do is just click on that gear icon and go to advanced search.
  3. Now once you click on Advanced search, it will open up a completely new window in the same tab, here you will see a lot many setting, all you need to do is just simply scroll down to Usage Rights once you click on that it will open up a drop-down menu, from this drop-down menu select “Free to use and share even commercially “.
  4. Now once you have done this, without playing around with the other options, just go ahead and click on advanced search button which will be on the right side in blue colour.
  5. Once you click on the button it will take you back to the image window in the same tab, but this time all the images you see up there are completely royalty free and meant to be used in any way that you want to.
  6. So all good to go? you will now also get some additional features, for eg:- when you click on Labeled for reuse you will get several options and you select the one you feel the most suitable to you.

Hope this article helped you out, Keep stalking for more tricks 🙂

Continue Reading

Google Plus

How to Delete Google Plus Profile Easily

Published

on

Are you one of those, who actually think that Google is making you use a Google Plus account forcefully?

Well, let me tell you that Google has taken some pretty awesome steps to make a Google Plus profile almost compulsory for each and every person in order to use some of these features.

Although Google Plus has some really nice and refreshing features which give us a break from the blues of Facebook and Twitter any social account needs attention and maintenance.

So many people really fed up of managing too many social networking accounts, well don't you worry we have got you covered under this section.

I am pretty sure some of you must have tried your level best to delete your Google Plus account.

I have personally seen some of my friends uninstalling there Google Plus Apps, thinking it would delete their account, two of them actually did even stopped using their Gmail ids.

Well truly speaking this is not rocket science, you can easily do this in few clicks, provided you know where to click:-P,

In this article, I will be giving you the complete step by step instructions on how to delete your Google Plus Profile easily.

STEP – 1  First of all log into your Gmail account, remember you have to log into your main Gmail account, not into your Google Plus ( Don't worry this is not gonna delete your Gmail ID)

STEP – 2 Now, once you are logged in you will be able to see your small profile photo in the left corner of the screen, all you need to do is just click on it, now a small window will appear as a drop-down, click on ‘Account' which would be written in blue colour.

STEP – 3 Once you click on account, a new window will open up with all the major settings of your main Gmail Account. Now you have to click on the Data Tools tab, by default it will be on the Personal Information Tab.

STEP – 4 You guys are almost done deleting your Google Plus profile, All you gotta do now is that click on the option ‘Delete Google+ profile and features, in this step you have a be a bit careful because if you select any other option you may end up losing your Gmail id as well. So make sure that you guys click on ‘Delete Google+ profile and features' only.

STEP – 5 Well this is the step where most of the people opt out of the process of deleting there Google Plus profile, because of a simple pop up designed by Google to threaten you a bit before deleting your profile. This popup will tell you guys what all features you would be turning off once you have deleted your Google Plus profile.

My suggestion is that go through it once and if you find that a really essential feature may be deleted you may opt out, although the chances are very few.

Hence just go ahead and click on the Remove selected services button.

So, that it 5 easy steps and you are rid of your Google+ plus profile, hope you guys enjoyed the tutorial, keep stalking for more tips and tricks.

Continue Reading

iPhone

How to Convert DVD to iTunes

Published

on

Convert DVD to iTunes is a very common thought among us but the solution is very simple is not known by many of us!

One may need this for just copying the DVD stuff from iTunes to iPad or iPhone and listen to it on the go smoothly! So we here are gonna know how easily we can convert a ripped DVD or CD into your iTunes.

and we all are very well aware that we cannot convert DVD to iTunes directly as iTunes doesn't support the DVD format so what to do next ??

Actually what you need is only a professional DVD ripper that can help you convert DVD movies to iTunes supported video formats with fast with the good video quality.

An aimersoft DVD Ripper is the best alternative software for this task! Besides, one can crop the black bars we see on low-resolution large screens, add special video effects, split or merge videos, add titles and subtitles etc.

As you like with the built-in editor. Download this software to watch your stuff running on iPhone 5, New iPad, iPod touch, etc. in just a few mouse clicks!

Convert DVD to iTunes Now

Download here –

Install this software and follow the steps-

Import DVD to the program, Launch Aimersoft DVD Ripper, click on “Load DVD” to add DVD Movies or ISO files that you want to rip to iTunes.

One can always click edit button to add editing effects and also one can take screenshots and preview the video which is to be converted.

Select the output format in which you want to have your video converted that will be in a choice with the products.

Now just the last step to start converting your video to your specified format and you just convert DVD to iTunes after this step and also now iTunes will read this stuff may be an audio-video or anything you want!

Transfer all your stuff to your iTunes and then to any iOSdevice that you like that may be your brand new iPhone 5. This is the biggest difficulties that all newbies who started using iOS after android face this daily!

Continue Reading

Software

How to Embed YouTube Videos in PowerPoint

Published

on

So here we are with another informatic post for How to embed Youtube Video in PowerPoint in seconds and ease! Embedding Youtube Video in PowerPoint is not a very easy task indeed but is important sometimes.

Why embed Youtube Video in PowerPoint?

The question is very clear in all senses, and the answer for this will also be the same, Yes adding a Youtube Video in PowerPoint presentation will add a lot of good effects including sympathetic support from the audience.

A video explains few things better than slides so after the presentation adding a summed up video of the presentation will leave a better impact of the product you are presenting.

A few things cannot be explained in presentation like working off some machinery so adding an animated video will always make it crystal clear to the viewer.

Now If anyone is interested to know that how to o this then read on to take the advantages of the stated above.

Embedding Youtube Video in PowerPoint!

We have 3 ways to embed a Youtube video into a presentation. Firstly one can embed it into the presentation which will require good internet connectivity when running the presentation.

Secondly, One can export videos from Google Docs. The third simple is to download youtube video into your hard disk and insert it simply!

Embed YouTube Videos Directly into PowerPoint!

This method is recommended only if one has the security of a good internet connection at the venue of the presentation.

One can do this by Downloading and installing the YouTube Wizard plug-in and it will add a new “Insert YouTube Video” command to your PowerPoint Toolbar.

One can easily resize and reshape the player like any other object in powerpoint which makes it really versatile to use!

You simply have to type the URL of the YouTube video and follow the wizard to embed the YouTube video player in your current PowerPoint slide.

Get Videos from Google Docs into PowerPoint

While Google Docs does provide an “Export as PPT” option, the problem with this format is that it converts all embedded YouTube clips into static images which is something you don’t want.

There’s however a simple workaround – just publish that Google Docs presentation as an HTML slideshow and then insert it like a web page in PowerPoint.

Thus you can play YouTube clips inside PowerPoint even though they are part of your Google Docs presentation.

“http://www.youtube.com/embed/vvu9CBVDqhc

An advantage of this approach is that if you change any of the YouTube videos clip in your original Google Docs presentation, it will be reflected in the PowerPoint presentation as well.

Embed Youtube video in PowerPoint from your PC!

This is the best-opted option for when one is not sure for internet connectivity at the venue.

Also adding this method is not versatile with the people who change their laptop regularly as one has to copy the video along with the presentation whenever it is to be presented.

First, download the YouTube video to your computer in either Windows Media or AVI format since PowerPoint doesn’t understand the default FLV or MP4 formats of YouTube.

Once the video is saved as an AVI or WMV file, switch to PowerPoint and choose Insert – > Movie – > “Movie from file” to put the YouTube video into the current slide.

This was just how to add Youtube Video in PowerPoint with 3 easy methods! comments and problems are always welcomed in the comments! 🙂

Continue Reading

Tips

How to Delete all Your Personal Information from the Internet

Published

on

As you might be knowing there are a lot many firms, that only maintain databases, about what people do, rather it is online or offline, where do they live, what work they do, etc. etc.

Now, what if one wants to delete personal information from the internet.

Let's get it, it's almost impossible to delete all your personal information from the internet, but yes you can, however, limit the information, you have on the internet, which is made by an Online Privacy firm.

DeleteMobile is an iOS app, that was launched for Apple Devices, recently and already has gained several users.

And it claims to strip your personal data from many large database websites. that also collect it and even sell it, for example, Spoke. Hence helping you to delete personal Information from the internet.

Data Brokers Record Everything:

There a more than over dozens of Data Brokers in the market, that tend to record and maintain a database of everything people do, whether it be Online or Offline.

So, this collection of all this data leads to the formation of virtual you. So it may fetch to any firm that wants to investigate about you, online.  So you could use this app to delete your personal information if you want.

The DeleteMobile App is free to search about yourself, but you have to subscribe to it, with a $24.99 subscription for three months, and in this period you could apply for multiple deletions of your personal information from internet databases.

How the App to Deletes Personal Information from the Internet:

Well, so see how this  DelteMobile app will delete personal information from internet databases. After downloading it, and having installed it, it requires a basic sign -up.

The app searches around data brokers for that basic information you provided across the internet. So, as he searches ends, results would pop up, that the app found closely related to that app.

A user can click  “This is not me” if you didn't find the information about yourself, or “Delete Me”, so this DeleteMobile app deletes the data from that data broker clients. This is how the app deletes personal information from the internet.

This is how the app works and deletes your personal information from the internet. However, the app is still getting mixed reviews on the Apple Store.

Also, the information you enter while sign up is kept confidential, and it also mentioned in the Privacy Policy of the App.

This app works a lot around human effort and internet technology. And the app is really user-friendly, as-as soon as the list is down about your personal information, you are informed about it.

And this is how the app uses various methods, to delete personal information from internet data brokers.

Continue Reading

Trending