Excel Notes

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

Resolved · Low Priority · Version Standard

Excel Notes

Samantha has attended:
Word Intermediate course
Excel Intermediate course
Excel Advanced course
Word Advanced course

by - delegate Samantha [4 posts] (2008 Mar 13 Thu, 15:11) Reply

Mark

Could I please have your email address again? I have a request.

Sam Harrison

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Excel Notes

by - trainer Mark gold contributer [326 posts] (2008 Mar 14 Fri, 14:07) Edited on 2008 Mar 14 Fri, 14:44 Reply

Hiya Sam

How are you today

its mark

please email me anything you need

RE: Excel Notes

by - trainer Mark gold contributer [326 posts] (2008 Mar 18 Tue, 09:47) Reply

Hi Sam

Hope you are ok and having a good week, as i understand it you had a request you wanted to ask i know you may be busy i am preping all day today but i will be training for the rest of the week so anytime you get a mo

If you would prefer me to email you i can do so if you give me your address

anyway i just wanted to drop you a line just to check all was well

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the Reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Kind Regards

Mark East
mark

· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Do You Really Need Excel VBA Training?
· Excel in the Home Office
· A Beginners Guide To Formulas In Excel

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips

Rate this page: