Knowledge about formulas?

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

Resolved · Low Priority · Version Standard

Anne has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Anne [1 post] (2008 Mar 17 Mon, 17:00) Reply

Suggestions on how to develop knowledge on formulas

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: knowledge about formulas?

by - trainer Pete platinum contributer [864 posts] (2008 Mar 18 Tue, 10:25) Reply

Hi Anne, Thank you for the post, welcome to the forum, in answer to your question, this is a bit of a biggie... without knowing a great deal about your background it is difficult to point you in the right direction, lets just say that Excel has sufficient to keep a mathematican happy for many years. The way that I learnt about the different formulas was to use the fx button on the Formula bar and went through the formulas that are explained there. I hope that helps. best regards Pete.

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· How to Create Better Excel Spreadsheets: Part Four
· From the Classroom to the Corporate World
· Improve Performance Of Your Excel Macros
· How to Create Better Excel Spreadsheets: Part One

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

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

Rate this page: