Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Medium Priority · Version 2003

Reply Tue 17 Feb 2009, 16:50Delegate Georgie said...

Georgie has attended:
Excel Intermediate course
Outlook Advanced course
Powerpoint Intermediate Advanced course

Excel

I would like to know more about formulas and feel that I have a good understanding of the workings of excel but wouldn't want to feel out of my depth at the advanced training, how much difference is there between the intermediate and advanced level?

For upcoming training course dates see: Pricing & availability

Reply Wed 18 Feb 2009, 10:03Trainer Amanda said...

RE: excel

Hello Georgie

Thank you for your question and welcome to the forum.

The Excel Advanced course covers quite a few different functions, and also covers pivot tables which are quite useful.

For the full course outline please see
http://www.microsofttraining.net/excel-training-in-london-2003-advanced.php

If you found that you were comfortable with the content from the Intermediate course then it is more than likely that you will find the Advanced course ok for you.

Kind regards
Amanda

Reply Wed 18 Feb 2009, 10:08Delegate Georgie said...

RE: excel

Great thanks!

Excel articles

· How Excel Training Can Improve Your Company's Sales Process
· Some Examples Of Excel Text Formulas
· Trust Excel To Protect Your Data
· Unsupported features in Excel 2007
· That's The Wonder Of Autofill

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