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 *

Computers

How to Use the Undo and Redo Commands?

Published

on

I cannot even recount that how many times the undo and redo shortcuts have saved my life. These are one hell of a gem and have been a life savior, at least for me. Since you have landed here then you might be interested to know how to use the undo and redo commands, right.

So, this article will tell you how to use the undo and redo commands along with step by step guide.

So, without wasting any time further, let’s dive deep into this and explore. So, let’s get started:

 

How to undo and redo?

 

 

Okay, you want to take a step back or two, you can easily do that using an undo command. But the key point to take a note is that this is entirely controlled by the software on which you are trying to apply the undo commands. Some of them allow multiple undo’s while some of them allow a single one. For example, MS paint allows a single undo while in Adobe Illustrator you can perform multiple undo operations.

So, in this section,  we will see how to undo and redo in some of the major softwares.

We will first go to MS office. How to undo and redo in MS office? So, let’s get started:

Step #1: First of all, you are required to open MS Word on your system. We are taking MS Word for illustration purposes; you can go with any of its products. Once you have opened MS Word, then you now need to move on to the next steps for further proceedings.

Step #2: Perform any action to an existing Word document or a blank document. After that, if you wish to undo your operation then press “CTRL + z.” This will revert your changes.

Additionally, if you want to redo an action then you are required to press “CTRL + y.” This way you can quickly perform the redo operation in Word.

Alternatively, in previous versions of MS Office, you may find the edit option from which you can also perform the same task by clicking on the undo and redo options.

Let’s see how it can be done in MS paint.

Step #1: First of all, you will have to launch MS Paint on your system. Once you have done that, open the desired image file, or you can even create something of your own.

Step #2: Oh, you made a mistake and wanted to undo the action. Press “CTRL + Z” to get back a step back. If you want the redo the step then just press “CTRL + Y” to get the needful results.

Moving on, we will see how to redo and undo in Adobe Photoshop. So, let’s get started:

Step #1: Open Adobe Photoshop on your system. Once launched, you are now required to open any existing project on which you want to perform these actions.

Step #2: Now, if you want to undo or redo your steps, you have two options, either you can go with the usual “CTRL + Z” keyboard shortcut which will get you exactly one step back, or you can go to edit option and then select the appropriate option from there.

Alternatively, to undo your steps, you can also go to the history section of Photoshop from where you can also see what steps you have gone through till now. To go to history, you need to click on the Window option from the top navigation menu and the locate the history option. Once found, you need to click on it. This may open a history panel from the right side from where you have a look at your steps.

Now, if you wish you can select the desired steps that you want to undo and then delete them by clicking on the dustbin like icon as shown. This will produce the same output as the undo command, but the difference is that you can revert as many steps as available.

To say the least, CTRL + Z and CTRL + Y are the undo and redo global actions for any Windows program. So, what if we want to perform the redo and undo operations on a Mac? If you are thinking about the same, then the following section is a must visit for you.

In Mac operating system, the alternative for CTRL + Z is “Command + Z” and for the redo operation the alternative is “Command + Shift + Z.” The Command key in Mac is equivalent to the CTRL command in Windows.

Also take a note that not every action your perform can be redone and undone. So, if these keys don’t work in some cases, then you might have performed those actions.

 

[Additional Information]: Some useful keyboard shortcuts.

  • CTRL + SHIFT+ESC: Opens Windows Task Manager
  • ALT + TAB: Switch to another running program
  • ALT + SPACE: Displays the foreground window’s system menu.
  • ALT + F4: Closes the current window
  • SHIFT+DELETE: Delete item permanently without placing it into the recycle bin
  • Windows Logo + L: Lock the computer
  • Windows Logo + R: Open the Run dialog box
  • CTRL + F: Finds for terms in a Window
  • Windows Logo + M: Minimizes all open Windows
  • Shift + Windows Logo + M: Undo the Minimize all (opposite of Windows Logo + M)
  • Windows Logo + D: Display desktop by minimizing all open Windows
  • Windows Logo + TAB: Cycles through running programs (Function similar to Alt + Tab)
  • CTRL + ALT + DEL: Referred to as “Three finger salute” often used to interrupt a function. It provides a bunch of options like task manager, log off and others.

So, this was all about how to undo/redo edits? We hope that this article must have added unique value to your knowledge base.

If this article has helped you in any manner, then do let us know through the comments section. If you have any suggestions or remarks, then those are also cordially welcomed. Also, do not forget to like us on our various social media channels.

