basic excel training - formulas

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - Formulas

basic excel training - Formulas

resolvedResolved · Low Priority · Version Standard

Sajid has attended:
Excel Intermediate course

Formulas

how 2 do formulas

RE: formulas

Good morning Sajid,

This is a very open question ! Do you mean formulas which you wish to create for example..

= A1 + B1

If this is the case you need to make sure your cursor is in the cell you would like you result/output to be in.

You then press the = sign and you can either type the characters A1 or click into the cell A1, after this you click an operator, in this case the + sign and continue to type or click into cell B1, once you have finished press the enter key and you should be left with the sum of the values in cell A1 and B1.

I hope that helps! Your training today will cover formula so you may find your initial question will be answered over the course of the day. If not feel free to post another question on the forum

Tracy


 

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

View all Excel hints and tips


Server loaded in 0.08 secs.