Formulas

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

Resolved · Low Priority · Version 2003

Formulas

Janet has attended:
Excel Intermediate course

by - delegate Janet [1 post] (2008 Apr 17 Thu, 16:05) Reply

where can i find a list of formula explanations

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 30 Wed + 31 Thu	Bayswater	0	FULL
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	3	book now	£475	£495
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
2003/XP	2008 Sep 18 Thu + 19 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 47 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: formulas

by - trainer Pete platinum contributer [719 posts] (2008 Apr 18 Fri, 14:36) Reply

Hi Janet, Thank you for your post, welcome to the forum, I hope you enjoyed your course, in answer to your question, there is nowhere better than in Excel itself to give you an explanation of all the formulas and functions which are available, if you click on the fx button on the formula toolbar (or click on the drop down arrow next to the Sigma (Greek S) AutoSum button you will see the option for More Functions,) this will open a dialog box where you can type in plain language a request for Search and Excel will respond with either a list for you to choose from, or with a specific function, in the dialog box an explanation of what the formula will do for you will be displayed, there are many, many different functions and formulas, as I always say enough to keep a Professor of Maths happy, I hope that has helped, if so please click the resolved link, best regards Pete.

· How to Create Better Excel Spreadsheets: Part Three
· Benefits of learning about Excel charts
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· How to Create Better Excel Spreadsheets: Part One
· Prepare for your MOS Certification with MS Excel Courses

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

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips