Excel -Macros from A-Z with VBA

Summary

This course refreshes the skills of Advanced users of Excel on the basics of Macros, then builds on the knowledge of participants to enable them to create, vet and edit Macros effectively and accurately using VBA.

Venue details:  
Dublin, Professional Training, Unit 22 Westland Square, Pearse Street, Dublin
Start date & time:  
19 November 2019 09:30
End date & time:  
19 November 2019 17:00
Price: €468.75  (€375.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
12.00
CPD hours:  
7.00
Speaker details
First nameLast name
Damien O'Neill

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend

Advanced Excel users who still find there is more they would like to be able to do, to make Excel work for them. This course gives the skills needed by accountants to make the best use of Macros using VBA.

Course overview

  • Recording, Playing and Editing Macros
  • Macro Security
  • The Fundamentals of Excel VBA & The Visual Basic Editor
  • Interacting with the User - what are Objects?
  • Excel Worksheet Functions in VBA
  • Dates and Times
  • String & Financial Functions
  • Conditional Statements
  • User Defined functions and Sub Procedures:
  • Debugging and Error Handling
  • UserForms - Creating UserForms, Texboxes, Comboboxes & CheckBoxes
  • Using the Excel Forms toolbar

Key learning outcomes

By the end of this course, participants will be able to:

  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros
  • understand the Excel object model and VBA concepts
  • work effectively with the main features of the VBA Editor window
  • create procedures in VBA
  • create and use variables
  • create and work with user-defined functions in VBA
  • create code to drive a user form
  • create procedures that start automatically
  • write a variety of error handling routines

Speaker Bio

Professional Training is a group of experienced specialists providing focused training in IT and Management skills. Our trainers use a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation by our course participants. We have delivered a range of CPD programmes with Chartered Accountants Ireland since 1997. Website: www.professional.ie