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

basic excel training - how create formulas

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - How to create formulas

basic excel training - How to create formulas

ResolvedVersion Standard

Gawin has attended:
Excel Introduction course

How to create formulas

how do Icreate formulas in excel?

RE: how to create formulas

Hi Gawin,

Thanks for the question

To create formulas you must press the equals sign (=) then put the cell references of the cells you want to add up. Simply put the cell reference and then an operator, for example =A1+B1 will add up all the contents of A1 and B1.

Hope that helps

Tracy

Excel tip:

Shortcut fill a cell with contents from adjacent cells

Use Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share!


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.