Automating Excel using Macros and VBA Programming
Details
YOU CAN JOIN ONSITE IN CUBAO or AT THE COMFORTS OF YOUR HOME VIA ZOOM
Click the "ENROLL NOW” to find Payment Methods (GCash, credit card, bank deposit, etc.)
May 6 and 13, Saturdays, 8:30AM-4:30PM
Onsite:
Registration: Php3,999 per person
EARLY BIRD: Php3,799 per person
INCLUSIONS:
- 1 AM snack
- 1 PM snack
- 1 lunch (fastfood)
- Handouts
- Certificate
- overflowing coffee
- WIFI access
BRING OWN LAPTOP
Where: Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, QC
via Zoom:
Registration: Php3,899 per person
EARLY BIRD: Php3,699 per person
INCLUSIONS:
- PDF handouts
- PDF certificate
****
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 Own 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
- Creating Programs to VBA Events
Outline
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 Own 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
- Creating Programs to VBA Events
Schedules
Sat | 08:30 AM — 04:30 PM |
Platform: Zoom
No. of Days: | 2 |
Total Hours: | 16 |