Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Microsoft Excel VBA Introduction
Microsoft Excel VBA Introduction
 

EXCEL VBA INTRODUCTION

The best source of Introduction to Excel VBA Training Courses

A hands-on one-day course with free pre-course online skills testing
See Our Latest Reviews on TrustPilot:
CPD CERTIFIED COURSE
CPD accredited course

Note: this Excel VBA Introduction course is CPD certified.
It is delivered as a classroom course.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.
We are a corporate member of the CPD: the highest level of association available.

COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2010, 2013, 2016 and Office 365 versions

DURATION

This is a one-day training course structured into 5 modules

COURSE AIMS

This intensive, hands-on one-day course has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming, and understand (and use) the relevant techniques.

TARGET AUDIENCE

The course is designed for existing, experienced users of Excel 2007, 2010, 2013 or 2016 who need to use VBA to automate their spreadsheets.
Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level.   Familiarity with the content of the Advanced course would be a minimum requirement although the Professional level is ideal.

ABOUT MICROSOFT VBA

VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language.


Want to see prices and options for delivery of your training?

MODULE 1:  Recording and Running Macros in Excel
Learning outcomes:
Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon
Topics covered:
  • Setting Excel Macro Options
  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolbar
MODULE 2:  Introduction to the Excel VBA Editor
Learning outcomes:
Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules
Topics covered:
  • Starting the Visual Basic Editor
  • Using the Project Explorer
  • Using the Properties Window
  • Creating, Importing and Exporting Modules
  • Explore Recorded Macros
MODULE 3:  Creating Procedures and Functions
Learning outcomes:
Create simple macro procedures in code that use variable to store data and communicate with the user
Topics covered:
  • Creating Sub and Function Procedures
  • Declare and Use Variables
  • Displaying Message to the User
  • Getting Input from the User
MODULE 4:  Working with the Excel Object Model
Learning outcomes:
Explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks
Topics covered:
  • Understanding Objects, Properties and Methods
  • Referencing Cells and Ranges
  • Gathering Cell and Range Information
  • Using the Offset Method
  • Using the Resize Method
  • Using With Blocks
  • Referencing Workbooks and Worksheets
MODULE 5:  Controlling Program Flow
Learning outcomes:
Using decision making and looping structures to control the way your program works
Topics covered:
  • Using the IF Statement
  • Using the Select Case Statement
  • Using For Next Loops
  • Using Do Loops
  • Using For Next Loops

Want to see prices and options for delivery of your training?

NEXT CLASS DATES
Microsoft Excel VBA Introduction
Oct 16, 2019
Birmingham Queensway
£249
Book Now
Oct 30, 2019
Manchester Piccadilly
£249
Book Now
Nov 4, 2019
London Victoria
£249
Book Now
Nov 8, 2019
Bristol Easton BS5
£249
Book Now
Nov 18, 2019
Leeds West One
£249
Book Now
Nov 27, 2019
Tower Bridge
£249
Book Now

Don't see a date you want?

RELATED COURSES

Excel Introduction

COURSE OUTLINE
[Duration: one day]

Excel Introduction

  • Getting Started with Microsoft Excel
  • The Excel Interface
  • Microsoft Excel Basics
  • Editing your Workbook
  • Printing and Viewing your Workbook
  • Working with Charts in Excel

Excel Intermediate

COURSE OUTLINE
[Duration: one day]

Excel Intermediate

  • Advanced File Tasks
  • Working with Functions and Formulas
  • Managing Tables in Microsoft Excel
  • Data Tools in Excel
  • Doing More with Charts in Excel
  • Sparklines
  • Excel Styles and Themes

Excel Advanced

COURSE OUTLINE
[Duration: one day]

Excel Advanced

  • Grouping & Outlining and Subtotals
  • What-If Analysis
  • PivotTables
  • Charting Pivoted Data
  • Advanced Excel Tasks
  • Creating HLOOKUP and VLOOKUP Functions
  • Introduction to Macros in Excel

Excel Professional

COURSE OUTLINE
[Duration: one day]

Excel Professional

  • Advanced Conditional Formatting
  • Using Form Controls and Templates
  • Advanced Lookup Functions
  • Advanced Functions in Excel
  • Advanced Pivot Table Tools
  • Introduction to User Defined Functions Using VBA

Excel VBA Advanced

COURSE OUTLINE
[Duration: one day]

Excel VBA Advanced

  • Advanced Procedures
  • Advanced Variables
  • Interacting with Office Applications
  • Debugging and Error Traps
  • Creating Custom User Forms
  • Workbook and Worksheet Events

Excel Dashboards

COURSE OUTLINE
[Duration: one day]

Excel Dashboards

  • Introduction to Dashboards
  • Inserting Graphics for a Dashboard
  • Specialist Functions and Formulas
  • Dashboard Navigation
  • Preparing your Workbook's Layout and Structure
  • Using Excel Objects for Specialist Dashboard Views
  • Using Macros and VBA with Dashboards

Excel Business Intelligence (BI)

COURSE OUTLINE
[Duration: one day]

Excel Business Intelligence (BI)

  • Importing and Linking Data
  • Data Manipulation with Pivot Tables
  • Advanced Reporting Functions
  • Automating Reports with Controls
  • Advanced Charting Features

Excel for Accounting: Introduction

COURSE OUTLINE
[Duration: one day]

Excel for Accounting: Introduction

  • Working with Functions and Formulas
  • Outlining, Grouping and Sub Totals
  • Protecting Your Spreadsheet
  • Presenting Data with Charts
  • Formatting Financial Data
  • Data Tools: Managing Your Data
  • Formula Auditing
  • LOOKUP Functions

