The latest version of Microsoft Office is 2019/O365 but the earlier formats - 2016, 2013 are 2010 - are still very much to be found in offices and homes throughout the UK and abroad.  Microsoft, however, has now ceased to provide support for Office 2007, 2003 and Windows XP.  The table below displays the icons that represent the different applications available in Microsoft Office.  Click on an icon to see more details, such as course outlines and main features.


For the everyday user, each version provides all of the basics for that particular Office application but you will see the new releases add a little more functionality to its predecessor.  All course outlines can be download as a PDF file; simply click on the appropriate logo to open up a new window, read about the course and download the outlines.

Word with text.jpg
Excel with text.jpg
PowerPoint with text.jpg
Outlook with text.jpg
SharePoint with text.jpg
Visio with text.jpg
Publisher with text.jpg
OneNote with text.jpg
Access with text.jpg
Project with text.jpg

Microsoft Excel Level 4

Microsoft Excel training throughout the UK, including Manchester, Leeds, Birmingham, York, Carlisle, Newcastle, Sheffield, Glasgow, Edinburgh, Aberdeen, Derby, Norwich, Portsmouth, Swansea, Cardiff, Chester.  For overseas training and contracts, please call to discuss your requirements.

Microsoft Excel Level 4 (VBA) – Course Outline

About This Course

This course is designed for delegates who want to automate common worksheet tasks, convert worksheets into forms and understand Microsoft Excel VBA code.


Target Audience

Thorough knowledge of Excel is required, gained either by previous experience or by attendance on a Microsoft Excel Level 3 course.


At Course Completion

After completing this course, students will be able to:


  • Understand what a macro does

  • Assign macros to buttons and sheets

  • Edit a macro

  • Work with the range object

  • Work with workbooks and sheets

  • Understand Objects, Properties and Methods

  • Use control structures

  • Customise the toolbar and display

  • Understand debugging and error trapping

  • Work with worksheet and workbook events

  • Work with procedures

  • Understand macro naming conventions


Course Content


Unit 1 - Introduction

  • What is a macro?

  • Recording a macro

  • Running a macro

  • Relative references


Unit 2 - Assigning Macros

  • To a button on a sheet

  • To a drawn object on a sheet

  • To a button on a toolbar


Unit 3 - Editing Macros

  • The VB editor and the project explorer

  • The code window

  • Procedures

  • Inserting comments

  • Printing a VB module


Unit 4 - The Range Object

  • The cells property and range property

  • Flexible ranges

  • Range contents


Unit 5 - Workbooks and Sheets

  • Activating a workbook and worksheet

  • This workbook


Unit 6 - Objects, Properties and Methods

  • Controlling objects with properties

  • Performing actions with methods

  • Performing multiple actions on an object


Unit 7 - Variables and Constants

  • Variables and data types

  • Constants


Unit 8 - Control Structures

  • Conditional control structures

  • Looping control structures

  • Non-structured statements

  • Sub procedures


Unit 9 - Controls, Dialogue Boxes and Forms

  • Built-in dialogue boxes

  • Predefined dialogue boxes

  • Custom forms and worksheet forms

  • User-defined forms

  • Adding form controls

  • Form control properties

  • Control and dialogue box events

  • Displaying and dismissing a user form

  • Handling form controls


Unit 10 - Toolbars and Display

  • About toolbars and menus

  • Customised toolbars

  • Display


Unit 11 - Debugging and Error Trapping

  • Stepping

  • Error handling


Unit 12 - Worksheet and Workbook Events

  • Worksheet object events

  • Workbook object events


Unit 13 - Function Procedures

  • User-defined functions


Unit 14 - Appendix – Naming Conventions

  • User form controls



Course duration: one day


Word with text.jpg
Visio with text.jpg
Excel with text.jpg
Publisher with text.jpg
PowerPoint with text.jpg
OneNote with text.jpg
Outlook with text.jpg
Access with text.jpg
Project with text.jpg