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.
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.
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