Microsoft Excel 2016 VBA Training Course

Microsoft Excel 2016 VBA Training

Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.

For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!

Please select the level that you’re interested in

Microsoft Excel 2016 VBA

Course Overview

Audience:

This course is aimed at experienced Excel users who need to automate repetitive tasks or simplify more complex tasks using macros and VBA.

Prerequisite:

You must be proficient with Excel and understand key concepts of spreadsheets, or equivalent to our advanced course level.

Duration:

This is a 2 day MS Excel VBA Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Microsoft Excel VBA course can be run at our training venue near Liverpool Street  (London) or any preferred location in the UK or Europe.

Price:

This course is £ 725 per day + VAT for up to 8 people.

Excel 2016 VBA Course Outline

THE CONCEPT, RECORD AND RUN MACROS & THE VB ENVIRONMENT

The Project Window

Code Window

Properties Window

Navigating between Excel and the VB Editor Editing Code + Methods of Executing

Using the Visual Basic Editor

Structure of a sub routine

Key Words

Navigate a Module

Edit a module

Use of Function Keys

Run subroutines together

Menu, Visual Basic Toolbar, Keyboard Shortcut, Custom Toolbar Button, Custom

Menu Item, Forms Toolbar executing Visual Basic Language Rules

Theory of Object

Properties and Methods

Active Objects

Object Model Hierarchy

Inheritance Control Structures

IF, Nested IF

AND OR NOT

SELECT CASE

Inbuilt Functions

Distribution, Watch Pane

Step through Functions using the immediate Window

LOOPING STRUCTURES

Do Loops

For Next Loops

For Each Next Loops Interactive Macros

Using a Msgbox

Use a Conditional Message Box

Use the Inputbox

CREATE INTERACTIVE FORMS

Build Form Controls

Build User forms

Use of the Properties Window

Combo box

Radio Buttons

Group box

Check box

Built in Dialog Boxes

Create Custom Menus

Create Custom Toolbars

EVENTS

What are Event Procedures?

On Open event

Before Close event

On Activate event

On Deactivate event

On Key event

On Time Event Security

Protect/lock code for view/edit

Digital Signatures

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.