Click here to send this to a colleague or friend.

Visual Basic for Excel

Microsoft Office version 2010, 2013 and 2016

Modify and manipulate your spreadsheets

Visual Basic for Excel offers delegates a broad understanding of the enhanced capabilities of Excel when using Visual Basic, and will help you confidently modify and manipulate your spreadsheets to suit the enviroment you work in.

Modify and manipulate spreadsheets easily and effortlessly

Visual Basic for Excel version 2010, 2013 and 2016 offers delegates a comprehensive understanding of the enhanced capabilities of Excel when using Visual Basic to modify and manipulate spreadsheets.

At the end of the workshop participants will have the confidence to use Visual Basic within the Excel environment, and instruction in the creation of customised functions will be included.

shadow

Accreditation:

Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.


Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists

 

Front Foot is a Majority Black-Owned Level 2 EME – 125% Recognition

 

shadow
shadow
Register now for this workshop
WHAT WILL BE COVERED ON THIS THREE-DAY WORKSHOP?

Module 1
What is VBA?

  • Understanding VBA and Visual Basic
  • What is Object Orientated Programming
  • Macros and VBA
Module 2
Macros
  • Using Macros
  • Recording Macros
  • Running Macros
  • Adding Macro Buttons to the Toolbar
  • Update Records
  • Run a Report
Module 3
The Visual Basic Editor
  • VBE Environment
  • The Project Explorer
  • The Properties Window
  • The Structure of Visual Basic Code
  • Viewing the Code Created by Macros
Module 4
Creating Subroutines
  • Creating Code
  • Working with Excel’s Objects
  • Using Methods
  • Using Object Properties

Module 5
Decision Making

  • Using IF Statements
  • Using Else and ElseIf Statements
  • Using Select Case Statements
shadow

Module 6
Loops

  • Using Loops to Repeat Code
  • Do Loop
  • For Next Loops
Module 7
Reviewing Your Code
  • Runtime Errors
  • Compile Errors
  • Testing Your Code
  • Debugging Code
  • Using Error Handlers
Module 8
Functions
  • Creating Functions
  • Referencing Functions
  • Using Functions in Excel
Module 9
User Forms
  • Creating User Forms
  • The Properties Window
  • Adding Components to a Form
  • Using a Naming Convention
  • Adding Code to a Form
shadow shadow

Who should attend?

  • Any business person who uses Microsoft Excel and would like to get the maximum benefit from this software
  • Executives who work with finance and financial projection
  • Executive Secretaries and Personal Assistants

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

shadow
Front Foot courses are compiled and presented by subject matter experts
and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training
Event Information:
Date: 21st 22nd & 23rd January 2019 at Birchwood Hotel & OR Tambo Conference Centre

6th 7th 8th February 2019 at Benvenuto Conference in Randburg

12th 13th 14th March 2019 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

Map: View map
Duration: 3 Days
Cost: R7 050.00 excl VAT
R8 107.75 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.
shadow
Discount:

10% discount for two or more delegates

10% discount if you attend two or more workshops

15% discount for four or more delegates


In-house at your offices
25%
discount for 5 or more delegates

30% discount for 8 or more delegates

35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions

shadow

Bookings:

Contact Adele on
011 867 7299 or email

Bookings and Enquiries
Website | Email

Screenshot: http://images.frontfoot.com
shadow
Microsoft workshop presenters are Certified Microsoft Office Specialists
We offer on-going email support after attending any Microsoft workshop for an unlimited period of time

Workbooks and workshops are aligned to the prevailing Unit Standard;
Front Foot provide business training to business people;
Training is held at premium training venues