This three-day course is designed for people who are looking to use Macros and Visual Basic for Applications to automate Microsoft Excel making it easier for you or your end-users to operate. It covers the minimum skills required to get the best out of programming Excel. Each delegate will carry out various practical exercises during the course, which involves them working through examples of each subject covered.
This course is suitable for all versions of Microsoft Excel.

Learn how to:

• Use Visual Basic for Applications editor
• Record macros
• Work with and refer to objects
• Use the Excel object model
• Program worksheets and workbooks
• Work with VBA language concepts
• Declare different data types
• Use commands and statements
• Use variables and constants
• Program event procedures
• Control program flow with conditional constructs and looping
• Create your own procedures and functions
• Work with scope and lifetime of variables to minimise programming project effects
• Interact with user
• Create your own forms and dialogues
• Use error handling and debug code

Who would benefit from the course?

This course is designed for Excel users who wish to give more functionality to users and improve automation of tasks within Excel.

Pre-requisites

A good understanding of Excel as a user.