Instructor-led training - vba training courses
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777
STL

Excel VBA Advanced Training CoursesExcel VBA Advanced Training Courses

Learn Advanced Visual Basic for 2013, 2010, 2007

2 days from £370 List price £699

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.

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

Next: Syllabus »

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

Next: Dates »

What you get

Training room

Microsoft qualified trainers

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?"

LunchLunch

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

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)

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits

Learning tools

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

Reference materialReference material

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

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

Next: Formats »

Training Formats & Services

Next: Why us? »

Testimonials

Equifax
Analyst

Excel VBA Advanced
Happy with the course, I have no improvements.
However, we use quarterly reports which use data to generate charts - could have been useful to work through (although we are self taught on how to do these)
The Open University
PPC Administrator

Excel VBA Advanced
Jens is very familiar with Excel and Access VBA. He is very knowledgable and willing to share with other areas of skills with us. Well done Jens!
Velocys
Senior Chemist

Excel VBA Advanced
Great course, that will really help me in my work where I have to mange a lot of data,

I suggest to keep time for practical issues that delegates might have on their own data or at their own work,

More testimonials

« Overview

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, Advanced and consultancy.

Free manual

We are providing our course manual and exercise files free of charge.

Why not share this resource with your friends and colleagues using the buttons below?


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

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

info@microsofttraining.net

Resources

X

Search