Microsoft Excel VBA Course Outlines

Microsoft Excel VBA Introduction

Course Duration

Two Days

Course Level

Introduction

Course Overview

This course is designed for users familiar with Excel who have little or no knowledge of computer programming, but who would like to learn how to program features and functions to improve the accessibility and usability of their data.

At the end of the training course you will have covered the fundamentals of VBA (Visual Basic for Applications), including creating procedures and functions, variables and objects, user forms, debugging and error handling.

Course Requirements

A high proficiency of Excel is essential, or completion of our Microsoft Excel advanced course.

Course Contents

VBA Overview

  • Overview of the Project Explorer
  • The Macro Recorder
  • Subprocedures/Subroutines
  • Comments
  • The MsgBox
  • The InputBox

Variables & Constants

A General Introduction to Storage
Variables and Constants, Variable Types.

Objects

  • The Object Browser
  • The Object Hierarchy/Model
  • Properties
  • Methods
  • Events

Control Structures

  • Determining the Flow of a Program
  • Branching – If statements/Select Case
  • Looping – For Each/For/Do/While/Until

Subprocedures & Functions

  • The structure of a VBA subprocedure
  • Scope
  • Calling functions from subprocedures
  • UDFs

Debugging & Error Handling

    • Types of Errors and How to Handle Them
    • Investigating Problems Using the Debug Window

Class Project

      • Creating a user application

Availability

Contact us to see how we can schedule the Microsoft Excel VBA introduction course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft technical courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel VBA Advanced

Course Duration

Two Days

Course Level

Advanced

Course Overview

This course is designed for familiar users of VBA who want to expand their knowledge in building robust applications. We hit the ground running by creating a user application.

The course also includes learning how to use VBA to communicate between Microsoft Office applications, for instance, reading from/writing to tables in Access from Excel, creating/opening/editing Word documents etc.

Course Contents

VBA Overview

  • The Project Explorer
  • Debugging code
  • Case study

Menus & Toolbars

  • Using the Menu Editor
  • Creating and Customising Toolbars
  • ActiveX Controls – Command button, Text box, Check box, Spin button, List box
  • User Form controls – Command button, Text box, Check box, Spin button, List box

The FileSystemObject

  • Creating & Opening Files
  • Creating folders
  • Overview of the Project Explorer

Interaction with Office Applications

  • Early and Late Binding
  • ADO & DAO
  • Importing from Access
  • Manipulating Tables in Access – Insert, Update, Delete
  • Excel to Outlook
  • Excel to and from Text files
  • Excel to and from Word
  • Excel to and from SQL Server

Availability

Contact us to see how we can schedule the Microsoft Excel VBA advanced course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft technical courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel VBA Introduction

Course Duration

Two Days

Course Level

Introduction

Course Overview

This course is designed for users familiar with Excel who have little or no knowledge of computer programming, but who would like to learn how to program features and functions to improve the accessibility and usability of their data.

At the end of the training course you will have covered the fundamentals of VBA (Visual Basic for Applications), including creating procedures and functions, variables and objects, user forms, debugging and error handling.

Course Requirements

A high proficiency of Excel is essential, or completion of our Microsoft Excel advanced course.

Course Contents

VBA Overview

  • Overview of the Project Explorer
  • The Macro Recorder
  • Subprocedures/Subroutines
  • Comments
  • The MsgBox
  • The InputBox

Variables & Constants

A General Introduction to Storage
Variables and Constants, Variable Types.

Objects

  • The Object Browser
  • The Object Hierarchy/Model
  • Properties
  • Methods
  • Events

Control Structures

  • Determining the Flow of a Program
  • Branching – If statements/Select Case
  • Looping – For Each/For/Do/While/Until

Subprocedures & Functions

  • The structure of a VBA subprocedure
  • Scope
  • Calling functions from subprocedures
  • UDFs

Debugging & Error Handling

    • Types of Errors and How to Handle Them
    • Investigating Problems Using the Debug Window

Class Project

      • Creating a user application

Availability

Contact us to see how we can schedule the Microsoft Excel VBA introduction course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft technical courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Excel VBA Advanced

Course Duration

Two Days

Course Level

Advanced

Course Overview

This course is designed for familiar users of VBA who want to expand their knowledge in building robust applications. We hit the ground running by creating a user application.

The course also includes learning how to use VBA to communicate between Microsoft Office applications, for instance, reading from/writing to tables in Access from Excel, creating/opening/editing Word documents etc.

Course Contents

VBA Overview

  • The Project Explorer
  • Debugging code
  • Case study

Menus & Toolbars

  • Using the Menu Editor
  • Creating and Customising Toolbars
  • ActiveX Controls – Command button, Text box, Check box, Spin button, List box
  • User Form controls – Command button, Text box, Check box, Spin button, List box

The FileSystemObject

  • Creating & Opening Files
  • Creating folders
  • Overview of the Project Explorer

Interaction with Office Applications

  • Early and Late Binding
  • ADO & DAO
  • Importing from Access
  • Manipulating Tables in Access – Insert, Update, Delete
  • Excel to Outlook
  • Excel to and from Text files
  • Excel to and from Word
  • Excel to and from SQL Server

Availability

Contact us to see how we can schedule the Microsoft Excel VBA advanced course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft technical courses in Dorset and Hampshire to companies and individuals for over 20 years.