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 inquire@insightsmanila.com 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

MS Excel Macros and VBA Programming