To make a booking, call
01-6390050

MS Excel Macros and VBA

Please call us for details - 01-6390050
Available as in-house training
2 days
Purpose: 

In summary the Trigraph MS Excel Macros and VBA training course will enable participants to save time. It will also improve their understanding of how the MS Excel Macros and the Excel VBA Language can be used to improve their productivity when using MS Excel specifically for the manipulation and extrapolation of data. The course is designed to give an all-round introduction to understand working with Macros in MS Excel; thereby providing the stepping stone to take advantage of the amazing time and money saving potential offered by MS Excel VBA Macros.

This 2-day course is designed to give users an understanding of Macros and an Introduction to the Excel VBA language within MS Excel; while also exploring the advantages of using a powerful electronic spreadsheet.

The course is entirely 'hands on', so those attending will get practice in using advanced features of MS Excel to manage, automate and customise workbooks.

 

 

Suitable for: 

This course is suitable for those people who want to expand and improve their knowledge of MS Excel to enable them to Create Macros which will save time when using repetitive tasks in MS Excel.

The course is aimed at people who have been using Excel for some time and are confident of using the MS Excel at an Advanced level on a day to day basis.

What’s good about the course? : 

Learn by doing – in additional to the formal presentations from Trigraph, attendees will benefit by using the MS Excel software itself on their own dedicated PC / Laptop. They will learn using either generic data files or their own in-house data files.

All of our trainers are mature business management professionals who are educated to 3rd / 4th level and they have Accredited Microsoft Excel Expert Certification. They are also experienced course presenters.

The training materials are fully owned by Trigraph which means we have full flexibility to tailor the content to suit particular client requirements.

On completion of this course, delegates will be able to:

  • Understand when to create a macro
  • Learn the basics of MS Excel VBA
  • Learn to Create, Save, Run, Test, Edit and Debug their own Macros
  • Use Macros and VBA for improved efficiency

Objectives:

On completion of this course, delegates will be able to:

  • Understand when to create a macro
  • Learn the basics of MS Excel VBA
  • Learn to Create, Save, Run, Test, Edit and Debug their own Macros
  • Use Macros and VBA for improved efficiency

Benefits:

There are benefits to using MS Excel more efficiently:

  • Learn to simplify work with MS Excel by automating many repetitive tasks that are part of MS Excel Spreadsheets
  • Become more productive when using MS Excel
  • Do more work in less time with the assistance of MS Excel Macros and VBA
  • Extrapolate relevant information more efficiently
  • Produce accurate Management Reports faster
  • Highlight data inconsistencies more clearly
  • Highlight data patterns more clearly.
  • Learn more efficient ways to use MS Excel in your work environment

It is during the manipulation and extrapolation of data that the functionality of MS Excel will become apparent.

This is a practical hands-on course – “learn by doing” with access to MS Excel software for the course duration

Detailed Content:

Introduction & Understanding the VBA screen

  • Visual Basic Editor
  • Project Explorer Window
  • Code Window
  • Properties Window
  • Printing a Visual Basic Module
  • Create and Edit VBA code
  • What is Macro Code
  • Recording & Running a Macro
  • Relative versus Absolute Recording References

Assigning Macros to Buttons and Objects

  • Assigning a Macro to a Drawn Object on a Sheet
  • Assigning a Macro to a Button on the Quick Access Toolbar
  • Creating a Tab
  • Customising a Tab

Documentation

  • Inserting Comments

Objects/Methods/Properties

  • Range and Offset
  • Flexible Ranges

Workbooks and Sheets

  • How to Activate a Workbook or Worksheet
  • How to Select a Cell
  • Create Your Own User Functions
  • Create, Edit and Test your own Functions

Structured Programming

  • Calling Sub Procedures and Functions

Variables

  • Dim
  • Data Types

Control Structures

  • IF…Then…ElseIf…Else…End If
  • DO...Until…Loop
  • FOR…Next
  • Select Case…Case is…Case Else…End Select

User Interfaces

  • InputBox
  • MsgBox

Debugging &  Error trapping

  • Syntax versus Logic Errors
  • Tracing Errors Step By Step
  • BreakPoint Error Checking
  • Error Handling

Making Macros to do the following Automatically

  • Sort Data
  • Filter Data
  • Pivot Table Reports
  • Insert, Delete, Hide Rows/Columns
  • Insert Data
  • Format, Copy, Delete Data
  • Automate Charts
  • Printing Variable Selected Data

Working with Your Own Data

  • Create and Edit Macros that Saves Time for yourself!
  • Run/Test that the Macro does what it’s supposed to do!
  • Save the Macro for repeated use by you or others!