Excel Training Tips

Excel Training Tips & Secrets

The Auto Sum Feature in Microsoft Excel

The auto sum feature

This is one of my favourite and most used button on the excel interface.  Basically it does an automatic sum for the cells you have selected.

Say you have a list of numbers in there hundreds, if you were to manually calculate a list that big it could potentially take you ages, not only that but you could make a mistake in the calculation process and that will unfortunately lead you to having to start all over again!

Thankfully Microsoft’s Excel program gives you the function to select these lists of data and will automatically calculate the sum for you, hence the name “auto sum”.

One of the other features of this function is that it actually allows you not only to add, but it allows you to multiply, dived and take an average of the data.

This can be very useful in companies when they need to create data reports and time is an issue.  What would have taken hours, now takes minutes and is 100% functional.  This is one of the hundreds of reasons that Microsoft Excel is the successful program that it is.

July 2, 2009 - Posted by jackz123 | Uncategorized | , , , , , | No Comments Yet

No comments yet.

Leave a comment