- Tutor is available to students
Microsoft Excel VBA & Macros
Online Course
Training Deals
Summary
Overview
Microsoft Excel VBA and Macro Training Overview
This Microsoft Excel VBA and Macro training course is designed to bring delegates up to speed with the VBA programming language in Excel. The course is instructor-led and involves a number of practical, hands-on examples, and exercises within a workshop environment. Intended for those with some experience of Microsoft Excel, the course builds on previous skills to provide you with powerful techniques for editing macros and using Excel more efficiently.
During this VBA (Visual Basic for Applications) and Macros course, delegates will learn how to utilise Excel to achieve the best possible programming results. Primarily, delegates will discover how the automated features of Excel can ease their workload, therefore, this course is particularly useful for those who are consistently performing repetitive actions on worksheets. Individuals will also learn how to create their own macros, use and define variables, and work with a variety of objects. Essentially, this Microsoft Excel training course will enable you to do a lot more with your software, which is widely used within all areas of business.
This training course is suitable for all versions of Microsoft Excel.
Description
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
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
Who is this course for?
Anyone who is interested in learning about Excel VBA and Macros
Requirements
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.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.