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. Like to invest my time into Digital Marketing and help clients easily reach their marketing goals with proven strategies and roadmaps.

Continue Reading
Click to comment

Leave a Reply

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

Tips

How to Create Personalized Start Button for Windows 8?

Published

on

wINDOWS 8 START MENU

Its a quite a few months since the Windows 8 has launched. If you are among those people who love to have a Start button still in windows 8, then here we are providing you a classic tip “How to Create Personalized Start Button for Windows 8?” Yes you have certainly came across several apps, softwares and extensions. But this is a complete different new dimension. Protecting your computer is also crucial. See 3 best antiviruses for Windows 8 that will definitely going to protect your computer from harmful virus.

The CLSID

customise-WINDOWS-8-START-MENU

While you won’t have to go traipsing around the registry in order to implement this technique – I already did that – you may be curious as to where the CLSID came from. Essentially, a CLSID key is a part of the registry that contains code that provides access to specific system objects in the operating system, such as system folders. The CLSID keys can be found in two places in the Registry:

HKEY_LOCAL_MACHINESOFTWAREClassesCLSID and HKEY_CLASSES_ROOTCLSID.

Now, under normal circumstances, you would never need to use a CLSID because it is specifically designed to be used by developers and the operating system. In fact, a CLSID is a 128 bit Hexadecimal number enclosed in braces, so it’s not very user friendly.

In any case, the CLSID that provides access to the Apps screen is

{2559a1f8-21d7-11d4-bdaf-00c04f60b9f0}

The shortcut

To use the CLSID to launch the Apps screen, you’ll use the Shell command. In order to launch a Shell command from a shortcut, you need to use the explorer.exe command. As such, the shortcut to launch the Apps screen consists of the following command line. (Take note that there are three colons between the word shell and the left brace. Also keep in mind that there is only one space in the whole command line between the .exe file extension and the word shell.)

explorer.exe shell:::{2559a1f8-21d7-11d4-bdaf-00c04f60b9f0}

To create the shortcut, just open the Documents folder, right-click on the background, and choose the New | Shortcut command. When you see the first screen in the Create Shortcut wizard, type the shortcut in the text box.

When you see the second screen in the Create Shortcut wizard, type a short name for your shortcut.To complete the wizard, just click Finish. As soon as you see the shortcut icon, right click on it and select the Properties command.

When you see the Properties dialog box, click the Change Icon button to open the Change Icon dialog box. By default the Change Icon dialog box displays the icons from the explorer.exe file. As you can see, none of the available icons are very exciting. However, if you click the Browse button, you can search for other files that contain icons.

Once your custom Start button appears on the taskbar, drag it all the way to the left side of the taskbar. So here you are with what you want to have. So go on and enjoy “Windowing”!

Tired of entering passwords again and again. See how you can remove passwords from Windows 8 to log in to your computer without unnecessary passwords.

Continue Reading

Tips

How to Speed up the Start up Process for Windows 7?

Published

on

Registry-edit-windows-7

Microsoft Windows is undoubtedly the most popular ever operating system for desktop PCs. Though new Windows 8 is out since a year or so, there are plenty of people who still use Windows 7 OS. Electronics, Computing, Communication and Information technology are the fields that change rapidly over the span of time. User has just adjusted to a system and he/she will have a new update in the same segment. There are two aspects to this phenomenon and requires another post to give justice.  If you are one of those users who still have Windows 7, you may have noted a fact that it takes a bit long to start up. Sometime it may irritate you. But nothing to worry, here we are once again to help you with proven tricks along with screenshots.

I personally believe that Windows is a system that has plenty of hidden features may be due to the reason that Microsoft provides higher privilege to their users as compared to other Operating system developers.  So using those hidden tricks here we are with a tutorial How to Speed up the Start up process for windows 7? Tired of using Windows 7? Upgrade Windows 7 to Windows 8 using the Dual-boot method.

Procedure:

Caution:

If you are editing registry don’t mistype anything, otherwise, it may cost you in form of crashed window. So perform this operation with optimum concentration and confidence too!

Steps:

Find run option in your windows. If you can’t find it try this… Windows key + R

After that you will find a box titled Run, and space with a writing curser

Run-Windows-7

Type “Regedit” or “Regedit.exe”

Click Ok or Press Enter

