₱2,356.48 – ₱3,073.98

Macros and VBA Programming - 2 Days

Event Information

Share this event

Date and Time

Location

Location

The Workshop

2F Victoria Station I

EDSA

Quezon City, NCR

Philippines

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Friends Who Are Going
Event description

Description

This is a 2-day Training: Nov 18 and 25, 9AM-4PM

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.

Email: inquire@insightsmanila.com

SMS: 0977.103.1800

Topics:

1. Macros

  • Recording Macros
  • Assigning Macros to Objects
  • Relative References
  • Making Macros Permanent

2. Introduction to VBA

  • The Visual Basic Editor
  • Essential Codes

3. Logical Structures

  • IF
  • ELSEIF

4. Loop Structures

  • DO UNTIL
  • FOR NEXT
  • FOR EACH NEXT

5. Userforms

  • Creating basic userforms
  • Automating userform actions

6. Functions

  • Using VBA Functions
  • Using Excel Functions in VBA
  • User-Defined Functions

7. Error Handling

IMPORTANT DETAILS:

  • Certificates will be provided.
  • Handouts and workfiles included.
  • Bring your own laptop. Practice files will be emailed before the training. (You can ask us about our laptop rental service if you cannot bring a laptop.)
  • Coffee, PM snacks, and candies included.
  • Lunch included.
  • Tax included.
Share with friends

Date and Time

Location

The Workshop

2F Victoria Station I

EDSA

Quezon City, NCR

Philippines

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved