Excel VBA for finance professionals

Event type: Mastercourse

New for 2012

Delegates will be introduced to the relatively unexplored world of Excel automation and macro programming using VBA (can be used across Excel versions of 2003 through to 2010). This one day course provides useful code, an insight into programming and practical exercises in VBA module compilation. It covers standard automation, macro operations, handling user input; declaring and using variables; and dealing with errors.

Date Location Price  
26 June 2012 - 09:30 London Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices
14 September 2012 - 09:30 London Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices
29 November 2012 - 09:30 London Price: GBP 599.00
Members: £539.00
Corporate discount scheme: £415.00
+ VAT on all prices

Who will benefit

  • Those who wish to increase spreadsheet potential by automating their tasks and processes.
  • Finance professionals and spreadsheet authors looking to make better use of macros and scripting.

Speaker Details

The speaker will be drawn from a pool of qualified professionals who specialise in this subject. Having worked for leading organisations they will relate the course content to real life case studies.

Outline

  • VBA best practice
  • common rules of programming
  • editing simple modules
  • modular capabilities: declaring variables; error handling; iterations
  • handling user input
  • displaying user prompts
  • IF THEN scenarios.

The course starts at 9.30 am and finishes at 4.30 pm.

5.5 CPD hours (where applicable)

Find out more
If you have any queries please email or phone us on +44 (0)845 026 4722.

CIMA on demand
CIMA on demand is a high quality online professional development solution, specifically designed for busy finance and business professionals. Find out more.