Insight IT Training - a flexible computer training service for business users

Microsoft Excel Programming Course

Aims of the Two-Day Course

This course is suitable for advanced users who want to make use of the more powerful facilities of Excel made available by VBA, especially Forms. The course is 100% hands on, with practical exercises to practice the skills that you learn.

Course Content

Getting Started
- Introduction to VBA
- Recording & Running a Macro
- Understanding the VB Editor
- Using the Menu Bar
- Using the Standard Toolbar
- Using the Project Explorer
- Using the Properties Window
- Understanding the Code Window & Code Window Options
- Editing Code
- Using Help
Introducing Objects
- Understanding the Object Browser
- Understanding Objects & the Object Hierarchy
- Referencing Objects
- Understanding Collections
Using the Editing Features
- Using the Immediate Window
- Using the Auto List
- Using the Auto Quick Info
Introducing Variables
- Understanding & Declaring Variables
- Data Types
- Storing Values in Variables
- Storing Objects in Variables
Conditional Statements
- Understanding Conditional Statements
- Working with Decision Structures
- Working with Looping Structures

Procedures and Functions
- Understanding Procedures
- Using the Macro Recorder to Create Sub Procedures
- Using Intrinsic Functions
- Using Message & Input Boxes
- Creating Functions
- Passing Arguments to a Function
Forms and Controls
- Understanding UserForms
- Using the Toolbox
- Working with UserForm Properties, Events & Methods
- Using the Properties Window
  Understanding Controls
- Working with Label, Text Box , Command Button, Combo Box, Frame & Option Button Controls
Adding Functionality to Forms
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching Forms from Procedures
Using PivotTables
- Understanding & Creating PivotTables
- PivotTable Arguments
- Adding Fields to PivotTables
Controlling Forms
- Controlling PivotTables from a Form
- Controlling a Form from a Custom Toolbar
Debugging
- Understanding Errors
- Debugging Code & Tools
- Using the Locals & Watch Windows
- Using Breakpoints

Prerequisites

Trainees should have attended the advanced Excel course, or have both an in-depth knowledge and experience of using commands and functions in Microsoft Excel.

Course Duration

Twelve hours - 9.30am to 12.30pm and 1.30pm to 4.30pm on both days.

Prices