Advanced Course

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

Resolved · Low Priority · Version 2003

1 post

ReplyMon 18 Jan 2010, 10:14Delegate Gary said...

Gary has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Advanced Course

Thank you for the Advanced course last Friday. It was very useful and i'm looking forward to the 2 day VBA course i have signed up for.

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	1		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

834 posts

ReplyMon 18 Jan 2010, 14:45Trainer Richard said...

RE: Advanced Course

Hello Gary,

Glad you enjoyed your Microsoft Excel course with BEST Training. We look forward to seeing you on the VBA course.

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

Mon 25 Jan 2010: Automatically marked as resolved.

· How to check for and reduce errors in Microsoft Excel
· Why Should I Learn Visual Basic in Excel?
· Tap the Power of Recorded Macros with MS Excel Courses
· Improve Performance Of Your Excel Macros
· Identifying Suitable Candidates For VBA For Excel Training

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