Excel for Accounting: Advanced

COURSE OUTLINE
[Duration: one day]

Excel for Accounting: Advanced

  • Logical and Error Functions
  • WhatIf Analysis & Financial Modelling
  • Specialist Financial Functions
  • Using Pivot Tables
  • More About Charts
  • Introduction to Macros
  • Advanced LOOKUP Functions
  • Advanced PivotTable Tools

Excel for Accounting Fast Track

COURSE OUTLINE
[Duration: one day]

Excel for Accounting Fast Track

  • Formatting Financial Data
  • Data Tools: Managing Your Data
  • Formula Auditing
  • LOOKUP Functions
  • Logical and Error Functions
  • WhatIf Analysis & Financial Modelling
  • Specialist Financial Functions
  • Using Pivot Tables

DELEGATE FEEDBACK FOR OUR
MICROSOFT EXCEL VBA INTRODUCTION COURSE

AVERAGE REVIEW: 4.7 out of 5  BASED ON 21 REVIEWS

Radika Piumi Muthukumarana
, Oct 25 2018
"Training was well managed and done well"


 
Course rating of 4 stars
Oliver Wilson
, Oct 19 2018
"Our trainer, Steve was brilliant and brought extra helpful material."


 
Course rating of 4 stars
Lydia Poplett
, Sep 19 2018
"Lee could not be a better trainer!! He is so informative! I was so pleased to have him again after my first course"


 
Course rating of 5 stars
Michael Ashley
, May 23 2018
"The level of instruction from Tony was absolutely first class."


 
Course rating of 4 stars
Michael Greer
, Mar 27 2018
"Really impressed with the detailed tution tailored to my learning requirements, expecting it to prove a very valuable investment. "


 
Course rating of 5 stars
Wan Chi Ng
, Feb 19 2018
"Good trainer"


 
Course rating of 5 stars
Reshmin Haq
, Feb 14 2018
"Lee is excellent tutor, he took time to understand my questions and concerns and broke down a very complicated topic in an easy to understand way with lots of tips."


 
Course rating of 5 stars
Tara Barrett
, Jan 10 2018
"Very knowledgeable tutor, who interacted well."


 
Course rating of 5 stars
Stephen Palmer
, Nov 28 2017
"The presenter was very helpful and knowledgeable. "


 
Course rating of 4 stars
Pritam Patel
, Nov 21 2017
"Continue with the great work/training"


 
Course rating of 4 stars
Mike Docksey
, Nov 21 2017
"Lee as an outstanding tutor on my introduction to VBA"


 
Course rating of 5 stars
Dev Jassi
, Oct 10 2017
"Steve is a great trainer and asset to you"


 
Course rating of 5 stars
Alex Cowan
, Aug 24 2017
"Tony was a brilliant trainer, he was very methodical in going through the booklet and making sure we understood everything. Also very friendly in breaks/lunch as well as making sure we asked if there was any way he could improve the course. A very professional job."


 
Course rating of 5 stars
Louise Westwood
, Jul 20 2017
"Lee was an excellent trainer."


 
Course rating of 5 stars
Alan Wood
, Jun 29 2017
"Steve was great presenting an extremely useful course."


 
Course rating of 4 stars
David King
, Mar 9 2017
"Lee was particularly good in that he clearly understands Excel in a great deal of detail and doesn't have a problem in answering any questions whether they were specifically VBA related or not. "


 
Course rating of 4 stars
Andy Sherratt
, Feb 15 2017
"Steve was very knowledgeable and approachable, and I think people responded well to his teaching style. I would recommend this course to other potential VBA users."


 
Course rating of 4 stars
Tony Fossey
, Feb 2 2017
"Good teaching. Good pace."


 
Course rating of 4 stars
James Norris
, Feb 2 2017
"The trainer was extremely knowledgeable and great at explaining complex processes in a clear and concise manner."


 
Course rating of 5 stars
Luke Durbridge
, Feb 2 2017
"A well structured and presented course. The instructor was very helpful and knowledgeable. "


 
Course rating of 5 stars
Hazel Gill
, Jan 31 2017
"I very much enjoyed the course, the content was focused and useful and the pace was just right for me."


 
Course rating of 5 stars

MORE INFORMATION FOR
MICROSOFT EXCEL VBA INTRODUCTION

General Information

All Activia introduction to excel vba training courses have been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.

Class Sizes

Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor.

Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.

For training at your offices, we can deliver classes of up to 8 delegates, though with bigger class sizes you must understand that there is less time for questions from delegates, and this may affect the quality of their experience.

How to book
Course, dates and delegate numbers
Decide on the Microsoft Excel course you want, the date(s) you can attend, and the number of delegates involved
Training location
Also decide whether you want training at your offices or at one of our centres
Speedy course booking
You can use the Speedy Quote option to contact us for a quick price, or you can book online from the schedule on this website
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with the trainer, workbooks and exercise files if appropriate
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch.   The timetable is as follows:

9:15

ARRIVAL TIME

9:30

TRAINING STARTS

11:00

MID-MORNING BREAK



1:00

ONE HOUR LUNCH BREAK

3:15

MID-AFTERNOON BREAK

4:30

WRAP UP

Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

For training at your offices, this itinerary can be varied by prior arrangement.

What you get

With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge.

Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.



GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

Stay in touch
          TrustPilot
CPD
ILM
ISO9001


Back to top
Quick Links
More on This Page
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this