Microsoft Excel VBA Introduction Training course Outline 1 day

Audience: This course is aimed at experienced Excel users who need to automate repetitive tasks or simplify more complex tasks using VBA macros. Learn the elements of the Excel object model and control their automation using simple VBA control structures. And save huge amounts of time every day.

Course Duration: This is a 1 day Fast Track Course to get you up and running with VBA.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel VBA introduction training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Use the macro recorder
  • Understand the Visual Basic Editor
  • Develop procedures
  • Manage the Flow of Control using control structures
  • Debug procedures
  • Understand the Excel Object Model

Course Outline

Module 1: Recording Macros

  • Recording and running macros
  • Using Relative References
  • Saving a macro-enabled workbook
  • Assigning a macro to the QAT
  • Creating a Macro Button
  • Using the Personal Macro Workbook

Module 2: Working with the Visual Basic Editor

  • Introducing Visual Basic for Applications
  • Navigating the Visual Basic Editor
  • Using Help
  • Using statement completion

Module 3: Developing Procedures

  • Understanding and creating modules
  • Defining procedures
  • Calling subroutines
  • Memory variables

Module 4: Managing the Flow of Control

  • Decision making structures:
  • If…End If structure
  • Select Case…End Select structure
  • Looping structures:
  • Conditional loops: the Do…Loop structure
  • Counter loops: the For…Next structure
  • Collection loops: the For Each…Next structure

Module 5: Debugging

  • Stepping through code
  • Setting Breakpoints
  • Break mode and Run mode
  • Identifying the value of expressions
  • Using the Immediate Window
  • Basic Error Handling

Module 6: Introducing Objects

  • The Excel Document Object Model
  • Objects and Collections
  • The Object Browser
  • Methods and Properties
  • The With statement
, Microsoft Excel VBA Introduction Training course 1 day
, Microsoft Excel VBA Introduction Training course 1 day