merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Excel VBA Introduction

STL
Course summary
1 day
159 - 185 GBP excl. VAT
English
Open / Scheduled
Next available date: 19/12/2019 09:30 - London
Course Dates
London
19/12/2019 09:30  (English)
185 GBP
07/01/2020 09:30  (English)
184 GBP
13/02/2020 09:30  (English)
171 GBP
06/03/2020 09:30  (English)
163 GBP
03/04/2020 09:30  (English)
159 GBP
24/04/2020 09:30  (English)
159 GBP
STL courses

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.; ; 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



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

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....


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.stl-training.co.uk


Reviews by course attendees

Average rating 4.8

Based on 313 reviews

Patrick De Courcy; Market Analyst
(5)
Steve Jacob; Engineer
(4)
Bami Fadairo; Head Of Financial Systems
(5)
Request Information

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

Reviews
Course rating
(4.8)
Based on 313 reviews
U.K. L&D Report: 2019 - 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 second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Be Inspired - watch the videos