Excel VBA Introduction
-
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
Description
-
Type
Course
-
Location
-
Start date
Different dates available
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
Start date
Start date
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.
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 rating
Recommended
Centre rating
Jordan
Mell
Maya
Calvin
Justin
This centre's achievements
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
Excel VBA Introduction