A window titled User Account Control (UAC) will appear. Click yes on this window.

Now you will find a registry window.

Registry-edit-windows-7

  • On the left side of the Window, locate the key “HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSessionManagerMemoryManagement PrefetchParameters.”
  • In the right pane, double-click EnablePrefetcher.
  • Change the value to 2 and click Ok.
  • In the right pane, double-click EnableSuperfetch,
  • Change the value to 2 and click Ok.
  • After done with all these settings close the Registry.
  • Restart your system in order to configure the changes.

So here you are with your Windows 7 which really start up faster. Feel free to suggest us or review our tutorial. We are open enough to criticism also. If you don’t know how to boot the computer in Safe mode, you should see that.

Continue Reading

OS

How to use BitLocker to Encrypt your Files

Published

on

How-to-use-BitLocker-to-Encrypt-your-Files

Locker means a safe place where you can put your personal or important things hiding from others. We all have some things which we don’t want to share with others same as in the computer you have any important data that you want to hide from the outside world. For that, there are many software available over the web and as well as well-known by you so no need to describe it.

But if you want to lock your Hard Drive partitions without any software then? In that case, Microsoft has provided one wonderful tool known as “BitLocker” in Windows Vista, 7 and 8 for encrypting your entire Hard Drive partitions. Using BitLocker you can lock any volume on the computer even the one you boot from. But a question arises in your mind that How to use it, right? So, I will show you two different modes to use BitLocker on your computer. If you wanted to Defrag the Hard Drive, you should see that.

1. “How to use BitLocker on a normal/data volume”

2. “How to use BitLocker on Boot volume”

Let’s see the first mode:

1. How to use BitLocker on a normal/data volume?

A simple way to enable BitLocker – right click on any volume and select “Turn BitLocker on” to start the locking process. After clicking a window will pop-up (as shown in the figure below) asking to enter a password to use with the drive – you will also ask to say a copy of the recovery key somewhere at safe place and then it will begin encrypting your drive.

How-to-use-BitLocker-to-Encrypt-your-Files

By this method you can lock all the drives on your computer except “C:/ drive” or “Boot partition”.

Now, the second mode:

2. How to use BitLocker on Boot volume

Yes, it is true that you can encrypt the main operating system drive, but this has some special requirements since the drive has to be unlocked before boot. First of all this requires that Windows has a seperate boot partition that isn’t encrypted; in case if you don’t have then create a separate boot partition. The second requirement is that your system include a TPM (Trusted Platform Module).

If you try to encrypt your boot volume without satisfying the above to requirement then it will give an error as shown in the figure below.

How-to-use-BitLocker-to-Encrypt-your-Files

So, in that case you will need to configure your system to use BitLocker with a TPM. Here is how you can do that.

  • Press [win + r] and type “gpedit.msc” in it and press enter to launch the Local Group Policy Editor

How-to-use-BitLocker-to-Encrypt-your-Files

  • Now, browse to – “Computer Configuration > Administrator Templates > Windows Components > BitLocker Frive Encryption > Operating System Drives
  • In the right panel. double click the setting “Require additional authentication at startup” and select “Enabled”
  • In that please check the below options that “Allow BitLocker without a compatible TPM…” is checked.

How-to-use-BitLocker-to-Encrypt-your-Files

  • Then, Click Ok – you are done.

Now you will able to start the BitLocker process on your system drive, and will have the option to either enter a password on startup or insert a USB drive to boot.

If you have any problem regarding “BitLocker” then put your comments below so that I can surely help you to get rid out of your problem. Hope this guide helped you to understand how to use BitLocker.

PC taking more startup time? Change the Startup program to boost the startup process in windows 7.

Continue Reading

Tech

How To Turn Off Google Voice Search?

Published

on

By

How-To-Turn-Off-Google-Voice-Search

It’s been a while Google became a phenomenal internet giant. Every netizen makes use of at least one service of Google. I know the search engine comes at first in the list.

There is an amazingly useful feature integrated with the search engine and Google app that’s voice search. I have just started using it regularly for a couple of days. I found it’s worth it when I have to get a quick answer (like for the question ‘who was the 11th PM of India’).

But you may be a person who doesn’t like to use Google voice search. So today I am going to share a way using which you can turn off Google voice search.

See Also: How to Use Google Voice Commands

How to Turn Off Google Voice Search?

