Web
Analytics
Connect with us

Tech

How to Find the Average in Excel?

Published

on

As soon as we hear the term “statistics”, the first thing that strikes to most of the individuals is mean, median and mode. The mean, which is often called the average, is the measure of central tendency that most people are familiar with. How to find the average is, basically the easiest out of all the measures of central tendency.

In conversational language, an average is the sum of a list of numbers divided by the number of numbers that are imbibed in that particular list. In mathematics and statistics, this would be called the arithmetic mean.

Let’s have a look at how do you find the average:

Calculation of Mean

As discussed above, the mean is the sum of the value of each observation in a dataset divided by the number of observations. This is also known as the arithmetic average. In simple words, the sum is divided by the count. Also, learn to divide in Excel.

Example 1: Let’s have a look at the distribution:

3, 7, 5, 13, 20, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29

The sum of these numbers is 330

There are fifteen numbers.

The mean is equal to 330 / 15 = 22

Thus, the mean of the above numbers is 22.

Example 2: Let’s have a look at the distribution:

9 13 9 11 9 13 11 9 10 8 11

The mean for this example is:

9+ 13+ 9+ 11+ 9+ 13+ 11+ 9+ 10+ 8+ 11= 113

There are 11 numbers.

The mean is equal to 113/11= 10.27

You can write a mean as a decimal number or round to a whole number. Thus, the mean is 11.

Example 3: Let’s have a look at how to handle negative numbers:

3, −7, 5, 15, −6

The sum of these numbers is 3 − 7 + 5 + 15 − 6 = 10

There are 5 numbers.

The mean is equal to 10 ÷ 5 = 2

Thus, the mean of the above numbers is 2.

Options for Entering the Function

Basically, there are three options for entering the functions in Excel. These are:

  1. You need to type the complete function =AVERAGE(C1:C4) into a worksheet cell.
  2. You can simply, enter the function and arguments using the function's dialog box.
  3. Use Excel’s Auto Average feature in order to enter the function and arguments.
    how-to-calculate-average

Now let’s study each of them in detail-

How to Find the Average in Excel

Microsoft Excel is an ideal program to perform any numerical analysis such as computing the mean, median, mode and range for a set of numbers. Expect for calculating range, the Excel has a built-in function of how to calculate average. Let’s have a look at the steps:

  1. Open your spreadsheet in Microsoft Excel.
  2. Now, choose the cells you want to average.
  3. Make a note of their cell references, using the format A1 or a range of A1:A5. Press “Enter” to complete the formula and the mean of your numbers will appear in the cell.
  4. Enter “=AVERAGE (range)” in an empty cell and replace “range” with the cells you wish to average.
  5. Example- To average, the cells A1 through A5, enter “=AVERAGE(A1:A5)”
    How-to-find-the-average
  6. The non- consecutive cells can be separated by including a comma. Example- “=AVERAGE(A1:A6,A9,D3)”

How-to-find-the-average

Function Dialog Box

Now, let’s have a look as to how the function dialog box operates, via following the enlisted steps:

  1. Click on the cell, i.e. the location where the function results are displayed. Let’s say it is cell C9 in this case.
  2. Click on the Formulas tab of the ribbon.
  3. Choose More Functions > Statistical from the ribbon to open the function drop down list and click on AVERAGE in the list to bring up the function's dialog box
    How-to-find-the-average
  4. Highlight the cells C1 to C8 to enter the range into the dialog box and click OK to close the dialog box and return to the worksheet.
    how-to-calculate-average
  5. When you click on cell C9 the complete function =AVERAGE(C1:C8) appears in the formula bar above the worksheet.
    how-to-calculate-average

How to Calculate Weighted Average Mean

Usually, when the average is calculated, we put same weight or priority to each value, this is called un-weighted average. If you have really big data for addition, you should take a look at adding numbers in excel.

When weight is also taken into consideration while finding the average, it is known as weighted average. To find the weighted mean:

  1. Multiply the numbers in your data set by the weights.
  2. Add the numbers up.

Example- Let’s say you assign equal weights to your data set of 5 numbers. Thus, the weighted mean would be:
1(*1/5) + 3(*1/5) + 5(*1/5) + 7(*1/5) + 10(*1/5) = 5.2

Note- In case, you have very high or very low values in your data set, the weighted mean may not be a good statistic to rely on.

How to Calculate Weighted Average Mean in Excel

