Excel

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

Resolved · Low Priority · Version Standard

Excel

Joanna has attended:
Excel Introduction course

by - delegate Joanna [1 post] (2008 Feb 27 Wed, 16:32) Reply

could you tell me more about formulas

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: excel

by - trainer Rich platinum contributer [711 posts] (2008 Mar 1 Sat, 10:26) Reply

There are lots of different kinds of formulas, far too many to list here. Please can you tell us what you want to do and then we can give you help on specific formulas?

Some simple ones are SUM to sum fields, LEFT to return a set number of characters to the left of a field, RIGHT to return a set number of characters to the right of a field, vlookup to see if a value in one set of data exists in another.

· A Beginners Guide To Formulas In Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Prepare for your MOS Certification with MS Excel Courses
· Microsoft Excel Training: Not Just for Newbies Anymore
· Fun Things I've Done With Excel

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