Excel - Visual Basic

This course is aimed at delegates who have an extensive knowledge of Excel and who need to automate repetitive or complex tasks within a spreadsheet.

Learning Objectives

  • Know and use Standard Good Practices when Coding
  • Understand and Edit Recorded Macros
  • Understand and use Basic VBA
  • Extend the functionality of Code using more advanced VBA
  • Debug code checking for errors
  •  Gather information from the user via Dialog Boxes

Focus

  • Good Practices
  • Macros
  • Visual Basic for Applications
  • VBA Fundamentals
  • Debug Code
  • Dialog Boxes / User Forms

Duration: 1 day

What's New

SIA Group achieves ILM Approved Centre status

SIA Group achieves Institute of Leadership & Management (ILM) Approved Centre status and has a variety of options for accredited and assessed learning programmes.

SIA Group joins together with the Institution of Mechanical Engineers

SIA Group joins together with the Institution of Mechanical Engineers - the fastest growing professional engineering institution in the UK.