excel training program - Formulas

The UK's most regular instructor-led training courses.
Training information: excel training program · Excel training london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Formulas

Christopher has attended:
Excel Intermediate course

by - delegate Christopher [1 post] (2007 Feb 15 Thu, 09:53) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Formulas

by - trainer Rich platinum contributer [713 posts] (2007 Feb 16 Fri, 12:07) Reply

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 Macros for the Non-Programmer
· Do You Really Need Excel VBA Training?
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Tips to Facilitate Printing of Excel worksheets

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips