Microsoft Excel VBA And Macro Training - Dubai UAE

4.5/5
microsoft part logo

Course Information

Microsoft Excel VBA and Macro Training 

The Microsoft Excel VBA and Macro training course will explore the following modules:

Module 1: Introduction

  • What is a Macro?
  • Types of Macros
  • Command Macros
  • Function Macros
  • Macro Formatting
  • Run a Pre-Recorded Macro
  • VBA
  • Accessing VBA Editor
  • VBA – Excel Macros

Module 2: Event Handling

  • VBA – Events
  • Worksheet Events
  • Workbook Events

Module 3: Functions

  • Functions Overview
  • Calling a Function
  • User Defined Functions

Module 4: ERROR Statements

  • Error Statements Overview
  • Terms of Error Statements
  • Untrapped Errors

    » Show More 👇

Module 5: Forms

Module 6: Referencing Other Applications

Module 7: Messages and Variables

  • Messages
  • Variables

Module 8: Simple IF Conditions

Module 9: Three Main Types of Loop

  • Loops Overview
  • While Wend Loops
  • Do While Loops
  • Do Until Loops

Module 10: Recording Macros and Buttons

  • An Introduction to Macro Recorder
  • Recording a Macro

Module 11: The Excel Object Model

  • Excel Object

Module 12: Debugging and Error Handling

  • Error Handling Routine
  • Handling Errors

    » Show Less 👆

Who should attend this Excel Training Course?

This training course is designed for those who have Microsoft Excel experience and would like to build upon this.

Prerequisites

There are no formal prerequisites, thus anyone can attend. We recommend that delegates can confidently navigate Excel, and are familiar with its main features, although this is not compulsory. No prior knowledge of Excel macros or VBA is required.

The Trainer has more than 15 years of experience in training of software applications and assisting with all aspects of the full training life cycle, setting up training (classroom, 1- 1), delivery. Possessing excellent communication, interpersonal and presentation skills, have managed Corporate Training assignments.

Technical Skill Profile:

  • Microsoft Word (Beginners, Intermediate & Advanced)
  • Microsoft Excel (Beginners, Intermediate & Advanced)
  • Excel VBA (with advance programming techniques)
  • Microsoft PowerPoint (Beginners & Advanced)
  • Microsoft Access (Beginners & Advanced)
  • Microsoft Outlook (Beginners & Advanced)
  • Microsoft Visio
  • Microsoft Project • Internet (Beginners & Advanced Search Techniques)

Request more Information

    What People say?

    Not sure,
    which course to choose?

    Our Clients across the Globe!