training courses in excel - Formula

Resolved · Low Priority · Version Standard

Fri 25 Jan 2008, 17:02 Delegate ian said...

ian has attended:
Excel Intermediate course

Formula

im weak formula application

Wed 30 Jan 2008, 16:54 Trainer Katie said...

RE: formula

Hi Ian,

You can find out how to use specifc FORMULAs by using the F1 help button.

All function starts with = symbol, follow by the name & cell ranges.

e.g. =SUM(B2:B6,C9)

This is an example of using the AutoSum function, adding numbers from cells B2 to B6 and C9.

Hope this helps.

Regards,
Katie

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips

training courses in excel - Formula

Formula

RE: formula

Excel articles

Excel tip:

Display Functions on Worksheets