Learn Excel VBA 2013 - Basic training courses

Key Information

Duration: 1 days

Course Learning Skills: VBA 2013
Additional Material: Download Course Slides Link

Brief

We offer three one day Excel VBA courses to cover the three levels of Basic, Intermediate and Advanced. You can, if you wish, do all three over a three day period or combine any two over a two day period.

Also, you can mix and match modules from the three levels if you would prefer to tailor a course more suited to your needs.

Attendees

This course is for experienced users of Excel who are looking to dip their toe into VBA and introduce more automation and flexibility into their spreadsheets.

Prerequisites

Ideally each delegate should already be proficient at creating and maintaining spreadsheets and be comfortable with most of Excel’s more advanced features (e.g. formulas, functions, pivot tables, charts).

Benefits

Delegates will gain an understanding of the basic principles of Excel VBA programming and be able to do the following:

Amend a recorded macro so that it works in a variety of situations
Create a function for their own use to supplement those already in Excel
Create a procedure to automate a series of basic manual tasks

Basics

Overview of the VBA environment
How to record and modify a macro
Use of relative and absolute addressing
Introduction to modules, procedures and functions
Use of comments in a macro
How to Step through and test a macro
Overview of objects, properties and methods
Overview of the Excel object hierarchy

Working with a range of cells

Overview of the Range object
Use of the Selection property
Retrieval of count of cells in a selection
Use the Offset method and property
Retrieval of cell values and formulae
Maintenance of cell values
Use of column and row properties
Use of property combinations

Working with workbooks and worksheets

Overview of the Workbook object
Overview of the Worksheet object
Use of the Activate and Add methods

Visual Basic components

Use of variables and data types
Use of IF and CASE statements
Use of DO and FOR loops

Running Macros

Use of MSGBOX and INPUTBOX dialogue objects
Assigning macros to objects
Basic forms and buttons

Creating Procedures & Functions

Use of parameters and arguments
Key differences between procedures and functions
Use of user defined functions in spreadsheets

Book an Instructor Led Course

Do a short survey to tell us what you think about training?

Click here to take the survey, it’ll only take a few minutes!