First of all, for how to find an average, you need to have knowledge of Excel SUMPRODUCT function. SUMPRODUCT is simply, multiplying each number with its weight and then adding all of the products together.

The formula is:

= SUMPRODUCT(<Range containing all the Elements>, <Range containing weight of all the Elements >)/ SUM(<Range containing weight of all the Elements >)

Follow the following process for the same in Excel:

  1. Set up the spreadsheet and enter the formula in any empty cell.
  2. Start the formula with an = sign.
  3. Type SUMPRODUCT with an open parenthesis, like this =SUMPRODUCT(How-to-find-the-average
  4. Add arguments to the function. Usually it has two arguments and separate the arguments with a comma. Let’s assume our two arguments are contained in these cells:

=SUMPRODUCT (B4:B9, C4:C9)
How-to-find-the-average

  1. Now, divide SUMPRODUCT by the SUM of the weights. Start by typing a / (forward slash) for division, and then type the SUM function:

=SUMPRODUCT(B2:B9, C2:C9)/SUM(
How-to-find-the-average

  1. Now, in order to close the parentheses you need one argument only. Let’s say we have C4: C9

=SUMPRODUCT(B4:B9, C4:C9)/SUM(C2:C9)
How-to-find-the-average

  1. To finish, just press Enter on your keyboard.

Blank Cells

Always remember that there is a difference between blank or empty cells and those containing a zero value. The blank cells are ignored by the AVERAGE function but not those containing a zero value.

Sometimes by default, Excel displays a zero in cells with a zero value. So turn off this option in order to avoid errors and inconvenience. Once this option is turned off, such cells are left blank, but are still included in average calculations.

Computing the numbers on excel is easy but to make it the numbers presentable, you may need some graphics. Here is how you can create bar graphs in excel to make the data presentable and understandable.

Conclusion

Working on Excel may seem tough in the beginning, but once you are eloquent about it, the work becomes comparatively simpler and easier. How to find the average is a function most widely used by professionals while making reports or during calculations.

So go ahead, and calculate the averages in a simplified way!

A zealot author, a story teller and a Philocalist who loves to write on various topics trending on social media. She's a work in progress and a budding visual artist.

Continue Reading
Click to comment

Leave a Reply

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

iOS

How to Setup Apple Pay on iPhone?

Published

on

Apple pay is Apple's mobile payment service. In simpler words with Apple Pay, you can make payments via iPhone 6 or iPhone 6 Plus and all the latest versions.

Apple Watch owners can make payments using NFC chip built into their devices. It made its debut on 20 October 2014.

Since the day it has been launched, it has been growing at a spectacular rate. The ease and convenience that it offers are simply unmatchable.

And with all this hype around this amazing feature, a lot of iPhone users have been going gaga about how to use apple pay.

With Apple Pay, it has become much easier for you to pay for your purchases, both physical and online. All you have to do is pay for all those goods and services you have bought from the retail stores or the apparel you shopped from your favorite clothing store via your Apple iPhone.

With Apple Pay, the security of the card is given the main preference. Apple creates a “device-only account number” to operate Apple Pay. It doesn’t store your credit or debit card number and does not even give the number to companies or traders. It is known as Tokenization.

Apple Pay is presently only available in the US, UK,  China, Australia, Canada, Switzerland, France, Hong Kong, Russia, Singapore, Japan, New Zealand, and Spain. However, they are expanding and soon it will be available in other countries as well.

Let’s take a deeper look at what Apple Pay is all about and How to Setup Apple Pay on iPhone:

Setting up Apple Pay on iPhone

For all those purchases through Apple Pay, all you have to do is Set up Apple Pay on your iPhone. Once done, with just a touch of the Home button and a scan of your fingerprint, all your purchases can be made.

Before we proceed with the method, make sure to comply with the following needs in advance:

  1. You should have an iCloud account.
  2. Your iPhone needs to be running iOS 8.3 or above.
  3. You need to have a credit or debit card from any bank that supports Apple Pay. However, Apple Pay currently works with Visa, MasterCard, and American Express.
  4. A Touch ID is compulsory. So make sure your fingerprint is registered with the Touch ID feature. Even though the iPhone 5S has Touch ID, it doesn’t support Apple Pay.
  5. You should have iPhone 6 or iPhone 6 Plus. However, for in-app purchases, iPad Air 2 or iPad mini 3 can work. Apple Pay also works with Apple Watch. Basically, all those devices which contain NFC Controller support Apple Pay.

How to Setup Apple Pay on iPhone by Adding Card

Now, you need to synchronize your debit or credit card with Apple Pay to initiate purchases via Apple Pay. Take a look at the steps:

  1. Tap on the Wallet app from your Home screen.
  2. On the extreme right- hand corner, you can see a + button, tap on it.
  3. The Apple Pay screen will open up. Click on the Next button in the top right corner of your screen.
  4. Here, you can either manually input your card details or take a photo of the front of the card, i.e. scan your card details.
  5. After this, click on Next on the Card Details screen.
  6. You need to manually enter your card information. It will ask for your card's expiration date and the security code. To proceed further, click Next.
  7. You can view all the terms and conditions and tap Agree to accept the terms and conditions.
  8. Tap Agree again for final confirmation.
  9. Select your verification method, i.e. either via an email, text, or call and tap next to continue.
  10. Click on the Enter Code and now enter the verification code that has been sent to you. Click on Next.
  11. Every bank has a different procedure when it comes to the authorization of the added card. In case your bank or issuer asks for more information, you need to provide the same.
  12. As soon as your bank verifies your card, Apple Pay will start functioning. Tap Done to finish.

You can add up to eight cards on any device. Follow the same process to add more cards. So, next time you shop, just hold your iPhone near a contactless reader with your finger on Touch ID.

The wallet will be launched automatically. Your fingerprint and a small beep or vibration will confirm that you made the payment correctly.

Note- In case you experience any hindrance while adding your card, the only solution is to re-enter all the information again.

Removing a Card

It may happen that due to certain reasons you would like to remove your card. Removing a credit or debit card is comparatively simpler than adding it. Take a look at the steps:

  1. Launch the Wallet app from your Home Screen.
  2. Select the credit card that you want to delete.
  3. Scroll down to the option “Remove Card” and tap on it.

And you are done! The card will no longer be available or authorized to be used with Apple Pay on your iPhone. However, if the same card is synced with other Apple devices, you need to remove them manually on each of them.

Conclusion

Precisely speaking, Apple Pay is more or less like Paytm. Though, it may seem to be a difficult process initially, but is a venture that is completely worth it. Apple Pay anyway is more secure and convenient than a traditional card-based transaction.

Usually what you do is while making a payment by card, swipe your card, then wait for few seconds to receive authorization and when the transaction gets cleared, the shopkeeper hands over the receipt and you walk out of the store with the stuff bought.

But in actual, if we look at the backend management before your receipt gets printed, the things aren’t that straightforward.

Apple pay simplifies this task on both the entities, i.e. consumer and the company. Moreover, Apple Pay helps to reduce the associated costs to the issuing bank.

No more digging through the wallet to find credit or debit cards. With How to Setup Apple Pay on iPhone, just install Apple Pay and enjoy shopping like never before!

Continue Reading

Android

How to Unlock a Locked Phone?

Published

on

By

How to Unlock a Locked Phone

Do you want to know how to unlock a phone?

I am not talking about the password, pattern or fingerprint lock on your device. But the lock comes with the device itself called carrier lock.

If you bought a phone exclusively from a telecom operator for a low price, you would know what I am talking about.

In this article, I want to give you complete information on how to unlock a locked phone.

I hope you are ready to get deep into the article now. So, here you go!

How to Unlock a Locked Phone?

Comparing with the pattern or PIN lock, unlocking a carrier lock will need more effort and time for you. And the procedures are different for different carriers as well.

What does an Unlocked Phone Means?

Maybe you are new to this whole locked phone stuff. So let me explain it to you.

Some operators sell expensive phones like iPhones for a cheap price in return for a contract that lasts for a particular period say two years. That means you need to use their telecom service for the next two years after you buy the device from them.

Once you set out to remove their SIM card and try to insert another from the separate network operator, it won’t work until the set contract period gets finished. The fact is that a particular unit contains a secret software code, which is responsible for the lock.

The manufacturer itself does the code integration into the unit upon the request of the network carrier. You can’t do much about it at once.

So, what is an unlocked phone?

A phone with no carrier constraint is called an unlocked phone no matter what it was locked in the past.

Why does a Carrier Lock a Device?

I have already told you the reason. They provide you with an expensive unit for a cheaper price. In return, all they want is you as a customer for a given period. They make up the discount in price for the device from the profit in service.

Is My Phone Unlocked?

You may have a question in your mind now ‘is my phone unlocked?’.

No geeky brain is needed to figure it out. Just pull out the SIM card on your phone and, insert another. If you get signals for the second SIM, you know it is unlocked. In case you don’t, your phone is carrier-locked.

How to Unlock a Phone?

As I said earlier, you need to incorporate different methods to unlock phones from different carriers. You can find how it can be done for a few operators here.

#1. Verizon

According to the company, their 4G LTE devices aren’t locked. So, you don’t need assistance in using other SIM cards on such phones.

what does an unlocked phone mean

They don’t have an online unlock request receiving system. But you can place a request via 1-800-711-8300.

Though most of the 3G devices of Verizon aren’t locked, you will have to enter either 000000 or 123456. Until you do the same, third-party operator compatibility will remain a mirage.

For the special world devices, technical support is needed for the process of unlocking. You can seek help from (800) 922-0204 also.

#2. AT&T

Unlike the previous operator, AT&T offers an online request receiving system.

how to unlock a locked phone

But you must be sure about the following things before you place a request for unlocking the device.

  • The device should be from At&T
  • You must be their subscriber
  • The device should have been active for the last two months
  • You don’t have an unpaid balance or due
  • The device shouldn’t be reported stolen or lost
  • Make sure you made less than five requests last year.

Once you come to the terms, you can fill this form out to place a request. Generally, it would take up to five business days to complete the process.

Even though they don’t provide unlock-over-the-phone service, you can seek their assistance via 1-800-331-0500. If you have a prepaid connection, the period of activity is the whole year.

#3. Sprint

When it comes to unlocking a phone from Sprint, you must follow all the bullet-point guidelines beneath the previous subhead, but with a couple of slight differences. The period of activity is 50 days and the maximum requests per year are two on contrary to two months and five requests of AT&T.

Sprint phones manufactured before 2015 can’t be unlocked according to the company. But those after that year aren’t impossible to unlock. You need to call talk with their customer care executive either via phone ((888) 211-4727) or online chat.

what is an unlocked phone

If you are a person who is about to go abroad and wants to get the phone unlocked, you are eligible to request a short-term unlocking provided you meet the guidelines. First, you need to sign in to your account, then follow My account>> Manage this device>> Unlock device to use int’l SIM.

That’s it.

#4. T-Mobile

T-Mobile too wants you to be a good customer who follows a bunch of guidelines. Everything is similar to that of Sprint. But here T-Mobile has an additional instruction that clients who are on a service contract should have made at least 18 monthly payments.

The prepaid phone should be active at least for a year to request for unlocking. And, you should have done $25 (for feature phones) or $100 (for smartphones) refill within that period to be eligible.

how to unlock a phone

Unlike the other three carriers I have shared, T-Mobile has a dedicated unlocking app, which clears the air. In case you prefer customer support, call 611 from your T-Mobile connection.

Wrapping Up

I hope you now know how to unlock a locked phone.

Obviously, there are third-party offline and online services for the same unlocking purposes. If you know of anything legitimate, you are invited to mention the same in the comment section down below.

In case you get confused, don’t forget to let me know about the issue in the comment section down below.

In the meantime, feel free to share this post on social media.

Continue Reading

iOS

How to Turn off Voice Control on your iPhone?

Published

on

Siri is much more than Apple's virtual digital assistant. Not only, it responses to your questions with the best possible information or answers but it even helps to organize your life to a large extent. Then, there’s another side of the coin too.

From failures of understanding to difficulty with accents to annoying interrupting requests, a lot of users get annoyed with Siri. How to turn off voice over is the most frequently asked question by Apple users in such a situation.

The Voice Control framework was initially presented in iOs 3.2 on the iPhone 3GS. With time and new models, it has been superseded by Siri, a more adaptable framework that uses Apple's servers for voice handling, yet Voice Control is still in wide utilize and has its own focal points.

Voice calling seems good if you are the one who calls out a contact from your address book, but then turning off Siri has its own benefits. Apple iPhone users have always complained about the battery life of the iPhone.

So, turning off Siri prevents the battery drainage. Secondly, it prevents unnecessary actions, like sending a text that you didn’t intend to do.

In case you are having problems with the iPhone inadvertently while dialing phone numbers through Voice Control, you can deactivate the Voice Dial feature on iPhone. Let’s take a look at the ways via which you can turn off voice command Siri:

Turn off Siri's Voice to Text Only

Siri speaking can be distracting at times, or it may not always be feasible to speak to Siri. You may be in a formal meeting or at a place where you cannot converse via speaking to Siri.

In that case, resorting to text is the best option available. Take a look at how do you turn off voice control so its text only:

  1. Go to Settings > General > Siri and tap on Voice Feedback.
    How to turn off voice over
  2. In the resulting window, select Handsfree Only.
    How to turn off voice over

Everything remains the same, it’s just that whenever you ask a question, you'll get the same response as always, but only as text and without Siri's voice.

Note- Don’t start the conversation by saying “Hey Siri”, as in that case, Siri will respond by speaking. Rather initiate by double-pressing the Home button.

Disable “Hey Siri”

Apple’s personal digital assistant service, Siri works by voice alone and without the need to touch your device, in case the “Hey Siri” option is enabled.

In the older versions of iOS, all iPhone, and iPad owners can use Hey Siri only when their devices are plugged into a power connection, and those with the latest Apple devices like the iPhone 6s, iPhone 6s plus, etc. can use Hey Siri at any time, even when not plugged in.

Now in case, you are annoyed by Hey Siri requests or for whatever reasons if you want to disable Siri, you can do it via:

  1. Go to Settings > General > Siri.
  2. You will see an option Hey Siri, which is enabled by default.
  3. Just tap on it and turn it off.
    How to turn off voice over
  4. Save the changes and you are done!

Note- For the latest Apple devices like the iPhone 6s, iPhone 6s Plus, turning off Hey Siri disables the voice-only activation of the feature. Now you need to operate Siri manually.

How to Turn off Voice Over

Voiceover is a function and not an app. You can use Voiceover in most of the iOS apps like Safari, Text messaging and email, etc. By default, this option is disabled on your iPhone and iPad. Now in case you have enabled this option and want to disable it now, take a look at the steps to disable voice control:

  1. Go to Settings App.
  2. Choose General.
  3. Tap Accessibility and select Voiceover.
  4. Double-tap the Voiceover slider to turn it off.
    disable voice control

And you are done! However, there is one easier way to do this. Take a look at how to turn off voiceover:

  1. Just simply tap the Home button three times.
  2. You will hear the “Voiceover off” audio message then it will be turned off.

But many people have reported that this method doesn’t work on their iOs. So, in such a case resort to Method 1 and turn off it manually via the Settings app.

Turn off Siri via Settings

There is no denying that Siri is one of the most useful features in the Apple iPhone. But still for whatever reasons, if you want to turn it off, take a look at the process of how to disable voice control:

  1. Open the Settings app on your iPhone and click on “General.”
  2. There you will see an option “Siri.” Tap on it.
  3. Simply turn the switch “OFF.”
  4. A box pops up. Confirm that you want to disable Siri.
    how to disable voice control
  5. And that’s it! You are done.

Disable Voice Control via Passcode

You can deactivate voice control by setting a lock screen passcode and disabling voice dialing. Take a look at the steps on how to turn voice control off:

  1. Tap the “Settings” icon on the iPhone.
  2. Scroll down to the option “Passcode Lock.” Switch on the Passcode Lock.
  3. The passcode screen will appear. Type a four-digit passcode in the Passcode fields.
  4. Now, slide the “Voice Dial” switch to the “Off” position.
    how to disable voice control

Voice Control is now disabled when the phone is locked, and voice dialing is disabled, too. In crux, this will still allow Voice Control to be activated, but will not inadvertently dial any phone numbers.

Conclusion

It completely depends on the usage and preference. While some find the feature of voice control useful, others find this as a hindrance.

Voice Control can be incredible until it begins pocket dialing your contacts while you're strolling. For all those, who find this feature annoying can follow these simple steps listed above on how to turn off voice over.

However, the voice control feature is integrated into the iOs and cannot be disabled in the phone preferences. You can, however, deactivate voice control and enjoy the uninterrupted usage of your iPhone.

Continue Reading

Microsoft Office

How to Set the Default Font in Word?

Published

on

Without any doubt, fonts are one of those elements which can create a spectacular impact on the reader. So, in order to make your document super impactful, you would like to use good fonts in a document.

But how can you set your favorite font as the default one in Microsoft Word? If you are going through this query then this article has all the answers.

So, in this article, we will tell you How to set the default font in Word? After going through this article you will be capable of changing the default font in Microsoft Word. So, let's get started:

How to Set the Default Font in Word?

Step #1: In this very first step of this method, you are first required to open Word application on your system. For that, you can consider going this way. First, go to the start section and type  “Word.” After getting the relevant result, click on that and this will open the Word application for you.

changing the default font in Microsoft word

Now, after this, you are required to open any word document which has some content in it. Alternatively, you can open a blank document and enter some random text on it. Go for whatever suits you best.

Once you have done this then, you are required to look out for our next steps.

Step #2: In this step, you will have to select some part of the text so that we can select the font and then set it as the default one. So, for this, you can place the cursor and drag it till the point you want to select the text.

changing the default font in Microsoft Word

Step #3: After you have selected the text then now you are required to make a click on the “font” icon at the home tab. It looks very similar to a diagonal arrow placed in an inset.

changing the default font in Microsoft Word

Clicking on it will open a dialog box as shown below.

changing the default font in Microsoft word

Step #4: Now, click on the down arrow button at the font field. This will open a list of the available fonts.  Now, you need to select the appropriate font which you want to set as default. You can also see the preview of the font in the font section.

changing the dafault font in Microsoft word

Once you have selected the font and other fields according to your needs, then you are now required to move on to the final step.

Step #5: Now, in this final step all you need to do is to click on “Set as default.” This will open a dialog box that will ask you whether you want to set the default font for the current document only or all other documents as well.

Since you require setting the selected font as the default one so, you need to choose the checkbox next to which “All documents bases on Normal.dotm template” is written.

Just confirm your action and click on OK.

changing the default font in Microsoft word
changing the default font in Microsoft word

This will set the default font in Word. See, how easy it is.

[Additional Information]: How to add fonts in Microsoft Word?

Many times, you would find the pre available fonts in Microsoft word not appropriate for your needs. So, in that case, you would like to install other fonts. If you want to know how you can do that, then you are certainly in the right place.

In this additional section, we will walk you through all the steps that are required to add a font in Microsoft Word.

So, let's get started with the same.

Step #1: First of all, you are required to download the desired font. For this you can make a search on your favorite search engine or visit some good free fonts sites like “dafont.com” or “1001fonts.com”.

How to Set the Default Font in Word

You can visit any of those and download the fonts which suit your requirements. Once you have downloaded the font, then you can indeed proceed with the next steps to look into the proceedings.

Step #2: In the most general cases, the font will be downloaded in zipping or RAR format. So, after downloading the font in step #1, you now need to extract that font.

For this, you should have any good zip or RAR file extractor. WinRAR is one such good software to do the needful. However, if the font comes as a sole otf or ttf file then you can skip this step.

In order to extract the font, all that you need to do is to make a right-click on the downloaded folder and then select “Extract here” or “Extract files”.

The latter one will open a window to which you have to specify the path of where you want to extract the font while the former one will extract the font to the current folder.

We recommend you to extract the font at the current folder and then copy it to the desired folder of which we will be telling you in the next step.

Step #3: After you have extracted the font from its folder then you are now required to copy the font to the following location “C:\Windows\Fonts“. Now, you will have to navigate to this folder and look out for your desired font.

Been there, you now need to double click on that font in order to install it. The font will now be installed once you click on the install button.

How to Set the Default Font in Word

Step #4: Now, you will be able to see the font on your Word application. You can now set it as the default font in Word by using the method provided above (if only you wish).

Wrapping Up.

So, this wrapping up section brings us to the end of this article on “How to Set the Default Font in Word“. We hope that after going through this article, you will be able to know ” How to set and keep your preferred default font in MSC Word“.

If this article has helped you in any manner, then do not forget to share it with your peers. Additionally, if you have any other method, suggestion or query regarding this topic then do let us know through the comments section below. We would love to hear from you.

Thank you for passing by and giving it a read.

Stay tuned and keep visiting.

Continue Reading

Computers

How to Manually Update Drivers in Windows 7?

Published

on

When system peripherals create a problem, the simplest workaround we come to know while troubleshooting those errors is to learn how to manually update drivers in windows 7, and that's what we will be teaching you today!

System drivers are the set of instructions that helps your computer interact with the specific hardware associated with it. If drivers wouldn't be there, your windows wouldn't have any idea on how to deal with those hardware and your computer starts creating the problems.

When the manufacturers tweak the software associated with that particular hardware, the drivers need to get updated to its latest version available. Keeping the windows drivers up to date is a must for flawless and smooth system experiences.

If you have upgraded windows to the latest version, chances are your system audio has stopped working or the audio is not of that quality it used to be. If anything such happens, probably your sound drivers have got outdated and it's an alarm that you need to update it.

Similarly, if windows upgradations, system format or any similar activity has caused you a problem in watching videos, playing games and doing other system tasks, probably it's time for you to upgrade your windows drivers.

If you detect any such issues in your computer, learning How To Update Drivers windows 7 is the only option you are left with. This guide is dedicated to teaching you windows 7 driver updates including how to update graphics driver, driver update software and everything important.

How to Manually Update Drivers in Windows 7

There are more than one way that you can update your system drivers. You can do it by following the system updates, using the manufacturer's software and manually, of course.

This guide is compiled to teaching you how to update drivers manually in windows 7 but we will give you a quick overview of other methods too. Also, all the steps mentioned are applicable in all the above versions of windows including windows 8, 8.1, windows vista and windows 10. So let's get started.

Step 1. The process of updating the drivers starts with the device manager so the first step is to reach out to the device manager window.

To begin the process, click on the start menu and go to Control panel and click the Device Manager. See the screenshot below.

How to Manually Update Drivers in Windows 7

Alternatively, right-click My Computer and select Manage. 

How To Update Drivers windows 7

On doing that, Computer Management windows will open up. Now click Device Manager in the left pane.

How To Update Drivers windows 7

Step 2. In the device manager window, a list of all the hardware attached to your computer is given. See the below screenshot to understand the options.

How To Update Drivers windows 7

To update the driver for any hardware, double-click the hardware option and a hierarchy of the driver option will be loaded. Now double click the driver you want to update.

For instance, we want to update sound drivers for this system. Double-click the Sound, video, and game controllers and the list of audio drivers in your windows will load. Now double click driver option you want to update and another properties window for that driver will pop-up.

Have a look at the below screenshot to understand the options.

how to update graphics driver

Step 3. Now go to the Driver tab and click the Update Driver button in order to update the drivers.  

 windows 7 driver updates

Step 4. On doing that, the Update Driver Software window will pop-up. The window looks like the below screen.

 windows 7 driver updates

Alternatively, you can also reach out to this window by right-clicking the driver option and selecting Update Driver Software. 

intel graphics driver update

Step 5. In the Update Driver Software window, select the second option i.e. “Browse my computer for driver software” if you have the latest driver file downloaded on your computer.

Else, select the option Search automatically for updated driver software. When given this command, Windows will start searching for the latest driver updated for your windows on the web and you will see the following message.

nvidia driver update

Step 6. If there is an updated driver available, windows will start downloading it on your computer automatically and you will see a success message saying Windows has successfully updated your driver software. Just click the Close button and you are done.

So these are instructions for updating the drivers manually. By following these instructions you can update intel graphics driver update, sound driver, and every other driver except Nvidia driver update.

If you are using the Nvidia graphics card, here's how to update the drivers to its latest version.

Step 1. The first step is to detect the graphics card model and OS type on your computer. Once both of them are found, you can update the Nvidia driver from its official website. For this, press windows+R keys, type in dxdiag in the Run window and press enter.

Step 2. In the DirectX Diagnostic Tool, see the OS type under System Information. See the screen below.

nvidia driver update

Now go to the Display tab and check for the graphics type of your windows next to the chip type.

driver update software

Once yo have successfully found both of them, head over to the next step.

Step 3. Now go to the official website of Nvidia i.e. Nvidia.com and hover your cursor over Drivers. Fill all the details required and search for the latest driver available.

If there are any latest drivers available suiting your requirements, download it on your computer and run the installer file. The driver would be downloaded soon after.

So that's all you need to know about Howto manually update drivers in Windows 7. 

As promised above, it's time to give you a quick overview of the other two methods to update drivers in the windows.

The first method by checking for the windows updates. Type in Windows Update in the search bar and press enter. You will see the following screen.

driver update software

If there are updates available, click Install now and you are done. The third way you can do that is by going to the manufacturer's website and updating the drivers and installing them. Or you can also do that by the software CD you get from the manufacturer.

That's it for this tutorial. For any doubts or queries, you can drop us a comment below. And if you found the guide helpful, feel free to share it with your friends.

Continue Reading

Trending