0845 450 6120

Introduction to VBA – Office 2010

This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming, event handling, control structures, and debugging tools.

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

We don't currently have any courses listed for Introduction to VBA – Office 2010, would you like to view all courses for Microsoft Office?

Learning Objectives

Delegates will learn how to

  • Record and edit a Macro recorded within Excel/Word
  • Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
  • Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
  • Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
  • Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
  • Create an error handling routine in case things go wrong with VBA code

Pre-Requisites

  • Navigate, edit and manage Excel workbooks
  • Format worksheets and workbooks
  • Understand the difference between absolute and relative references
  • Understand the basics of Excel formulas and functions, e.g. Sum, text functions
  • Understand the concepts of a Macro and its capabilities

Course Content

This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming, e vent handling, control structures, and debugging tools.

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include