Excel VBA Introduction
- 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.
What to expect
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- Face-to-Face and Virtual Instructor led .
- And more... .
Upcoming start dates
Upcoming start dates
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 modulesDefining procedures
Calling procedures
Where to store macros
Making decisions in code
Using logical comparisonsThe IF...ENDIF structure
The SELECT CASE...END SELECT structure
When to use IF v SELECT CASE
Repeating code with loops
The DO... LOOP structureThe FOR... NEXT structure
The FOR EACH... NEXT structure
How to debug problems with loops
Debugging errors
Defining errorsSetting 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 £350, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
Request information - obligation free
Customer Outreach Award
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.
Reviews by course attendees
Average rating 4.8
Good beginner course for those without previous experience with VBA/coding
Nothing further that could have been improved - just feel I need a bit more experience and practise before progressing to next course
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Some more independent practice examples during day would be good to help solidify knowledge:)