Prerequisites
To appreciate and take full advantage of these courses, users must be familiar with recording and editing basic macros in Excel who want to go further in automating and customizing Excel using VBA – Visual Basic for Applications. No previous programming experience is required but an expert level of Excel use is assumed.
Course Description
Visual Basic for Applications or VBA enables you to automate activities in Excel such as generating reports, preparing charts and graphs, doing calculations, etc. This automation activity is also often referred to as Macro which helps users save time by automating repetitive steps.
This 2-day instructor-led training will equip you with the skills to apply VBA programming to create more interactive and fully functional spreadsheets.
Course Objectives
Upon completion of this course, participants will be able to:
-
Understand the Excel object model and VBA concepts.
-
Learn and create procedures in VBA.
-
Create custom forms with an assortment of controls.
-
Write code to manipulate Excel objects.
-
Write a variety of error handling routines.
Who Should Attend
Data analysts, business managers, BI professionals or anyone who wish to develop further their MS Excel skills or would like to know more how to automate repetitive steps in Excel.