Training in Excel VBA – Basic Course

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

Register your interest in a Talk-IT Course

Course Interest

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!

Scroll to Top