excel training uk

excel training uk - Macros

Resolved · Low Priority · Version Standard

Macros

Henk has attended:
Excel Advanced course

by - delegate Henk [1 post] (2007 Dec 19 Wed, 17:03) Reply

Where can I found complex macro exercises and case-studies to improve my own personal skills?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Macros

by - trainer David gold contributer [418 posts] (2007 Dec 20 Thu, 13:21) Reply

Henk

Great question, if you are interested in advanced Macros, do come on our Excel VBA course.

Alternatively try

http://www.beyondtechnology.com/vba.shtml

Have a merry Christmas and a Great New Year, hope to see you on our VBA course in 2008

regards
Best Training Team

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training Course
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· From the Classroom to the Corporate World

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: