Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training program - Formulas

Resolved · Low Priority · Version Standard

Reply Thu 15 Feb 2007, 09:53Delegate Christopher said...

Christopher has attended:
Excel Intermediate course

Formulas

Can you please list the different symbols used for formulas and what they mean. Ie: $, (), =FALSE etc. If there are too many can you please list the basic and most used symbols. Thank you.

For upcoming training course dates see: Pricing & availability

Reply Fri 16 Feb 2007, 12:07Trainer Rich said...

RE: Formulas

Hi Chris,

You're right there are many different symbols.

I'd recommend looking at this page:
http://www.cob.sjsu.edu/splane_m/ExcelFormulas.htm

As they clearly explain how to use them as well!

I hope this helps.

Good luck!

Regards, Rich

Excel articles

· An Introduction To Financial Functions In Excel 2010
· Break The Mystery Of Code With Excel Macros
· What's Better Than the Help Function in Excel? Microsoft Training
· Discover The Difference Between Line And XY Scatter Charts In Excel
· Basic Excel Training

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips