Visual Basic for Applications for Excel

Microsoft Excel VBA Training

Vantage Training Ltd (vtl)
In Nottingham and Timperley

£190
+ VAT
Want to speak to an Advisor about this course?

Important information

Typology Short course
Level Advanced
Location At 2 venues
Duration 1 Day
Start 22/12/2017
other dates
Description

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.

Venues

Where and when

Starts Location Timetable
22 Dec 2017
Nottingham
The Wharf, Trent Lane, East Bridgford,, NG13 8PF, Nottinghamshire, England
09:30 - 16:30
Different dates available
Nottingham
The Wharf, Trent Lane, East Bridgford,, NG13 8PF, Nottinghamshire, England
26 Jan 2018
Timperley
Canal Road, WA14 1TD, Cheshire, England
See map
09:30 - 16:30
Different dates available
Timperley
Canal Road, WA14 1TD, Cheshire, England
See map
Starts 22 Dec 2017
Location
Nottingham
The Wharf, Trent Lane, East Bridgford,, NG13 8PF, Nottinghamshire, England
Timetable 09:30 - 16:30
Starts Different dates available
Location
Nottingham
The Wharf, Trent Lane, East Bridgford,, NG13 8PF, Nottinghamshire, England
Timetable
Starts 26 Jan 2018
Location
Timperley
Canal Road, WA14 1TD, Cheshire, England
See map
Timetable 09:30 - 16:30
Starts Different dates available
Location
Timperley
Canal Road, WA14 1TD, Cheshire, England
See map
Timetable

Frequent Asked Questions

· What are the objectives of 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 it intended for?

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.

· Requirements

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.

· Qualification

vtl certificate of attendance.

· What marks this course apart?

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.

· What happens after requesting information?

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.

Opinions

H
Hayley Holmes
30/10/2016
What I would highlight The thing that I enjoyed most about the course was learning alternate ways for tackling windows, and not feeling you were asking moronic inquiries.

What could be improved N/A.

Would you recommend this course? Yes.
Did this opinion help you? Yes (0)
L
Lynne Allen
30/10/2016
What I would highlight Extremely valuable course, revived my insight, and will be utilized to enhance procedure of utilizing spreadsheets as a part of the working environment.

What could be improved Everything OK.

Would you recommend this course? Yes.
Did this opinion help you? Yes (0)
P
Peta Hyland
30/10/2016
What I would highlight The course was straightforward and carefully fit to suit my necessities.

What could be improved Everything OK.

Would you recommend this course? Yes.
Did this opinion help you? Yes (0)
M
Misia Smith
30/10/2016
What I would highlight The mode of instruction was awesome and the clarifications were great.

What could be improved Nothing bad.

Would you recommend this course? Yes.
Did this opinion help you? Yes (0)
T
Tina Naylor
30/10/2016
What I would highlight The course covered pertinent connection to my part, casual environment, great methodology from the proficient and easy going coach.

What could be improved Everything OK.

Would you recommend this course? Yes.
Did this opinion help you? Yes (0)
See all

What you'll learn on the course

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
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.

Achievements for this centre

2016

Students that were interested in this course also looked at...
See all