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
225 - 230 GBP excl. VAT
English
Professional Training
Next available date: 30/07/2020 09:30 - Online courses
Course Dates
Online courses
30/07/2020 09:30  (English)
230 GBP
London
07/09/2020 09:30  (English)
225 GBP
12/10/2020 09:30  (English)
225 GBP
17/11/2020 09:30  (English)
225 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.


STL virtual classroom training

We all have to accept our preferred face-to-face method just isn't an option right now. However, virtual classroom training that we have developed offers some benefits which can make it seem less of a compromise and more of a viable interim training solution. 

Our virtual classroom training is delivered by the same team responsible for achieving industry leading customer satisfaction ratings with face-to-face training, so rest assured you are in safe hands.

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 ApplicationsWhy use VBA?Recording and running macrosAbsolute v relative cell selectionWorking with the Visual Basic EditorCreating your own codeUnderstanding and creating modulesDefining proceduresCalling proceduresWhere to store macrosMaking decisions in codeUsing logical comparisonsThe IF...ENDIF structureThe SELECT CASE...END SELECT structureWhen to use IF v SELECT CASERepeating code with loopsThe DO... LOOP structureThe FOR... NEXT structureThe FOR EACH... NEXT structureHow to debug problems with loopsDebugging errorsDefining errorsSetting breakpoints to pause executionHow to step through codeWorking with break mode to spot errorsIdentifying the value of expressionsUnderstanding Visual BasicWhat is an Object?Examining the Excel object hierarchyUsing the object browserHow to explore methods and propertiesGetting 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

   

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

Similar Courses