Instructor-led training - vba training courses
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Microsoft Partner

Learning & Performance Institute - Accredited Training Provider

How to book

Live 12+ month schedule

On-site / Closed company:

60 second quote

Need help or advice?

Enter your name/number and we will call you back

We'll call during UK business hours

Name:
Number:

Microsoft Excel Courses VBA UK - London (Advanced)Excel 2013, 2010 Advanced

Microsoft Excel Courses VBA UK

2 days from £356 List price £650

Instructor-led / Microsoft qualified trainers

Courses never cancelled: Guaranteed
Guarantee applies to Microsoft Desktop training and Management Skills Training.

Benefits

  • Upon completion of the course delegates will have a good understanding of the major components of VBA.
  • Delegates will expand their reach by being able to use VBA to communicate with other Office applications, such as Word.
  • In addition, the course also covers working with data from database applications such as Access, and manipulating and presenting the data.

842 Excel events in the next 12 months, live dates & pricing here


Who is this course for?

This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with introduce more sophisticated automation into their workflows.

Prerequisites

Attendance of our Microsoft Excel VBA course, or equivalent knowledge.

Including the understanding of the following:

  • Variable types
  • Using object variables to represent worksheets and workbooks
  • Using count based (For-Next) and conditional based (Do-Until, Do-While) loops
  • If-Then-Else-End If and Select Case statements
  • With blocks
  • Using Range and Cells objects

Benefits

  • Upon completion of the course delegates will have a good understanding of the major components of VBA.
  • Delegates will expand their reach by being able to use VBA to communicate with other Office applications, such as Word.
  • In addition, the course also covers working with data from database applications such as Access, and manipulating and presenting the data.

Course Syllabus

The Excel Object Model

Exploring the Range object in detail
The versatile CurrentRegion object
Working with collections of Workbooks and Worksheets
Manipulating Charts through VBA
Manipulating PivotTables through VBA

Arrays

Efficient variable storage with arrays
Array optimisation
Dynamic arrays
The Array function

Triggers and Events

Running macros automatically
Executing macros on a timer
Associating macros with other Workbook events

Advanced Parameters

Passing parameters by reference and by value

Working with Text Files

Importing text files
Exporting text files
Using the FileStream object

Linking with Office

Connecting to other Office applications
Working with other Office applications

Linking to data sources using ADO

Understanding ActiveX Data Objects
Using Excel to communicate with other data sources
Understanding the connection string
Adding, reading, modifying and deleting data

Add-Ins

How macro security works
Password protecting your code
Distributing macros via an Add-In

Appendix: Classes and Objects

Working with Class Modules

Excel VBA Advanced 2 day course

Onsite/Closed Quote

Date Location Places
available
Book Next place rate (£) List
price
Pay by
Card
Pay by
Invoice
Thu 15 + Fri 16 May 2014 Bloomsbury 4 Book now £529 £539£650
Wed 30 + Thu 31 Jul 2014 Limehouse 7 Book now £424 £434£650
Wed 24 + Thu 25 Sep 2014 Southwark 10 Book now £420 £430£650
Tue 21 + Wed 22 Oct 2014 Bloomsbury 10 Book now £650 £650£650
Mon 17 + Tue 18 Nov 2014 Limehouse 10 Book now £420 £430£650
Tue 16 + Wed 17 Dec 2014 Southwark 10 Book now £650 £650£650
Mon 19 + Tue 20 Jan 2015 Bloomsbury 10 Book now £420 £430£650
Tue 17 + Wed 18 Feb 2015 Bloomsbury 10 Book now £650 £650£650
Wed 18 + Thu 19 Mar 2015 Southwark 10 Book now £420 £430£650
Thu 16 + Fri 17 Apr 2015 Southwark 10 Book now £650 £650£650
Thu 14 + Fri 15 May 2015 Bloomsbury 10 Book now £420 £430£650
Mon 22 + Tue 23 Jun 2015 Bloomsbury 10 Book now £650 £650£650
Wed 29 + Thu 30 Jul 2015 Limehouse 10 Book now £420 £430£650

What you get

Training room

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools

Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions

LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

Training Formats & Services

Some reasons why thousands of businesses trust us

Transparent quality control
Live 12 month schedule/bookings
Courses never cancelled: Guaranteed
Guarantee applies to Microsoft Desktop training and Management Skills Training.
Reschedule in seconds
Industry leading pricing model
Online quote
24 months training support

Testimonials

MarexSpectron Ltd
Senior Risk Manager
Stephen Hoad
Excel VBA Advanced
Very good, thorough course.
Legal & General
Technical Consultant
Craig Willey
Excel VBA Advanced
All good, very satisfied
Palletforce plc
Senior Business Analyst
Excel VBA Advanced
A very good course and I found many, very useful tips and tricks as well as the course main content.

More testimonials

Some of our clients:

London 2012 Special Olympics Great Britain UK Sport
13 delegates 19 delegates 29 delegates
92% would
recommend us
100% would
recommend us
100% would
recommend us
Transport for London BBC Ricoh Europe plc
35 delegates 17 delegates 12 delegates
85% would
recommend us
100% would
recommend us
100% would
recommend us
Virgin Media Television Houses of Parliament Metropolitan Police
19 delegates 16 delegates 121 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Barclays PLC Rabobank Legal & General
83 delegates 54 delegates 25 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
Monsoon Accessorize Ltd Action for the Blind Westmill foods
13 delegates 18 delegates 56 delegates
100% would
recommend us
100% would
recommend us
96% would
recommend us
Fred Perry Open University DHL
53 delegates 12 delegates 42 delegates
100% would
recommend us
100% would
recommend us
94% would
recommend us
Unilever Carphone Warehouse Sotheby's
80 delegates 10 delegates 126 delegates
96% would
recommend us
100% would
recommend us
99% would
recommend us
Mo Ibrahim Foundation Close Brothers Group plc Hilton Hotels Corporation
22 delegates 114 delegates 27 delegates
77% would
recommend us
94% would
recommend us
100% would
recommend us

Visual Basic for Applications (VBA) is a programming language from Microsoft. It allows you to write Macros which can be used to automate your spreadsheet, database or document. http://en.wikipedia.org/wiki/Visual_Basic

We offer four levels of Microsoft Excel Courses VBA UK training: Introduction, Intermediate (also available as 2-day Intro-Inter course), Advanced and consultancy.



Management Training courses
Course rating:
4.6 stars - based on 70 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom