Excel

Resolved · Low Priority · Version Standard

Wed 27 Feb 2008, 16:32 Delegate Joanna said...

Joanna has attended:
Excel Introduction course

Excel

could you tell me more about formulas

Sat 1 Mar 2008, 10:26 Trainer Cress said...

RE: excel

There are lots of different kinds of formulas, far too many to list here. Please can you tell us what you want to do and then we can give you help on specific formulas?

Some simple ones are SUM to sum fields, LEFT to return a set number of characters to the left of a field, RIGHT to return a set number of characters to the right of a field, vlookup to see if a value in one set of data exists in another.

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips

Excel

Excel

RE: excel

Excel articles

Excel tip:

Quick Absolute Cell References