Centre for Continuing Education

Microsoft Excel VBA Course: An Introduction

Microsoft Visual Basic. Master programming for Windows.

Learn Microsoft Visual Basic the smart way with Microsoft Visual Basic courses at CCE, the University of Sydney.

Aims

This one-day introductory course assumes no prior programming knowledge, and builds a solid foundation of the skills and knowledge required to learn to read and write industrial VBA code in Microsoft Excel. You will gain an understanding of the background knowledge (and more) a programmer should have, in order to successfully learn to program Excel VBA macros and functions.

It is strongly recommended you complete this course prior to attending the three-day Microsoft Excel VBA Course: A Masterclass if you are:

  • A self-taught programmer (including VBA)
  • A non-programmer
  • Experienced in programming languages other than VBA.

Outcomes

Upon successful completion of this course, participants should be able to:

  1. Discuss the elements of human logic manifest in Excel’s user interface, and some of the ways those elements manifest in Excel VBA.
  2. Implement those elements in VBA functions and VBA macros for Excel.
  3. Learn about the Microsoft Excel Object Model and VBA concepts.
  4. Begin to catch errors with basic debugging.
  5. Be ready to get the most out of the three-day Microsoft Excel VBA Course.

Content

This Microsoft Excel VBA training course covers the following topics:

Human Logic

  • Gain an overview of the knowledge required to program in Excel VBA.
  • Understand the Six Requirements of Human Problem Solving.
  • Learn the Arithmetic Operators and their precedence in VBA.
  • Learn when to use the primitive/value types (variable data types) in VBA, including Variants.
  • Design algorithms with sequence and iteration.

The VBA Environment

  • Understand the essentials of the Excel Developer tab.
  • Learn the basics of the VBA Editor.
  • Understand macro-less workbooks as opposed to VBA Macro (and VBA Function) enabled workbooks.
  • Set up trusted locations for workbooks with code you trust.
  • Set macro settings for workbooks you may not trust.

Writing Procedures

  • Understand how procedures work.
  • Use VBA functions and VBA macros from the Excel interface.
  • Understand the structure of VBA code projects within a workbook.
  • Insert code modules.
  • Save your procedures in a workbook.
  • Use procedures (Macros and Functions) you have written in the Excel user interface.

The Excel Object Model

  • Gain an overview of the Excel Object Model.
  • Understand the purpose of Object/Type actions and values (methods and properties).

Debugging

  • Learn the rudiments of basic debugging.

Human logic in VBA

  • Declare variables of different types.
  • Understand the various forms of classic VBA IF statements.
  • Know when to use ANDs and ORs in If Statements.
  • Implement the modern additions for Selection in VBA.
  • Implement iteration structures in VBA.
  • Record and edit Relative and Absolute macros and understand the difference between them.
  • Recognise constants and enumerations recorded in macros, and used in “code from scratch”.
  • Translate R1C1 Referencing Style addressing in formulas to Excel interface style addressing.

Delivery Style

This short course is delivered as presenter-taught computer-based training.

Intended Audience

You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending Basic Computer Skills Course and Effective Internet Use before attempting this course.

Furthermore, you should have basic knowledge Microsoft Excel i.e. being able to write simple formulas and using some of the standard functions of Excel (e.g. Sum, Today, Vlookup etc.). If you are not a touch typist, you will be asked to write your answers in the book provided. Please bring a pen.

Features

  • Free repeat class - Conditions apply
  • Free USB flash drive
  • Expert trainer
  • Dedicated computer for every student
  • Small class size
  • Student notes – yours to keep
  • Statement of completion

What others say.

  • A great instructor, and the course was paced very well with everything that was covered necessary. This course was significantly better than any other one-dayer business skills course I’ve done before.

$376 Limited inc GST
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course assumes no prior programming knowledge, and builds a solid

...
$376 Limited inc GST
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course assumes no prior programming knowledge, and builds a solid

...
$376 Limited inc GST
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course assumes no prior programming knowledge, and builds a solid

...
$376 Limited inc GST
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course assumes no prior programming knowledge, and builds a solid

...
$376 Limited inc GST
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course assumes no prior programming knowledge, and builds a solid

...
$376 Limited inc GST
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course assumes no prior programming knowledge, and builds a solid

...
If there isn't a class to suit you, please join the waiting list.