Excel VBA Introduction

STL
4.3
25 reviews
  • Richard's compact approach implied that he could pack in heaps of data without it being an over-burden. I likewise value the exertion he experienced towards the start to get some information about our ambitions to accustom the preparation as per our necessities.
    |
  • Programme expense covers content, classroom teaching, inclusive of 1 year post training backing and lunch on the day of the course. Tutelage was exceptionally nicely organized and instructor was energetic and splendid about the subject. Unquestionably suggested.
    |
  • The Power Point course was enjoyable and informative. Andrew demonstrated some exceptionally helpful capacities which are probably going to make our lives much less demanding. It was likewise the correct length, with a proper adjust of sessions and breaks, so we can be attentive during the course. Surely Prescribed
    |

Course

In London

£ 201-500

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

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.

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

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.

A thorough knowledge of Microsoft Excel is required, or completion of our Microsoft Excel Advanced course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.3
fantastic
  • Richard's compact approach implied that he could pack in heaps of data without it being an over-burden. I likewise value the exertion he experienced towards the start to get some information about our ambitions to accustom the preparation as per our necessities.
    |
  • Programme expense covers content, classroom teaching, inclusive of 1 year post training backing and lunch on the day of the course. Tutelage was exceptionally nicely organized and instructor was energetic and splendid about the subject. Unquestionably suggested.
    |
  • The Power Point course was enjoyable and informative. Andrew demonstrated some exceptionally helpful capacities which are probably going to make our lives much less demanding. It was likewise the correct length, with a proper adjust of sessions and breaks, so we can be attentive during the course. Surely Prescribed
    |
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Jordan

5.0
05/07/2017
What I would highlight: Richard's compact approach implied that he could pack in heaps of data without it being an over-burden. I likewise value the exertion he experienced towards the start to get some information about our ambitions to accustom the preparation as per our necessities.
What could be improved: Nothing.
Would you recommend this course?: Yes

Mell

3.5
03/10/2016
What I would highlight: Programme expense covers content, classroom teaching, inclusive of 1 year post training backing and lunch on the day of the course. Tutelage was exceptionally nicely organized and instructor was energetic and splendid about the subject. Unquestionably suggested.
What could be improved: Nothing.
Would you recommend this course?: Yes

Maya

5.0
07/08/2016
What I would highlight: The Power Point course was enjoyable and informative. Andrew demonstrated some exceptionally helpful capacities which are probably going to make our lives much less demanding. It was likewise the correct length, with a proper adjust of sessions and breaks, so we can be attentive during the course. Surely Prescribed
What could be improved: N/A.
Would you recommend this course?: Yes

Calvin

5.0
18/07/2016
What I would highlight: Enormous programme. The time invested in stimulating one's abilities is of immeasurable value. These folks are carrying an accomplished bundle. Will surely prescribe.
What could be improved: N/A.
Would you recommend this course?: Yes

Justin

3.5
02/11/2015
What I would highlight: Incredible
What could be improved: A bit rushed.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MS Excel
  • Visual Basic
  • Visual Basic training
  • VBA
  • Creating modules
  • Debugging errors
  • Excel
  • Object browser
  • Excel for Accounting
  • Spreadsheet
  • Using excel
  • Excel Sheet

Course programme

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

Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

Excel VBA Introduction

£ 201-500