Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Linda has attended:
Word Intermediate course
Excel Introduction course
PowerPoint Introduction course

Excel

Just remind me how to get SUM again !!!

RE: Excel

Dear Linda

Thank you for attending Excel Intro Course. I hope you enjoyed the course and it was beneficial to you.

SUM is one of the many functions that Excel provides you. The purpose of functions is that it save you time and confusion when performing calculations. For example if you were to Add Ten cells then you would have to press = and then type in each cell followed by the + sign nine times.

Sum function allows to simplify things. You press = and then type Sum followed by the bracket and then simply select the cells that you intend to Add.
e.g.
=SUM(A2:A10)

Another easier method of Sum is to use the AutoSum feature.

You simply click on the cell where you want the result. Click on the AutoSum Button which is on the the standard toolbar on the right hand side. This is like a Letter E ( also known as Greek Letter Sigma).

I hope this has helped in answering your question.

Please mark this post as resolved if you are satisfied with the answer. If you need further clarification then please press the Reply button and ask for further clarification.

Many thanks


Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000/2003

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.