Formulas

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

Resolved · Low Priority · Version 2003

Formulas

Nadja has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Nadja [2 posts] (2008 Apr 25 Fri, 16:40) Reply

more formula training should be provided

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: formulas

by - trainer Pete platinum contributer [600 posts] (2008 May 7 Wed, 16:12) Reply

Hi Nadja,
Thank you for your post, in answer to your question, what sort of formulas are you looking for; in our advanced course we cover the most common such as;AND, OR, IF, SUMIF, V/HLOOKUP, PMT, GOAL SEEKER, SOLVER and SCENARIOS, we also show how to use the fx (Insert Function) dialog box which gives you access to over 150 different Functions, in addition we give an introduction to creating Custom Functions. It would be difficult to include many more options as they tend to be for very specific individual requirements, as well as time constraints for completing all the other areas which are in the course syllabus.
I personally learnt to use formulas and functions by accessing the fx (Insert Function) dialog box and experimenting with the many options available, as well as using on line and Excel's own Help facilities.
I hope that has been of help to you, if so please click the Resolved link, Best regards Pete

· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Features and Functions for Accountants
· Crazy Things People Have Done With Excel
· Microsoft Excel Training: Essential for Today's Employees
· What's Better Than the Help Function in Excel? Microsoft Training

Please browse our web site to find out more about
excel in courses 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