> > Microsoft VBA

Microsoft VBA

Microsoft VBA For Excel Part 1

Participants will acquire a sound working knowledge of VBA, to develop and automate spreadsheet solutions.

Microsoft VBA For Excel Part 2

A course for VBA users to increase their repertoire of VBA techniques for automating spreadsheet solutions.

Forthcoming courses

Microsoft VBA Part 1

10 June 2013

£250.00

Microsoft VBA Part 2

19 June 2013

£250.00

Microsoft VBA Part 1

9 July 2013

£250.00

Microsoft VBA Part 2

24 July 2013

£250.00

Microsoft VBA Part 1

9 August 2013

£250.00

Microsoft VBA Part 2

26 August 2013

£250.00

Microsoft VBA Part 1

19 September 2013

£250.00

Microsoft VBA Part 2

26 September 2013

£250.00

Microsoft VBA Part 1

4 October 2013

£250.00

Microsoft VBA Part 2

22 October 2013

£250.00

Microsoft VBA Part 1

5 November 2013

£250.00

Microsoft VBA Part 2

25 November 2013

£250.00

Tips and tricks...
Excel VBA – Creating a navigation sheet
This code creates a list of worksheets on a navigation sheet – as an extra bonus, you can...
Excel 2010: PowerPivot
PowerPivot for Excel 2010 is a free add-on which can really enhance your data analysis and...
Excel VBA – tracking who has opened a workbook
Problem: How can I keep a record of who has opened my workbook? Solution: Create a tracking macro...
Delegate comments

"Still not 100% confident that I will be able to build the macros I need without assistance or lengthy research but I have a much better base to start off from than before. It has dispelled the fear of VBA language!"

The Trainer was very thorough in explaining everything and was more than willing to provide us with examples that were relevant to our day to day working roles within Excel and VBA. He was also willing to look at any issues we had with code that he might be able to help us with.

"I think it will be difficult to find a course to exactly match a specific individuals requirements, but this was good in terms of familiarity with the format, and will help me write own codes if I need."