Summing up, subtracting, and manipulation of data is best performed in Microsoft excel program. If you have ever been using MS excel you must be knowing that apart from creating data sheets, result sheet, MS excel is also used to add, subtract, divide and almost all the mathematical task can be performed in MS Excel.
If you don't know how to add in excel, how to sum a column in excel, and how to total a column in excel, then this guide is probably going to solve all your queries today. If you are interested in finding the average in Excel, you can check that too.
If you have a huge amount of data in a column that you want to add, you can easily do that in excel. Here is the guide telling to steps to follow for adding the columns in excel.
Adding values (summing) is an integral part of Microsoft excel program. No matter whether you adding data to any cell, subtotaling data, or making any sheet by summing some running data, excel provides multiple ways that can be used to some data.
To make things done easy, this article provides you the comprehensive guide on how to add numbers in excel. As I said above MS excel provides various ways to sum up data and we will see some of the best ways and most useful excel sum formula here.
How to Add in Excel
In order to learn how to add on excel, you will need to know sum formula in excel. Until you are aware of these formulas, adding data in excel would not seem very easy to you.
In this article, we have provided you with the best formula for summing up the data. Let's head over to it and see how we can add data in excel. Below we have shared the list of formulas which you can use to add values to the data. Here goes the list of formula:
#1: Basic Addition:
This is the most yet useful formula everyone prefers using. To summing up the data all you will need to do is typing an equation into a cell, such as 5+5.
But wait, even though, you have put the query of adding the numbers, isn't the excel smart enough to proceed to that query??? It is!! Confused?? Let me explain.
When you put any query to the excel like if you want two numbers to be added you will need to specify the query with the symbol “=”. If you don't do this and put the query like 5+5, excel will consider those as digits what you have put in the sale and will interpret the symbols there as a label, not as a formula.
So in order to let excel know you want to perform an action, you will need to mention the symbol “=” before the digits and then press Enter. To get it better check out the below screenshot.
#2: Adding By Address
This is another way to sum up the data in the Microsoft excel program. In this method, you will need to mention the address of the cell you want the addition of.
To do so, you will need to enter one cell whether it is row or column and the other one just after the previous cell. Put the symbol + in between both the cell. Again remember, start the formula just by preceding them with an equal sign. See the screenshot.
#3: Adding Columns
Let's try out another example. Imagine if you have a list of numbers placed in a column and you want the sum of all the numbers. In such a situation, what would you do? Well, it's again pretty easy.
There are two methods you can try to sum up the column numbers. One we have already discussed above i.e by putting the cell numbers. This is pretty easy and useful if you have a short list of the numbers.
Yes, if you have a limited number, then typing out the cell names manually could be easy but, if the list is longer then this task seem to be very difficult. So in such case, you will need to try another method which I have described below.
To add any series of cells that are contiguous. All you will need to do is put all the data in a series and use the excel function sum(). In the enclosure, you will need to put the address of the first cell, a colon, and then the address of the last cell. Or, just click and drag the whole column down and it will automatically add the values. See Screenshot
Once you are done filling the cell numbers press Enter.
As you can see in the image, all the data between the first cell to the last cell, including everything in between have been added. This method is mostly used when the list of the data is higher.
#4: Adding manually by shortcuts:
Last but not the least. This is the last method to summing up the data. If you don't remember any formula, or have no idea about the cell or in case if the list is too large to check the first cell and the last cell then you can add the data manually by dragging the cells.
Let me explain it briefly! If you have put the digits in the excel cells and want to add them up, select that cell and the address will be added automatically. Now you will need to put the column after the cell is selected and then select the last cell by clicking on it. Make sure you don't use any space between the first cell, colon, and the last cell. Now simply press enter and you would see the result right there.
This is one of the most used methods. Even I prefer using this since you don't have to enter any cell number, any data or any other formality is required.
So this is how we can easily add up the data in MS Excel. These were the most useful and easy to use methods that are used for calculating the data, adding up the digits and creating the result sheets. Excel can also be used to calculate other mathematical problems. You can also divide in excel. Along with that, you can represent numerical data in an impressive way by creating charts on Excel.
I hope after following the complete guide you don't have any doubt regarding the how to add in excel. If you liked the article do share it on the social media platforms!!
How to Merge Word Documents
Have you ever wondered how to merge word documents? You might have! In our daily life, the situation often occurs when it feels the need for combining the word documents into one.
If you have been using MS word, you probably have felt the need of merging up more than one document into a single word file. For instance, if you write a thesis, dissertation or book, you will create all the pages separately, like page 1, page 2 and so on.
But after, when you are done writing up all the pages and want to merge them up in one single document, how would you do that? How would you merge word documents? Probably, you will create a new document and copy all the pages one by one page and paste them into the chief doc (main document).
But let me tell you this is absolutely a wrong way of merging up the documents. This article explains how to combine Word documents into one document.
So let's get started, and learn how to merge documents in word.
How to Merge Word Documents
To merge up the files, you can use two ways. One by copy-pasting as I said above and another way is by creating a main document and combining them.
In this article, we will let you know to merge up the multiple files into one file in almost all the versions of MS word. No matter you use MS word 2007 or 2010, you will get to learn the procedure for all. Just keep reading the article until the end.
In order to provide you the tutorial with screenshots, I have created three-word file name file 1, file 2 and file 3. And the main file that is named with the Main file. I will merge up the file, file 1, file 2, and file 3 into the principal file that is the Main file.
Ok, so here go our guide on how to merge two-word documents. The steps are given below. Follow all the steps carefully and see how the multi-files are merged into one.
But before moving to the guide make sure to follow some prerequisites given below.
- First of all, make sure the files you have saved are in the same extension.
- Also, the files that you are up to merge should be in a particular order. Word will merge your files in alphanumerical order.
For example, if you have named your files as file 1 introduction, file 2 projects, and file 3 docs, then the word will combine all the files in the same order.
But if you have named your files as an introduction, projects, and docs, then the files will be sorted in alphabetical order. And the order would be docs, introduction, project.
So if you want your files to merge in some sequence, then you will have to save them with a particular order or sequence.
How to combine word documents in Word 2007 or later
The following procedure is for MS Word 2007 and later versions. If you own some older version of MS office then still not to worry, below I have covered that also.
- In MS Word, go to the Insert menu from the top menu bar.
- In the Insert tab, at the rightmost side, you will see an option, Object. Click on that. Don't click on the object, but on the small arrow just beside the object option.
- After you click on the Object, you will see two options, Object.. and Text from the file. See the screenshot below.
- In order to insert the file, you will need to choose the second option that is Text from the file. As sooner you click on the option a dialogue box will open. Here you will need to select the files you want to merge.
For instance, I am selecting the files named file 1, file 2 and file 3. See the screenshot below.
- After selecting all the files you want to merge you will have to click on the insert button as shown in the above screenshot.
- And you are done! After clicking on the insert button, all the files you selected would get merged into the main document. Now save the main file at the location you want.
This is how we merge a document to the current file or multi documents into one single file.
If you have a single file that you want to merge in the current file, then you need to open the current file first and then select the file you want to merge by going to the Text from file option.
And if you want to merge multi-files as said above, then you can press CTRL key to select multi-files in one go.
If you have an older version of MS office like 2003 or so, then the procedure of merging file would be a slight different from the previous one. The procedure to merge files in MS word 2003 is given below.
- First of all, go to the Tools menu from the top menu bar. Here you will need to select the Compare and Merge Documents option. See the screen mentioned below.
- When you click on the Compare and Merge Documents option, you will see, a dialogue box will open. Here you have to select the files you want to merge.
- open the files by clicking on them and click on Insert as shown in the below screenshot.
- That's it. After you click on the insert option, you will see all the selected files will be opened up in the Mian MS word file.
- Now save the file with the new name at any location you want.
Isn't merging files in MS word is easy? Let me know your views on the guide and the procedure I have mentioned. If you have any other way other than the mentioned procedure do let us know.
Also, do drop your comments and views regarding the guide on how to merge word documents. In the case of any confusion, you can ask them without any hesitation.
If you find the article useful share it with your friends and relative.
How to Cite a Website?
Citing a website might sound a new term to many. It's not different than acknowledging someone's work by giving them credit for their work!
Many people including writers, bloggers, news websites and others mention statements of other people with their names and this is what we exactly call citation.
If you know the term plagiarism, you might understand Citation better by exactly counting it as just the opposite of plagiarism. Plagiarism is representing others' work as our own, without giving them any credit for their hard work, whereas, in the citation, we mention the name of the author after or before mentioning their work.
Citing can be done to any website, photo, art, music, report, etc. The other name for citation is Quoting. So next time when you read the term quote or cite consider them both as same!
While preparing any report or doing some research, we often stuck around some content on a website, which we just want to put as it is to our report. Apparently, it is unfair to do it without giving the credit to the website for their good work.
Therefore it becomes really essential for us to cite the website, i.e give credit to the website for their work and it is the best way to show your curtsy too!
If you don't know how to cite a website, then probably the article is for you! There are a number of ways we can cite a website, let's find out what are those ways!
How to Cite a Website:
As suggested above, there are a number of ways you can make the citation of a website. We won't be teaching you here all the ways for citation but the two most used ways i.e Modern Language Association's (MLA) and American Psychological Association's (APA).
These both methods follow the different guidelines to show the website as a source you have researched and show your curtsy towards the website for providing valuable contents.
Both the methods i.e MLA and APA use their different sets of rules and format for citation. I'll walk you through the step by step guide for citing a website through APA and MLA!
Citing a website in MLA:
Below steps will tell you how to cite a website using MLA citation.
Step 1. If you are supposed to cite a website where you know the name of the author, you need to follow the below format.
Last Name, First Name, “Article Title.” Website Title. Website Publisher, date of publication, month, year. Date/Month/Year you accessed the content.
You can well understand it better by the following screenshot.
Although, in MLA we don't require to add the URL of the website some websites may ask you to do that's exceptional. If you want, you can add the URL of the resource at the bottom of your content under the title references.
Or simply place it just after the format given above. To be more specific, the website URL should be given just after the date, the content has been accessed.
The above format is applicable when you know the name of the author. But if you don't know the name, follow the format, given in step 2.
Step 2. Not every time you will see the name of the author on the article you took the reference from. In such cases, you can follow the below format for citation.
The correct citation format to be followed when the author's name is unknown is as follows.
“Article Title.” Website Title. Website Publisher, date of publication, month, year. Date/Month/Year of the day you accessed the content.
You can see, there is no difference in the format accept the name in the beginning. See the following image to see how it works!
Isn't it really easy to cite a website with the MAL method?? The steps are equally simple for APA citation as well. Let's find out!
Citing a website in APA:
Unlike MLA, we need to embed the URL of the website to be cited in the text of the website. This is really essential to do that, hence you can't skip this step.
In MLA, we do it in some circumstances, while in APA, we do it on a mandatory basis. Below steps will tell you how to cite a website using APA citation.
Step 1. If you know the name of the author of the article, then below citation format is applicable for you!
Last Name, First Name (Year, Month Date of Publication). Article title. Retrieved from URL
Yes, in APA, we write the date of the content published before the title of the website. The last name and first name of the author separated with the commas, then the date ( in the format Year, Month date) when the content was published. And then comes the title of the article, followed by the website URL.
Exactly the same, as the below screenshot.
Step 2. And if the author's name is unknown to you, the following Format needs to be followed.
Article title. (Year, Month Date of Publication). Retrieved from URL
You can see the difference. If you still have any doubts, about how this method works, have a look at the below screenshot.
When you use others' work like photos, tweets, FB status, any article of a website on your report, website or book, it becomes really essential to give the credit to them for their work to avoid any kind of copyright infringement and to show your thankfulness.
The above guide was compiled to teach you how to cite a website using MAL and APA methods. There are many other methods for the same which you can easily get from other resources on the web.
The Citation is also handy for your readers. By getting to know about the resources you have researched, they can explore the topic more clearly and in-depth, if they desire to!
On that note, we have reached the end of the guide. Feel free to share the guide if you found it useful and drop your comment below if you encountered any problem while following the steps.
How to Create a Pie Chart in Excel?
Creating a pie chart in Excel is one of the most used functions of this application. But let me tell you a secret, I really hate this feature!
I mean when I was a kid, I spent hours and hours to do all the calculations and then make the pie chart. My drawing was very bad that meant I spent countless hours trying to make a perfect circle.
And then let's just not talk about making the lines of the perfect angle inside. And then when I grew up I thought it was the time to show my superhuman skills of making a perfect pie chart.
But then Microsoft made Excel pie charts means all my skills are of no use now (I hate you! Bill). Anyway, Pie Charts in Excel is one of the most amazing features of this app.
We can create not only the perfect pie charts in terms of Angles but also they are great in terms of looks. So today we have brought you a complete tutorial on how to create a pie chart in Excel?
After going through this article, you will be able to make a pie chart.
What is a Pie Chart In Excel?
Before knowing how to make a pie chart in excel, you need to know what the Pie Chart actually is. Well, in simple words pie charts is a chart to display data relative to other data in a circle. Each set of data has his own value or slice in the circle (or Pie).
Now Microsoft had taken this and changed the approach. Previously you had to create a pie chart with your hand, and you had to calculate the size/angle of each slice manually.
Now you can just enter the primary values of the chart and then create a flashing attractive pie chart within 5 minutes without any calculations and drawing skills.
Uses of Pie Chart in Excel.
So now you know what a pie chart is so it's time to know how can you use it. It's a basic human behavior that we understand the things we can see more easily rather than the things we have to read and understand.
So if there are lots of data which are related to each other and you want to explain it to somebody else. Then creating a pie chart is the best option.
For example, if your boss gives $1000 each month to spend on staff. And at the end of the month, he wants to know how you spent the money.
Now if you'll try to explain to him that you spend $50 on tea, $10 on buying pens, $10 on buying paper, etc. then he might order to through you out of the office for confusing him with lots of data.
But at the same time if you know how to create a chart in Excel and then show it to your boss then it will be far more easy for him to understand it.
How to create a pie chart in Excel?
So now you have enough knowledge of Pie Chart, and it's usages so now it's time to learn how to create a pie chart using Excel. Relax it's not rocket science, in fact, you can create a pie chart within 5 minutes. Just follow the following steps to do so-
Step #1: Enter the necessary data.
For creating a pie chart you first need to enter a set of data in the Excel Spreadsheet. Type the names of all categories in one cell range and the value associated with them in the other cell range just in front of the related categories.
For example, we are writing the name of animals found in an area and their population in the other category. See the image below for better understanding:
Step #2: Select all the necessary data.
Once you have entered the necessary categories and their values, you'll need to select them. Just use your mouse and select all the cells you want to use in your Excel Pie Chart.
Note that you should not leave any line blank while writing the data.
Step #3: Adding the pie chart.
Once you have entered and selected the values, now it's time to add the much-awaited pie chart. Click on the Insert tab and choose ‘Pie' from the options that appear.
Once you click on it, a new pop-up will appear, it will contain all the styles you can use for your pie chart. From there select your pie chart. For this example, we are selecting the 2D pie chart which is the first option from the pop-up.
Congrats that's all you have to do. Your pie chart will now automatically appear in the Spreadsheet as seen in the below picture.
Now if you like, you can play with your pie chart. You can click on any slice of the pie and then take it away from the chart. This will be very helpful while giving a presentation. You can take the slice out of the circle which you are trying to explain. So people will easily understand which slice you are talking about.
Pie chart Frequently Asked Questions
Pie charts are the most commonly used features for business, so obviously people always have what-if questions or how to question it. So we have created a handy faq section to answer questions about pie charts-
Q: I entered a wrong before creating the pie chart excel?
It often happens that you notice that you have entered a value wrongly after creating a pie chart. Well, don't worry. You won't have to create the whole pie chart again. Rather than you can just change the numbers, you entered in the spreadsheet, and the pie chart will be updated automatically.
Q: I can't find the pie option in Excel 2013?
With the 2013 version of Microsoft Excel, Windows have made big changes in the UI section. So if you are used to working with the older versions, you may find it hard to locate the pie option.
But don't worry it's just there. Once you open the Insert menu, you can find the pie options there. For your ease, we have marked out the pie option in the picture below-
Q: What is the design tab and how to find it?
A design tab is a unique option in the Excel 2013 version. You can see it on the menu above after you have inserted the pie chart in it. Here is a quick look at all the options available in the design tab-
- Add Chart Element- it allows you to change the chart title, legend or data labels.
- Quick Layouts- they are different preset charts. You can use any of them if you don't want to change every part of chart one by one.
- Change Colors-it allows you to change the colors in your chart.
So this was the complete tutorial on how to create a pie chart in Excel? Do you still have any questions in your mind? Do tell us in the comment box.
Stay tuned and thank you for giving it a read.
How to Set Up Google Two-Step Verification
You are a human, you are living in the 21st century, so no doubt you are in need of an E-mail account. And well I can bet 9/10 of you own a Gmail account, of course, because of the trust and security that Google offers. Google is pretty serious about its products, and that's why it owns at least one company, with each and every letter of the alphabet.
Now, following repeated attempts of hackers trying to get into Gmail accounts, Gmail launched the un-hack-able two-step Verification system, so if you've ever wondered how to set up a Google two-step verification procedure on your account, this is the perfect place to be.
What is Google Two-Step Verification System:-
Google Two-step verification procedure is one of the best security measures for your online stuff in the world, and especially when it comes to your e-mail accounts.
What this Two-step verification system basically does is, it adds one extra layer of security to your Gmail account, apart from your password.
Because as it goes without saying, and even the founder of WordPress, Matt Mullenweg said it:- Passwords are the weakest part of your online security.
If you set up the Two-step verification procedure on your Gmail account, here's what will happen to your Gmail account:-
- You enter Gmail.com
- You enter your Email ID & Password.
- Then, Gmail will send you an OTP on your cell phone, which you have to enter on the next screen to log in.
- And only after the successful verification of both the Password and the OTP can you log in to your account.
You can also select the “don't ask again on this computer” checkbox.
If you log in to your system frequently. You should check that box, then Gmail won't ask you again for the OTP on that specific system, but except that system on any other computer the OTP will still be required every-time they try to log in.
So that was about what the Google two-step verification system is, right? How about working on how to set it up?
How to set up Google Two-Step Verification System:-
Log in to your Google Gmail account, and head over to my account section.
On the next screen, you need to check the Sign in and Security's tab and click on the Get Started button over there.
This screen will take you to your Google security center, this is where you can control almost every aspect related to your account's security, be it your recovery Email, Cell phone number, of the two-step verification system.
Well, in order to set up the Google two-step verification system, you need to click on the done button, no matter where it appears.
Keep clicking the done button until it gets you to the two-step verification tab. Once you reach the verification tab, it should look something like the below screenshot, and in that tab click on the “2 step verification page” link.
Which should take you to the final page where you set it all up. So just click on the “Start Setup” button.
Now in the next screen, enter your Cell phone number which you want to use to receive the OTP's while logging in. After done with the Cell number, enter the mode via which you want the OTP, you can set it to either Text Message or Voice Call depending upon your preference. And then click on the “send code” button.
Once you click that button, you will receive an OTP on your cell phone, almost immediately. Enter this OTP on the screen, and click on Verify.
Well, you are almost done! The next screen is just a “fail-safe” kind of thing, it'll ask you if you want to make the current computer a trusted computer. Well, if you're on your private computer, and you're sure no one else except you will try to login to your computer, then you should make it a trusted one.
It's important, because losing a cell phone isn't a big deal, and well you don't want to lose your account forever just because you lost your cell, right? So if you have a trusted computer, you can log in to your account without the need of the OTP and change the two-step verification number to a new one.
But keep in mind, do this only if you're on a private computer that belongs to you. If you're in an internet cafe or at your friends' system, then “un-check” the button, or else you can just change the box that says: “Trust this computer”.
Well, you're done, now just click on “confirm” and you're all set!
Now, you'll be redirected back to paradise, I'm just kidding, you'll be redirected to that 2 step verification startup screen, and now you should see something like the below screenshot on the right-hand side of your account.
If you're seeing that, then chill out, grab a cold coffee and relax. But if you aren't getting that little notification, you probably did something wrong and might have to start over again, in either case, I think I made my point clear, right?
See? Told ya, it takes less than 5 minutes to set up a Google two-step verification system, huh? Now that you're “smarter” compared to your friends who don't know how to set up a Google two-step verification system, go out and teach them too, after all, sharing is caring!
How to Reset Windows Password Without an Installation CD
Password – one word with a huge meaning in our life nowadays, because daily we use lots of sites over the internet. To remember all login passwords is not an easy task but browsers are giving the facility to remember them. What, when you forgot your Windows Password?
Reinstall the Windows Copy? That's not a good idea because there are many ways to reset Windows Password. And right now you don't have the installation CD, in this case also there is no need to worry.
Today, I am gonna show you a tutorial on “How to Reset Windows Password without an installation CD”. So, below is the step by step guide on How to Reset Windows Password without an installation CD, just follow it and reset Windows Password easily.
Step by Step Guide on:
How to Reset Windows Password without an installation CD
Firstly, you have to download the Offline NT Password & Registry Editor and make a boot disk using ISO image which you have downloaded.
Boot your PC from the boot disk and you will see below image on your screen. On-screen, it asks if you want to select the first partition (Windows installed partition) then “1” is already selected, so just hit Enter.
The next screen will appear to choose the path to your registry. The default is fine don't need to change it, so just hit Enter.
Now, the screen will appear displaying Password reset and many other options, don't do anything because “1” is already selected so now also just hit Enter.
Here you will be prompted, whether you want to edit users or the registry. You want to edit user passwords, so hit Enter again.
Now, comes the main part and please don't hit enter again (Just Kidding). The screen will show usernames which are available on your PC, so you have to enter that username for which you want to reset Windows password and now you can hit enter.
The next screen will show some advanced options no need to worry because you have to blank the password by selecting the “1” option and that's probably been already selected so just hit enter and get reset Windows Password.
And now, you’ll have to save what you just did. So type an exclamation point to quit (or the “!” symbol), then type the letter “y” to save all your work. Now you can reboot your computer and of course, you will able to login into Windows without any problem.
The above is the complete guide on How to Reset Windows Password without an installation CD. If you face any problem in resetting your Windows Password then put your problem/query in below comments section via the comment form.
So, that we can help you to get rid of that problem as early as possible.
How to Change PSN Name on Playstation?
How to Add a YouTube Subscribe Button to Your Site?
How to Unblur a Picture?
How to Receive Money through PayPal?
How to Make a Yahoo Account Without a Phone Number?
How To Enable/Disable Chrome Pop Up Blocker
Tech1 year ago
How to Receive Money through PayPal?
Tech1 year ago
How to Make a Yahoo Account Without a Phone Number?
Tutorials1 year ago
How To Enable/Disable Chrome Pop Up Blocker
Mac1 year ago
How to Install GIMP for Mac
Tech1 year ago
How to Tame a Horse in Minecraft?
Mac1 year ago
How to Use Apple Thunderbolt Display with PC?
Computers1 year ago
How to Reset Macbook Air?
Tech1 year ago
How to Turn on Bluetooth in Windows 10