MS Excel Macros and VBA Programming, 24 July | Event in Mandaluyong City | AllEvents

MS Excel Macros and VBA Programming

Insights Training

Highlights

Thu, 24 Jul, 2025 at 08:00 am

Mpower Learning Manila

Starting at PHP 2,624

Advertisement

Date & Location

Thu, 24 Jul, 2025 at 08:00 am - Fri, 25 Jul, 2025 at 05:00 pm (GMT+08:00)

Mpower Learning Manila

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines

Save location for easier access

Only get lost while having fun, not on the road!

About the event

MS Excel Macros and VBA Programming
This training covers the fundamentals of using macros and VBA programming to automate MS Excel.

About this Event

Knowledge of Macros and VBA Programming allows you to automate reports in MS Excel. Generate reports in one click, create tools that will eliminate the manual tasks in your workplace. Know how to record macros, and create modules with Logical, Loop, and Userform structures!


The course requires just at least a basic understanding of MS Excel in order to be appreciated.


INCLUSIONS (if joining in Cubao)

  • 2 snacks per day
  • 1 lunch per day
  • handouts
  • certificate
  • unlimited coffee
  • candies and snacks


INCLUSIONS (if joining via Zoom)

  • PDF certificate
  • PDF handout

Where:

  • Mpower Learning Manila
  • 222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City


TIME

All schedules are set at 8AM-5PM. However, if the headcount is low, the training may be set at 9AM-4PM or 9AM-5PM. Your certificate, still, will indicate 16 hours.The start time and end time will be finalized three days before the class. Please look for an email from aW5xdWlyZSB8IGluc2lnaHRzbWFuaWxhICEgY29t or chat with us to confirm.


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 Programming

  • W hat Automation in Excel Can Do
  • 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
  • D eclaring Variables

Part 4. Building 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
  • U sing Excel Functions to Automate VBA Programs

Part 5. Creating Userforms and Userform Events

  • Adding UserForms
  • Adding Form Elements
  • Creating Programs to VBA Events


Also check out other Workshops in Mandaluyong City.

interested
Stay in the loop for updates and never miss a thing. Are you interested?
Yes
No

Ticket Info

Tickets for MS Excel Macros and VBA Programming can be booked here.

Ticket type Ticket price
Early Bird (Cubao) 5,458 PHP
Early Bird (via Zoom) 4,409 PHP
Join in Cubao 5,983 PHP
Join via Zoom 4,933 PHP
2 for 1 Admission (via Zoom) 2,624 PHP
Advertisement

Nearby Hotels

Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines

Just a heads up!

We have gathered all the information for you in one convenient spot, but please keep in mind that these are subject to change. We do our best to keep everything updated, but something might be out of sync. For the latest updates, always check the official event details by clicking the "Find Tickets" button.

Tickets from PHP 2,624

Host Details

Insights Training

Insights Training

6 Followers

Are you the host? Claim Event

Advertisement
MS Excel Macros and VBA Programming, 24 July | Event in Mandaluyong City | AllEvents
MS Excel Macros and VBA Programming
Thu, 24 Jul, 2025 at 08:00 am
PHP 2,624