Microsoft Excel VBA Training
-
The thing that I enjoyed most about the course was learning alternate ways for tackling windows, and not feeling you were asking moronic inquiries.
← | →
-
Extremely valuable course, revived my insight, and will be utilized to enhance procedure of utilizing spreadsheets as a part of the working environment.
← | →
-
The course was straightforward and carefully fit to suit my necessities.
← | →
Short course
In Timperley and Nottingham
Get the best of Excel Visual Basic!
-
Type
Short course
-
Level
Advanced
-
Location
-
Duration
1 Day
-
Start date
Different dates available
Emagister adds to its catalogue the Microsoft Excel VBA Training, which will enable you to use Excel Visual Basic for Applications (VBA) to automate and customise spreadsheets. Were appropriate your own work requirements may be used as course examples.
Click on our website emagister.co.uk in order to find all the information related to the course. We will inform you about the course without any obligation.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
About this course
What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:
Appreciate the benefits of using Visual Basic (VBA) macros.
Record, run and edit basic Excel macros.
Interpret and edit VBA code.
Apply programming techniques such as conditional branching and loops to your macros.
Acquisit user data and display messages.
Create User Forms to manage complex user input.
Who is this course for?
This course will enable you to use Excel Visual Basic for Applications (VBA) to automate and customise spreadsheets. Were appropriate your own work requirements may be used as course examples.
What do I need to know before attending?
It is assumed that you will be familiar with a wide range of Excel features, in addition to being a competent Microsoft Windows user.
vtl certificate of attendance.
Vantage Training Ltd courses, are designed focusing on getting the best of Excel. We have been delivering high quality training to our customers for over 20 years. All course delegates are given a mouse-mat, pen and course manual to take away…plus 30 days post training support by telephone or email.
After enquiring about our IT courses, we will email you with the relevant course outline, course prices and date options. After agreeing a mutually convenient course date, we will send you a course booking form. When you have completed and returned your course booking form, we will send you your course joining instructions as confirmation of your booking.
After the course we will ring or email you to check that you are happy with your course and then send you your invoice, which is due within 30 day payment term.
Reviews
-
The thing that I enjoyed most about the course was learning alternate ways for tackling windows, and not feeling you were asking moronic inquiries.
← | →
-
Extremely valuable course, revived my insight, and will be utilized to enhance procedure of utilizing spreadsheets as a part of the working environment.
← | →
-
The course was straightforward and carefully fit to suit my necessities.
← | →
Course rating
Recommended
Centre rating
Hayley Holmes
Lynne Allen
Peta Hyland
Misia Smith
Tina Naylor
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 15 years
Subjects
- MS Excel
- Excel
- Microsoft excel training
- Microsoft Excel
- Visual Basic
- Excel Formula
- Programming
- Code debugging and testing
- Microsoft Excel VBA course
- Microsoft Excel VBA training
- Excel VBA training
Teachers and trainers (1)
Brian Roberts
Technical Trainer
20+ years experience of training delivery. Extensive programming experience using Microsoft Office based applications usually requiring Visual Basic programming. Designed, managed, and delivered corporate training roll-outs for several companies, including Barclays, Astra Zenica, and Unilever. Responsible for initial training needs analysis, training delivery, through to effective evaluation and post training support. Providing training solutions for a variety of industries, public sector, and educational establishments.
Course programme
Content
Introducing Macros
Explaining the purpose and potential of Excel macros.
VBA (Macro) Basics
Recording simple macros to automate routines such as document formatting.
Using convenient ways of running macros -objects within documents, and shortcut keys.
Cell Referencing
Using Absolute and Relative referencing in macros.
Methods for Excel navigation and selection.
Working with Excel Objects.
Editing VBA Program Code
An introduction to the programming behind recorded macros.
Understanding the syntax of VBA code.
Making changes and additions to code.
Adding comments.
Using the Basic Help system.
Extending Control
Introducing some commonly used commands to give more power and flexibility to your macros, such as making the actions of your macro conditional on some activity.
Creating non-recordable code for:
Toggling settings.
Managing user-input and displaying messages.
Declaring and using variables.
Use of conditional statements.
Responding to 'Events'.
User Forms
Creating and utilising custom User Forms to manage user interaction.
Processing data returned from user forms.
Troubleshooting Problems
Techniques to help find and resolve problems:
Identifying types of problem.
Interrupting programs.
Monitoring values while programs are running.
Using the De-bug and watch windows.
Microsoft Excel VBA Training