Sometimes, you may find this feature unwanted. I have seen some forum posts that said some guys are facing accidental Google Voice launch without even doing it. In such a scenario you have no options left other than to turn off the feature.

I broke down this tutorial into two parts. The first section deals with turning off voice search on Android app while the second one on Google Chrome desktop browser. To be frank, you have no options to turn off Google voice search.

What can be done is, turning off OK Google hot word.

Disable OK Google Hot Word on Android

To disable Google Voice search on Android without removing the Google app, it is recommended to turn off OK Google hot word. Read on further to know how to disable Google Voice.

Step 1: Grab your Android phone and open the Google app. You can find the app among another app. If you have the Google voice search option and can’t find the app, you should consult with an ophthalmologist ;).

How-To-Turn-Off-Google-Voice-Search

Step 2: You can see the app window like the image given below. Tap the three stripes button on the top left portion of the screen. You will get the Google menu.

How-To-Turn-Off-Google-Voice-Search

Select Settings from there.

How-To-Turn-Off-Google-Voice-Search

Step 3: At this stage, you will be provided with half a dozen of options. Touch on Voice from there. It is the menu we have to access to make a change in any of the Google voice search settings.

How-To-Turn-Off-Google-Voice-Search

Step 4: There, you can see the second option that says “OK Google” detection. Tap on the same.

How-To-Turn-Off-Google-Voice-Search

Step 5: Look at the first two options, From the Google app and From any screen. If you need the Voice search option only when the Google app is opened, you can turn the first option on. Or your preference is launching Google voice search on any screen with the hot word, choose the second one.

How-To-Turn-Off-Google-Voice-Search

If you are in search of how to remove Google voice, you can turn off both the options.

Alternative way

Are you the one who never uses Google app? Then, you can bravely go on with this process. Here, what we are going to do is, disabling the Google app completely.

Proceed to the steps given below to understand how to disable Google voice search with the complete removal of the app.

See Also: How to Do a Google Reverse Image Search on Phone?

Step 1: Go to Settings on your Android phone. As you already know, this is the toolbox of an Android user to alter the visible configurations of the phone.

Step 2: Scroll down to bottom until you see the Apps menu. Then touch on the same to get a list of Applications.

How-To-Turn-Off-Google-Voice-Search

Step 3: Look for the one, which says Google App. On touching the same, you will get three options on top. Tap on the third one (Disable) to remove the app completely.

How-To-Turn-Off-Google-Voice-Search

Step 4: You may be asked to confirm the selection by choosing OK. Do it and proceed with the process.

How-To-Turn-Off-Google-Voice-Search

That’s all. You have successfully disabled Google app. So, the voice search ghost will never conquer your phone ever.

If you want to sustain the app, choose the first process I have explained and disable the OK Google hot word.

How to Disable OK Google Hot Word on Chrome Browser

See Also: How to Make a Google Doc?

If you face the voice search issues on Chrome browser, you can disable the feature. It is very annoying to see the voice search gets often opened while we browse seriously. But remember, Google voice search is an amazing feature that lets you search the web and find answers for your questions without using keyboard, mouse or the touch screen of your smartphone.

Follow the steps given below to know how you can turn off voice Google search.

Step 1: Open the Google Chrome browser on your computer or laptop. You can get the Chrome menu by clicking on the three stripes button on the top- right corner.

Step 2: A number of options will be displayed. But for every action that modifies Chrome settings, you have to access Settings from the Chrome menu.

Step 3: You will see a screen like the image given below. Click Show Advanced Settings to get more options within the page.

Step 4: You can see a heading, Search under which a checkbox is displayed saying “Enable OK Google to Start Voice Search”. If this option is turned on, uncheck without any hesitation.

That’s all. You have turned off the OK Google hot word that often disturbs you by opening Google voice search. I think you got a clear idea about how to deactivate voice Google search.

Wrapping Up

I have come up with this post after seeing many queries on how to disable Google voice search on Google’s support page. Someone said that he took about a couple of hours to find the solution for accidental opening of voice search.

If you are a person, who is irritated with this unwanted opening of Google voice search, I hope this post can help you the best. Use the comment section down below in case you encounter with any problem or doubt regarding this article.

Share this post with your friends and make us reach more eyeballs.

