excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 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:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips


Server loaded in 0.08 secs.