Web
Analytics
Connect with us

Tutorials

How to Add in Excel?

Published

on

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.

How-to-Add-in-Excel

#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.

How-to-Add-in-Excel

#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

How-to-Add-in-Excel

How-to-Add-in-Excel

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!!

Sonam is an IT engineer by education and passionate freelance writer/blogger by profession. She is a tech enthusiast and loves to read and write about technology. Her hobbies include reading, watching TV, delving into new things and creating interesting content to help people with all things tech!!

Continue Reading
Click to comment

Leave a Reply

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

Tutorials

How To Download YouTube Videos More Faster Using IDM

Published

on

internet download manager

As we all know YouTube is the largest video sharing website. It’s the biggest online video community in the world. It allows Users to Upload their Video, Download YouTube Videos, and these videos can be seen anywhere.

Any user can watch, videos by just login on the website. You can find different variety of videos here, for example, learning videos, entertainment, comedy, action, movies, music, marketing and many more from any part of the World.
According to YouTube Latest Stats more than 3.5 to 4 billion videos viewed per day(approx) and 48 hours of video Uploaded per minute. This is all about the Giant Videos WebSite “YouTube”.

By default, YouTube does not allow to download videos due to Copyrighted/patent issue. It only allows to send the Link to friend & family and he/she can watch it from anywhere in the World on YouTube.

But, today We come up with a new trick to download YouTube videos with More fastest speed by IDM. IDM here refers to fastest- “Internet Download manager”. So, here are the Instructions to Download videos from YouTube using IDM.

Steps To Download YouTube Videos using IDM

1. Go to IDM Link for download Internet Download Manager and download the files. (It's free)
2. After downloading the file, install it in your Computer.
3. After Installing IDM just Restart the computer, Your Browser to run IDM Addon on it.
4. Now go to YouTube Website and while watching it you will get Notify about a button Above Right side your Video Saying that Download this Video-Green Arrow- Just click it and your video will start downloading using IDM with more fastest Speed as compared to others software and tricks.

Benefits of Downloading YouTube Videos Using IDM

how-to-use-IDM-for-youtube

1. It maximizes your Downloading Speed up to 8 times.
2. It Supports Resume/pause Download that will start downloading data from the interrupted state due to the lost connection or Any Network Problems or Computer Restarts due to unexpected recovery problem.
3. It Supports all browsers with User-friendly Interface.
4. It also has many inbuilt features like a dial for download videos and also shut down the computer, when downloads get completed.
5. It directly fetches the Video with All Available and given formats as possible.

So using this awesome and world's best downloading software you can download youtube videos very fast !!

Continue Reading

Tips

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

Published

on

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

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

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

Sometimes you may even have to shut your blog down.

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

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

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

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

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

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

Follow the steps as listed below:-

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

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

Continue Reading

Google Plus

How to Delete Google Plus Profile Easily

Published

on

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Continue Reading

iPhone

How to Convert DVD to iTunes

Published

on

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

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

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

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

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

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

Convert DVD to iTunes Now

Download here –

Install this software and follow the steps-

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

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

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

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

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

Continue Reading

Software

How to Embed YouTube Videos in PowerPoint

Published

on

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

Why embed Youtube Video in PowerPoint?

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

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

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

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

Embedding Youtube Video in PowerPoint!

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

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

Embed YouTube Videos Directly into PowerPoint!

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

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

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

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

Get Videos from Google Docs into PowerPoint

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

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

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

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

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

Embed Youtube video in PowerPoint from your PC!

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

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

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

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

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

Continue Reading

Trending