That’s all for now. And, wait for the next post to reduce your headache by overcoming another haunting tech problem.

Continue Reading

Tech

How To Download Safari for Windows?

Published

on

By

download-safari-for-windows

We know many web browsers. Google Chrome, Mozilla Firefox, Opera, Internet Explorer and finally Microsoft Edge. Then, what on the earth this Safari can do??

Every browser has something unique to it. Even the IE has its own benefit. And you know what? Still many people prefer Internet Explorer over other browsers.

Likewise, there are tens of thousands of people using Safari over other browsers. Why they do this??

I will give you some of the incredible features of Safari at the end of this article.

So, now let me tell you how to download Safari for Windows.

How to Download Safari for Windows?

See Also: How to Turn on Bluetooth in Windows 10

As we all know, Safari is an Apple product. Apple is very protective of their product. That is the case of Safari too. No official methods are available to download Safari for Windows.

Here, I am sharing some unofficial ways to get Safari to your Windows computer.

Method 1: Use Filehippo

Filehippo is a freeware sharing website. You can download tons of freeware and demo software from Filehippo.

#1. Click here to visit Filehippo (or, enter filehippo.com into the address bar of the browser).

download-safari-for-windows

#2. On the top right portion, you can see a search field. Just type Safari for Windows in it. And, hit Enter or click on the magnifying lens icon to the right of the field.

download-safari-for-windows

#3. You will get a list of results. As you can clearly see in the image, Safari is shown as the second result. Click on it.

download-safari-for-windows

#4. On the next page, a greenish download button will be provided indicating the file size. Click there.

download-safari-for-windows

#5. You will see a page like the above image (see background). After a few moments, the file will be started downloading. (I am using Internet Download Manager. That’s why I got an additional dialogue box).

download-safari-for-windows

#6. The download process will take some time according to your internet speed. When the downloading gets completed, open the set- up file (the one you have just installed) and proceed with the installation.

Hey, congrats. Mission accomplished. You can now use Safari on your Windows machine now.

download-safari-for-windows

Method 2: Use Softpedia

Softpedia is a similar to Filehippo. It is also used to download free Windows, Mac, and Linux Software.

Step 1: Click here to visit Softpedia.

download-safari-for-windows

Step 2: On the homepage, you can see a search form just below the logo and navigation bar. Click on it and enter Safari for Windows. Then, press enter.

download-safari-for-windows

Step 3: I got Safari as the first result (check image). Click on Safari.

download-safari-for-windows

Step 4: Click on Download Now from the upcoming page.

download-safari-for-windows

Step 5: You will be asked to choose a mirror. Here, I got only one mirror. If you too get the same, click on it.

Step 6: The download process will be started in seconds. When the task is completed, proceed with the installation.

That’s all. Now you know how to download Safari for Windows.

Features of Safari Browser

See Also: How to Speed Up Windows 7 Performance

Safari web browser was first released in 2003 with Panther version of Mac OS X. Since then, Safari is the default web browser in Mac.

A mobile version is also available for iOS devices. I already told you that no official downloading methods are available for Windows version of Safari.

Then, what you get from Filehippo and Softpedia are illegal??

Not at all. Apple made Safari for Windows in 2007, and it was available on the official site until 2012. Then, Apple decided to discontinue the Windows version.

The following are some of the remarkable features of Safari web browser.

#1. Elegant User Interface

The UI of Apple products allures everyone. Safari web browser is not an exception. Its minimal interface helps you focus on the web content rather than on the browser itself.

#2. Easy Bookmarks

We all know the use of bookmarks. The greater the number of bookmarks, the clumsier bookmarks menu becomes. But Safari makes it easy and organized.

#3. Snapback Button

Every one of us makes use of search bar in browsers. What if you want to land on the search results page by a single click even though you are pages away from it? Snapback button on Safari helps you to do the same.

#4. Resizable Text Fields

Not every website allows you to resize the text fields. But if you use Safari, you can resize any text area even though the site does not permit it.

Wrapping Up

I have provided you two easy ways to download Safari for Windows. It’s so easy that a primary school student can do this.

I hope you have grabbed something helpful from this article. Share it with your peeps so that this would benefit to them too.

Chances are less for you to have any doubt regarding the Safari download for Windows. In case of an issue, the comment section is waiting for you. Let’s talk there.

Continue Reading

Trending