CONNECT WITH US!

(02) 8616 8079

0917 113 1154

Head Office: 6F Salustiana D. Ty Tower Paseo de Roxas cor. Perea St. Legaspi Village, Makati City

Philippines

Training Center: 5F National Life Insurance Company Building, 6762 Ayala Avenue, Makati City Philippines

© 2016-2017 Phoenix One Knowledge Solutions, Inc.

MS Excel VBA

DURATION:

16 hours (2 days)

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