banner image

Excel VBA Introduction

2 Day Instructor-led
course icon

Course Information

Course Overview

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. Excel VBA course will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel VBA.

Excel VBA course is the perfect introduction to VBA and shows you how to use it to enhance Excel. You'll then learn how to work with the key objects and uncover the best ways to gain access to workbooks, worksheets, and more.

Excel VBA course helps you to create automated spreadsheets for all those repetitive tasks. VBA can also help to simply complex tasks that need to be performed on a regular basis. At the end of the course, users will be able to record and run macros, edit the VBA code, build in looping structures and create custom forms.

Prerequisites

Delegates should have proficient knowledge of Microsoft Excel or should have attended all of the following courses (or similar) prior to this course:

  • Excel Introduction
  • Excel Intermediate
  • Excel Advanced

Course Outline

1. Getting Started
  • Introducing Visual Basic for Applications
  • Displaying the Developer Tab
  • Recording a Macro
  • Saving a Macro-Enabled Workbook
  • Running a Macro
  • Editing a Macro in the Visual Basic Editor
  • Understanding the Development Environment
  • Using Visual Basic Help
  • Understanding Macro Security
2. Working with Procedures and Functions
  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures
  • Using the Immediate Window to Call Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Working with the Code Editor
3. Understanding Objects
  • Understanding Objects
  • Navigating the Excel Object Hierarchy
  • Understanding Collections
  • Using the Object Browser
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Creating an Event Procedure
4. Using Expressions, Variables, and Intrinsic Functions
  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Using Intrinsic Functions
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes
  • Declaring and Using Object Variables
5. Controlling Program Execution
  • Understanding Control-of-Flow Structures
  • Using the If...End If Decision Structures
  • Using the Select Case...End Select Structure
  • Using the Do...Loop Structure
  • Using the For...To...Next Structure
  • Using the For Each...Next Structure
  • Guidelines for use of Control-of-Flow Structures
6. Working with Forms and Controls
  • Understanding UserForms
  • Using the Toolbox
  • Working with UserForm Properties, Events,and Methods
  • Understanding Controls
  • Setting Control Properties in the Properties Window
  • Working with Control Appearance
  • Setting the Tab Order
  • Populating a Control
  • Adding Code to Controls
  • Launching a Form in Code
7. Debugging the Code
  • Understanding Errors
  • Using Debugging Tools
  • Setting Breakpoints
  • Stepping through Code
  • Using Break Mode during Run mode
  • Determining the Value of Expressions
8. Handling Errors
  • Understanding Error Handling
  • Understanding VBA's Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling

Dates & Prices

Attend one of our public Excel courses:

Small Class Sizes

Maximum of 6 students per course.

Reference Manual

High quality reference manual supporting the topics covered.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:
Choose a location...
2 Day Course
Wed, 22 May 2024 to Thu, 23 May 2024
£595
Mon, 29 Jul 2024 to Tue, 30 Jul 2024
£595
Mon, 23 Sep 2024 to Tue, 24 Sep 2024
£595
Mon, 25 Nov 2024 to Tue, 26 Nov 2024
£595

Private Courses

We can arrange your own private Excel course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

The course was fantastic - I couldn't recommend it enough!

Bonnie Donaghue - IRI

Really good trainer. He made the training interesting and fun.

Wendy Sipson - Hampshire Constabulary

Trainer was very engaging, spent time explaining topics clearly.

Laura Choake - Desoutter Industrial Tools

The trainer was an amazing lecturer and the vba course was very usefull and well structured. Thank you.

Veronika Panton - Haven Power

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

The trainer was a really good instructor, he took the time to help us with individual issues and also tried to cater the course to meet our collective needs.

Ben Knight - Atlas Copco Ltd

Related Courses

Next on Wed 1 May
Format:
Virtual or Classroom
Length:
1 Day
This introductory Microsoft Excel course is ideal for beginners who want to learn how to:
  • Produce spreadsheets
  • Work with data
  • Perform basic calculations
Next on Mon 8 Apr
Format:
Virtual or Classroom
Length:
1 Day

This course has been developed for people wanting to use Excel to perform calculations with a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

Next on Wed 10 Apr
Format:
Virtual or Classroom
Length:
1 Day
  • Work with multiple workbooks and worksheets at the same time
  • Share and protect workbooks
  • Automate workbook functionality
  • Apply conditional logic
  • Audit worksheets
  • Present your data visually effectively
Next on Wed 22 May
Format:
Virtual or Classroom
Length:
2 Days
  • Understand the functions of Excel VBA
  • Understand applications of Excel VBA to improve efficiency
  • Use Excel VBA to enhance efficiency of the software
  • Investigate and solve problems related to Excel VBA
Format:
Virtual or Classroom
Length:
1 Day
  • Create advanced formulas
  • Automate workbook functionality
  • Apply conditional logic
  • Visualise data using basic charts
  • Implement advanced charting techniques
  • Use PivotTables, slicers and PivotCharts to analyse data
Format:
Virtual or Classroom
Length:
1 Day
  • Prepare data for PivotTables
  • Create PivotTables from various data sources
  • Analyse data using PivotTables
  • Work with PivotCharts
Format:
Virtual or Classroom
Length:
1 Day
  • Utilise Power Pivot in your data analysis
  • Visualise Power Pivot data
  • Apply the advanced functions to your data
Format:
Virtual or Classroom
Length:
1 Day

Learn the basics of the M language and how to use Power Query to organise and query your data inside Excel.