0845 450 6120

Microsoft Excel VBA Introduction

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

DURATION

This is a one-day training course structured into 5 modules. Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor.

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.

Reset

Learning Objectives

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.

Course Content

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
One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include