Excel training

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

Resolved · Low Priority · Version Standard

Excel training

Nezlyn has attended:
Excel Introduction course

by - delegate Nezlyn [2 posts] (2008 Feb 13 Wed, 16:30) Reply

Whats the easiest way to absorb formatting?

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 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
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
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel training

by - trainer Mark gold contributer [151 posts] (2008 Feb 18 Mon, 16:11) Reply

Hiya Nezlyn

I am sorry to do this but can you give me a bit more info on what it is your trying to do

I will then be able to help you further

Mark East

· Microsoft Excel's Best Kept Secret
· Microsoft Excel Courses Teach Advanced Macro Techniques
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Advanced Excel Training - takes you to the next level
· Features of Microsoft Excel that assist in Analysis of Financial Data

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