Follow Us :

Microsoft Excel VBA Introduction

Course_Reference: 
E2-EVBA
Manufacturer: 
0
Training_Provider: 
112
Summary: 

The skills and knowledge acquired in Microsoft Excel VBA Introduction are sufficient to be able to use and operate the software at an efficient level.

PreRequisites: 

Microsoft Excel VBA Introduction assumes the delegate has completed the Excel Fundamentals, Excel Intermediate and Excel Advanced courses or has equivalent knowledge.

Audience: 

Microsoft Excel VBA Introduction is designed for users who are keen to extend their understanding and knowledge of

the software.

Objectives: 

At the completion of Microsoft Excel VBA Introduction you should be able to:

  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros
  • create and work with user-defined functions
  • work with the main components of the VBA Editor window
  • understand the Excel object model and use the Immediate window
  • create command procedures
  • create and use variables
  • write code to manipulate Excel objects
  • use a range of common programming techniques
  • create a custom form complete with controls and event procedures
  • create code to drive a custom form
  • customise the menu system
  • create procedures that start automatically
  • debug Excel VBA

  • Recorded Macros
  • Recorder Workshop
  • User-Defined Functions
  • Using The VBA Editor
  • Understanding VBAProcedures
  • Using Variables
  • Using Excel Objects
  • Programming Techniques
  • Creating Custom Forms
  • Programming Custom Forms
  • Custom Menus
  • Automatic Startup
  • Debugging

Description: 

The skills and knowledge acquired in Microsoft Excel VBA Introduction are sufficient to be able to use and operate the software at an efficient level.

Software Vendor

IT Technical

Business Skills