Copyright © Optimise Consultancy Ltd

What people think

"Gave me a good knowledge to be able to use this software for work."


Amy Hicks - Trent & Dove Housing.

Microsoft Excel VBA

Level 1
Microsoft Excel
Introduction to Macros

Pre-requisites

Delegates attending this course should be have a good understanding of Excel and be able to open, edit and save files.  They should also be able to use various formula and be able to format spreadsheets.

Course Objectives

By the end of the course users will be able to record and edit basic macros. You will understand where and why macros are stored in specific locations and be able to create a button to activate a macro.

Course Content

Automating Spreadsheets with Macros




Level 2
Microsoft Excel
Macros and Automation

Pre-requisites

Delegates attending this course should be have a good understanding of Excel and be able to open, edit and save files.  They should also be able to use various formula and be able to format spreadsheets.

Course Objectives

By the end of the course users will be able to record and edit basic macros. You will understand where and why macros are stored in specific locations and be able to create a button to activate a macro.  You will be able to edit code and have an understanding of the syntax used in VBA.

Course Content







Level 3
Microsoft Excel
Macro Master Class

Pre-requisites

An advanced understanding of creating spreadsheets and manipulating data in Excel.

Course Objectives

At the end of the course users will be able to understand and create VBA code. You will be able to create procedures, user-defined functions and forms to help automate Excel spreadsheets for End Users.

Course Content

Day 1 Macro Introduction

Day 2 Macro Master Class

On-site and Off-site training  

Training to suit you and your business

Need Help?

Your place or mine?

What do you need?

'The course was excellent, there were areas which I didn't know about.  The Trainer was very helpful.'


Shirley Cole - South Staffordshire Council

Book training with us now.

Course Outlines