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

New courses launched

SIA Group is pleased to announce the introduction of three new courses focussed on building team performance in diverse organisations.

TPD™ Boosts Team Performance

SIA Group‘s TPD™ tool is leading to improvements in team morale, motivation, and performance at the University of Middlesex.