Formulae

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

Resolved · Low Priority · Version 2003

1 post

ReplyWed 24 Jun 2009, 14:09Delegate Grazyna said...

Grazyna has attended:
Excel Intermediate course

Formulae

Where can I refer to for a list of formulaes, please?

Thank you
Grazyna

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 19 Mar 2010	Bloomsbury	1		£240	£245
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	2		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
Full Schedule: See all 70 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

336 posts

ReplyThu 25 Jun 2009, 12:55Trainer Anthony said...

RE: formulae

Hi Grazyna. Formulas are written by individual users, so there is no definition list of them I'm afraid! However, if you need a list of Excel functions, just type "Functions" into the Help field and click on "Worksheet functions listed by category". This should give you a list of the built-in functions provided by Excel, grouped according to category.

Hope this helps,

Anthony

Wed 1 Jul 2009: Automatically marked as resolved.

· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Unsupported features in Excel 2007
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Flexible uses for Excel at Home
· How to Create Better Excel Spreadsheets: Part Four

Please browse our web site to find out more about
excel consultant and other Microsoft training courses.

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Formulae

Formulae

RE: formulae

Related articles

Excel tip:

Quickly insert a function