Stay tuned for more of such articles.

Keep visiting for more. Thank you for passing by.

Continue Reading

Tech

How to Speed Up Windows 7 Performance

Published

on

No matter how fast your new computers might be, they all seem to get slower over time. Because, there is a new kind of excitement to play with new computer and to install lots of software’s on it. The first program which we install on our new computers is anti-spyware and antivirus tools, to stay from viruses. I know, it’s an essential program but what we actually do, we install more than one antivirus program. Next, we download lots of unrecognized junk softwares from the internet. Obviously, your new computers gradually decrease the performance and one day when you are trying to open a program or file then it takes more time to open up.

So, Whatever the cause, there are lots of ways to speed up Windows 7 performance and make your PC work better without upgrading your hardware. Here are something that will help you in installing Windows 7 custom themes.

Tips to Speed Up Windows 7 Performance

Turn Transparency Off

The glass transparency uses more resources of a PC from the Aero feature, you can disable by following simple steps.

Step 1: Go to personalize. (Right Click on desktop > Personalize)

How-to-Speed-Up-Windows-7-Performance

Step 2: Click on the Window Color icon at the bottom of window.

How-to-Speed-Up-Windows-7-Performance

Step 3: Uncheck the box to disable transparency.

How-to-Speed-Up-Windows-7-Performance

Step 4: Click on save changes.

This will save some resources from being utilized and Speed Up Windows 7 Performance.

Turn on only required Visual Effects

You have to turn on only those visual effects that are essential and required by you. You can optimize how menus and windows appear by following simple steps.

Step 1: Open My Computer > Click on System Properties >Click on Advanced system settings (left hand side).

How-to-Speed-Up-Windows-7-Performance

Step 2: A small window will open up and from there go to the advanced tab and click on settings (performance).

How-to-Speed-Up-Windows-7-Performance

Step 3: Now here you can go for any of one option.

Option 1: Click on checkboxes as shown in the image below.

How-to-Speed-Up-Windows-7-Performance

Option 2: Select (dot) “Let Windows choose what’s best for my computer

How-to-Speed-Up-Windows-7-Performance

Step 4: Click on Apply.

Enable Writing Cache for Storage Devices

This option will tweak your storage devices such as internal disks or removal drive to give the highest possible performance, to enable just you need to follow the below simple steps.

Step 1: Open Device Manager (Right Click on icon My Computer > Click on Manage)

Step 2: In Device Manager, click on disk drives to expand the attached drives to your computer. Here I have two drives, one is the internal hard disk and second is pendrive.

How-to-Speed-Up-Windows-7-Performance

Step 3: Firstly, double-click on internal hard disk > Click on Policies tab > Check Enable writing cache on the device > Click Ok

How-to-Speed-Up-Windows-7-Performance

Step 4: Now, click on another drive (pendrive) > Click on Policies tab > Select (dot) Better Performance > Click Ok

How-to-Speed-Up-Windows-7-Performance

This will surely optimize the usage of cache memory and Speed Up Windows 7 Performance.

Turn off unnecessary Windows Features

Windows 7 comes with lots of features and we all know that we are not using all the features of it so it also allows us to turn on or off Windows features as per our requirement. That will also speed up the startup process for windows 7. For that,  just follow the below simple steps.

Step 1: Open the Start Menu, type Windows Features in the search box, and press Enter.

How-to-Speed-Up-Windows-7-Performance

Step 2: Open up “Turn Windows Features On or Off” icon. In that, if you want to turn on any features then tick the check box otherwise untick the check box to disable the features.

How-to-Speed-Up-Windows-7-Performance

Step 3: After turning on or off, you will have to restart your PC. That’s it.

Helps in reducing unnecessary usage of CPU and Speed Up Windows 7 Performance.

Disable GUI Boot

Disabling GUI boot literally reduces the startup time of Windows 7. Follow the simple steps to Increase Startup Speed Windows 7.

Step 1: Open Command Prompt (Win Key + R) > type “msconfig” > Enter.

Step 2: Click on the boot tab > Select your OS (Ex: I nave Windows 7). Then, below you will see many options from that check the box of “No GUI boot” and “Make all boot settings permanent” > Click Ok. I will ask for confirmation click yes and restart.

How-to-Speed-Up-Windows-7-Performance

So, all these are the important tips to Speed Up Windows 7 Performance. If you have any problem or query regarding this then you can surely put your comments below and we will connect with you as soon as possible! Happy Tweaking 😀

Continue Reading

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

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

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

Trending