HOME
 

Excel VBA Introduction

STL
Course summary
Length: 1 day
Price: 159 - 185 GBP excl. VAT
Language: English
Provider: STL plus
Course type: Open / Scheduled
Next available date: 12/02/2019 09:30 - London
Rating: (313 Reviews)
Course Dates
London
12/02/2019 09:30  (English)
185 GBP
07/03/2019 09:30  (English)
177 GBP
04/04/2019 09:30  (English)
167 GBP
22/05/2019 09:30  (English)
159 GBP
03/06/2019 09:30  (English)
159 GBP
14/06/2019 09:30  (English)
159 GBP

Excel VBA Introduction



Courses never cancelled. Restaurant lunch. 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.

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



List price £330 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video

   

Election Analysis Excel Dashboard

Best STL

Using an Excel Dashboard to analyse and visually display May 2015 UK General Election Poll data from the web.


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


Reviews by course attendees

Patrick De Courcy; Market Analyst   |   20/06/2016
          (5)
Steve Jacob; Engineer   |   20/06/2016
          (4)
Bami Fadairo; Head Of Financial Systems   |   20/06/2016
          (5)
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