excel training program - formulas

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

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

excel training program - Formulas

resolvedResolved · Low Priority · Version Standard

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.

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 tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips


Server loaded in 0.09 secs.