Macros and VBA Programming for MS Excel

Insights Training

Date Time: May 6, 2023 | 8:30 am
Time Zone: GMT+8:00 China Taiwan Time

Total Hours

56 Hrs

This training covers the fundamentals of using macros and VBA programming to automate MS Excel.
May 6 and 13, 2023, 8:30 AM-4:30 PM
Php4000 per pax
Two snacks per day
One lunch per day
overflowing coffee
WIFI access
BRING OWN LAPTOP– must have MS Excel installed. WINDOWS only.
Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City
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

About the Event