MS Excel Macros and VBA Programming

Name: MS Excel Macros and VBA Programming
Start: 2024-10-10T09:00:00+08:00
End: 2024-10-11T16:00:00+08:00
Location: 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH

Schedule

Thu Oct 10 2024 at 09:00 am to Fri Oct 11 2024 at 04:00 pm

UTC+08:00

Location

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH | Quezon City, MM

This training covers the fundamentals of using macros and VBA programming to automate MS Excel.
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
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