MICROSOFT
Enjoy the best in Introduction to Visual Basic Training
The course provides participants with a thorough introduction to Visual Basic for Excel. Participants learn how to record macros and subsequently tidy the code, as well as how to write simple macros directly in the Visual Basic Editor
Introduction to Visual Basic
Also covered are loops and IF statements, creating message boxes, debugging, error handling and best practice recommendations. By attending the course, participants will gain an appreciation of when using macros is beneficial and how we can work with them in a safer and more user-friendly manner.
Course Objectives
The course is designed to cover the following key objectives:
- Understand the types of actions that VBA can be used for
- Learn how to record a macro and tidy the code
- Become familiar with different parts of the VBA Editor
- Understand the language of Visual Basic to a beginners level
- Know what objects, methods and properties are and how we work with them
- Be able to code simple macros comprising of IF statements and Loops
- See different methods of debugging i.e., checking for and fixing errors in the code
- Obtain guidance on best practice approaches when working with VBA
Course Outline
During the course, the following areas will be covered:
Introduction to VBA
What VBA can be used for, the types of actions that can be performed and example uses of macros in financial models.
Debugging
Techniques that can be used to test for and ix errors in the code.
Recording macros
How to record them and subsequently tidy up the code.
Best practice rules for when working with macros
Guidelines that should be followed such as using direct referencing, commenting the code and applying range names.
The key building blocks of Visual Basic
The various windows in the Visual Basic Editor and working with objects, properties, and methods.
Variables
Declaring variables and using them to store values.
Logical statements
Working with ‘If’ and ’Select case’ statements.
Loops
Working with ‘For … Next’, ‘For each … Next’, ‘Do while’ and ‘Do until’ loops.
Message boxes
Setting them up and the benefits they can bring.
Other VBA features
Such as ‘Auto open’ macros, changing Excel’s calculation mode and updating the status bar.
Prerequisites
A good understanding of Excel and some experience of financial modelling is required. Participants are not expected to have a background in programming or to have used VBA before.
Client Testimonials
Be wary of companies that pay external vendors to farm and post reviews, many of them are not authentic. Ours come straight from Google, you can’t alter reviews on Google Maps in any way. Don’t take our word for who we are – hear from our clients:
Get Introduction to Visual Basic Certified
Our award winning superior training solutions are designed to help you set effective business goals and attain measurable business outcomes. With return clients and multiple testimonials, we have established ourselves as a premier training solution provider for corporate teams across the globe, providing nothing less than the best corporate training in the marketplace.
Looking For Introduction to Visual Basic
Training?
Please reach out to us with any questions you might have. We welcome the opportunity to talk through your individual training needs, or that of your team. And no, we will not relentlessly hound you with sales calls, we promise! We are a no pressure, service oriented company.
Reach out – you’ll be glad you did!