May 6 and 13, 2023, 8:30 AM-4:30 PM

Php4000 per pax
EARLY BIRD: Php3900

INCLUSIONS

Two snacks per day
One lunch per day
handouts
certificate
overflowing coffee
WIFI access

BRING OWN LAPTOP– must have MS Excel installed. WINDOWS only.

Where:

Mpower Learning Manila

222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City

OUTLINE

Part 1. Macro Recording

Creating Macros
Exploring Macro Security
Recording and Running a Macro
Using Relative Reference
Assigning a Macro to Buttons
Using Macro Recording to Create VBA Codes

Part 2. Introduction to VBA

Exploring the VBA Interface (Overview)
VBA Terminologies
Exploring the Properties Window
Exploring the Code Window

Part 3. Programming Basics

Essential VBA Codes
Different Ways of Calling Cells
Creating Basic Modules
Objects, Properties, and Actions
Dealing with Rows, Columns, and Sheets

Part 4. Control Structures

Applying Decision Structures
If, Then, Else Statement
If, Then, ElseIf Statement
Solving Repetitive Tasks with Loop Structures
For, Next Loop
For Each, Next Loop
Do Until Loop
Applying Control Structures in Excel Programs

Part 5. Creating Your Functions

Using IF to Create Functions
User-Defined Functions
Using MS Excel Functions in VBA

Part 6. Creating Userforms and Userform Events

Adding UserForms
Adding Form Elements
Developing Programs for VBA Events