fbpx

Microsoft Excel – An Introduction to Macros and VBA (Visual Basic)

Course Summary

This half-day course is designed to assist those wishing to build further upon their knowledge of Microsoft Excel and take it to the next level. The content will enable you to progress to maximise efficiency by compiling a Macro to automate repetitive tasks within Excel, using both Recording steps and writing directly in VBA code.

Topics

Understanding the Concepts of Macros and VBA

  • Explain the difference between a Macro and Visual Basic
  • How to record a Macro
  • Where your Macro is recorded
  • Create a Macro using the Macro Recorder to consolidate data
  • Look at the 7 different ways to run your macro including:
    • Keyboard Shortcut
    • Button on worksheet
    • Quick Access Toolbar

Stepping Stones to Writing Efficient VBA Code

  • Look at the significance of when to use an Absolute or Relative reference within a Macro.
  • Analyse the difference in the VBA code and understand the syntax for both Absolute and Relative references.
  • Understand the key elements of the Visual Basic Editor (VBE)
  • Create a new Macro using the Code Window to include Dynamic Cell Selection (Special Cells)
  • Identify and delete superfluous code in a recorded Macro

Visual Basic Essentials

  • Colour guidelines and keyboard shortcuts
  • What the Object Model is
  • Excel Object Library containing code words
  • Object properties
  • Methods in VBA
  • How to find the correct syntax (property or method)
  • Rows, columns and range referencing
  • Cells and offset referencing
  • How to reference worksheets and workbooks
  • Useful built-in functions

Debugging

  • Methods to debug code
  • How and when to use the Immediate Window

Course Benefits

You will learn how to automate repetitive manual tasks thus making huge efficiency savings and eradicating human error.

Tutor Profile

Jacqui Ward is the proprietor and trainer of JW Training, specialising in providing Microsoft application training and business consultancy.

Jacqui is a qualified PRINCE 2 Project Manager and freelance computer software trainer with over 25 years’ experience both in Guernsey and the UK. She has delivered packaged and bespoke training on a corporate, group or one-to-one basis for a variety of major financial companies, the States of Guernsey, Guernsey Electricity and quarterly Excel sessions for the GTA to name just a few.
In previous roles Jacqui has worked as both a marketing director for an international merchant bank and as an IT business solutions manager. Delegate feedback is consistently high, emphasising Jacqui’s ability to draw on her vast experience to deliver training which is targeted on user requirements in her relaxed, friendly and focused style.

Course at a Glance

  • Next Start Date: 6 November 2020
  • CPD Points: 4
  • Course Cost: £225.00
  • Course Length: Half day (09:00-13:00)
  • Location: GTA University Centre, Guernsey
  • Tutor: Jacqui Ward

Prerequisites:

Ideally you will have completed the ‘Advanced’ module or have a good working knowledge of other Excel versions to advanced level.

There are no dates currently available for this course, If you would like to register your interest please complete the form below:

Latest Articles



Latest from Twitter



Want to learn more? Sign up to our mailing list!



We will email you from time to time to update you on upcoming courses, events and conferences.