HOME
 

Excel VBA Introduction

STL
Course summary
1 day
English
Nationwide
Company-Specific / In-House

Excel VBA Introduction



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... By the end of the course the delegate will be competent in the fundamentals of VBA, including recording macros, working with the Visual Basic Editor and writing their own code.; In order to ensure minimal downtime while building and rolling out the program, the course also includes advice on debugging code and handling errors.; ; You may also wish to consider our Excel forecasting and data analysis training course.

Suitability - Who should attend?



This course is suitable for advanced users of Microsoft Excel. If they are responsible for very large and variable amounts of data, or teams, who need to learn how to program features and functions to develop the accessibility and usability of their data.

Training Course Content



Introducing Visual Basic for Applications

Why use VBA?
Recording and running macros
Absolute v relative cell selection
Working with the Visual Basic Editor

Creating your own code

Understanding and creating modules
Defining procedures
Calling procedures
Where to store macros

Making decisions in code

Using logical comparisons
The IF...ENDIF structure
The SELECT CASE...END SELECT structure
When to use IF v SELECT CASE

Repeating code with loops

The DO... LOOP structure
The FOR... NEXT structure
The FOR EACH... NEXT structure
How to debug problems with loops

Debugging errors

Defining errors
Setting breakpoints to pause execution
How to step through code
Working with break mode to spot errors
Identifying the value of expressions

Understanding Visual Basic

What is an Object?
Examining the Excel object hierarchy
Using the object browser
How to explore methods and properties
Getting help in VBA

Expenses



Prices from £579. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel VBA Introduction.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Excel VBA Introduction course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here