Microsoft Excel Training Course

Table of Contents

Excel VBA Introduction Training Course, Excel VBA Introduction Training Course

Excel VBA Introduction Overview

This Excel introduction VBA training course is aimed at experienced Excel users who need to automate repetitive tasks or simplify more complex tasks using VBA macros. Learn the elements of the Excel object model and control their automation using simple VBA control structures. Discover different ways of running macros and master the Dim statement. And save huge amounts of time every day.

Excel VBA Introduction Training Course, Excel VBA Introduction Training Course

Excel VBA Introduction Five Key Topics

  1. Creating Procedures
  2. Declaring variables
  3. If…Then…Else logic
  4. VBA Loops
  5. Excel Object Model
Excel VBA Introduction Training Course, Excel VBA Introduction Training Course

Course Details

Course Duration: 2 days
Course Availability: Monday – Saturday
Course Types: Group booking, 1-2-1 sessions, Online, Bespoke & Public Courses
Course Availability: Monday – Saturday

Excel VBA Introduction Training Course, Excel VBA Introduction Training Course

Excel VBA Introduction Training Course Details

Course Location: Our Microsoft Excel VBA Introduction 2 day training course can be delivered either at our London training venue or at your offices.

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Tailored Courses: We offer a free consultancy service to help tailor your course to meet your requirements.

Rate: £220 + VAT

Next Public Course: 17th September 2020

Days
Hours
Minutes
Seconds

Centre and Services

Comfortable & modern facilities
Unlimited access to our online training manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available

Back to contents

On Completion of Excel VBA Introduction 2-day

  • Use the macro recorder
  • Understand the Visual Basic Editor
  • Develop Procedures
  • Manage the Flow of Control using control structures
  • Debug procedures
  • Understand the Excel Object Model
  • Declare and set the data type of variables
  • Create User Defined Functions
  • Write Error Handling routines
  • Use Message Boxes and Input Boxes

Excel VBA Introduction Training Course Outline

  • Recording and running macros
  • Recording Absolute and Relative selection
  • Saving a macro-enabled workbook
  • Assigning a macro to the QAT
  • Creating a Macro Button
  • Using the Personal Macro Workbook
  • Introducing Visual Basic for Applications
  • Navigating the Visual Basic Editor
  • Using Help
  • Using statement completion
  • Memory variables
  • Understanding and creating modules
  • Defining procedures
  • Calling subroutines
  • Defining control structures
  • If…Then…Else logical structures
  • Case statements
  • Conditional loops: the Do…Loop structure
  • Counter loops: the For…Next structure
  • Collection loops: the For Each…Next structure
  • Stepping through code
  • Setting Breakpoints
  • Break mode
  • Identifying the current value of expressions
  • Using the Immediate Window
  • The Excel Document Object Model
  • Objects and Collections
  • The Object Browser
  • Methods and Properties
  • The With statement
  • How to declare variables
  • Defining the Scope and Lifetime of variables
  • Determining Data Types
  • Defining constants and using intrinsic constants
  • How to declare and use Object variables
  • Calling Excel worksheet functions
  • Creating a function procedure
  • Calling a User Defined Function
  • Using multiple and optional arguments
  • Defining error handling
  • VBA’s error trapping options
  • Capturing errors with On Error statements
  • The Error object
  • Coding an error handling routine
  • Creating a Message box
  • Message box return values
  • The Input Box function
  • Excel’s InputBox method
  • Handling input box return values
  • VBA conversion functions
Excel VBA Introduction Training Course, Excel VBA Introduction Training Course
Excel VBA Introduction Training Course, Excel VBA Introduction Training Course
Excel VBA Introduction Training Course, Excel VBA Introduction Training Course
Hints & Tips