Course code 
QE-VBA
Course dates 
16/11/2017 - 09:30 to 17/11/2017 - 16:30
JUST ADDED!
25/01/2018 - 09:30 to 26/01/2018 - 16:30
Course difficulty 
Advanced
Course fees 
£540 per delegate

Call for discounts

Price excludes VAT

Lunch and refreshments will be provided

Excel VBA (Visual Basic for Applications)

This 2-day course will teach you how to create visual basic macros, understand the basics of object orientated programming and manipulate code to suit your needs.

 

Target Audience

This course is valuable for experienced Excel users who had to manipulate large data sets or manage regular reports from inconsistent data

 

Objectives

This course is about harnessing the power of Microsoft Excel Visual Basic to learn the programming language behind the scenes. You will gain the knowledge and hands-on skills required to exploit Excel's macros, and build your own custom code modules to manipulate and manage your data.

 

Pre-Requisites

A good understanding of Excel functions and formulas

TOPICS

Visual Basic and Macros

  • Recording a macro
  • Simple formatting; Cells, Columns
  • The VB editor, the Property and Project window
  • View and understand code structure
  • Concepts of object oriented programming
  • Object properties methods and actions

The VBA World

  • Modules tab
  • Subs and Functions
  • Option Explicit and other Tools / Options
  • Colour coded editor
  • Split window
  • F2, dropdown declarations, Ctrl+F
  • Object Browser
  • Shift+F2 (Ctrl+Shift+F2)

Subs vs Functions

  • Syntax; Sub, Public and Private
  • Procedure Names
  • Auto Syntax Check

Running Functions

  • Debug Window calling a function
  • Query’s Conditions
  • Form Event

Forms

  • Creating a form, using Form Objects
  • Naming Conventions

Programming VBA

  • Comments
  • Line continuation character
  • Variables; search VBA Help Index for Long and go to Data Type Summary
  • Option Explicit
  • Variables and Variants
  • Other data types
  • Variable Scope

Branching and Looping

  • Indenting
  • If Then Else
  • For Next loops
  • Do Loops
  • Select Case

Debugging

  • Immediate Window Ctrl G
  • Breakpoints F9
  • Step Into F8
  • Mouse over variable

Error Handling

  • None
  • On Error Goto 0
  • On Error Resume Next
  • On Error Goto xxxx
  • Resume or Resume Next
  • Error Handlers and Objects
Course testimonials 
"I would welcome this course to anyone that works with excel. You do not realise how little you know until you attend. You can only improve and the course will help you to achieve these goals."
- Schemes Manager, Plan Insurance Brokers January 2017
"Very helpful course. Gave me a good introduction to VBA, which will enable me to learn more independently."
- Quantity Surveyor, Walter Lilly & Co. Limited January 2017

Catherine Rapley, Training Coordinator

To book a place on this course, enquire about dates, or to find out about bulk discounts and special offers, please call Catherine on 020 8763 8732.

CANCELLATION/REFUND POLICY

If you can no longer attend a course you have booked on, the following terms will apply depending on how many calendar days remain before the course date:

More than 30 days: You will be offered a full refund, or you may change to alternative course dates, or you may change the name on the booking.
21 to 30 days: You will be offered a 50% refund, or you may change to alternative course dates, or you may change the name on the booking.
14 to 20 days: You will be offered a 25% refund, or you may change the name on the booking.
0 to 13 days: No refund is offered, however you may change the name on the booking.

Enquire now

Our friendly team are waiting to take your call on 020 8763 8732. Alternatively fill out the contact form below and we'll get back to you.