logo

Request Quotation

(02) 7-902-0992 / (+63) 917 6247037

(+63) 917 8034085

Course Description


This course is designed for professionals who would like to start exploring the use of Excel VBA and Macros as a powerful tool in creating reports, forms, and dashboards.

The facilitator will start by explaining the programming basics to ensure the participants are aware of the terms being used, such as variables, constants, and operators. Then there will be a discussion on the Developer tab, which will concentrate on VBA, Macro Recorder, and using Relative references. An in- depth discussion on the basics of VBA Programming, VBA Conditional Statements, VBA Loops Statements, and Forms.

The course will then keep you engaged by providing a combination of lectures, course notes, take-away templates, quizzes, exercises, and even homework. Also, this is an excellent opportunity to add practical Excel focus to what you learn in the program.


Course Objectives


At the end of this four-day course, participants will learn the following:
  1. Learn programming basics
  2. Learn the use of Excel VBA, Macro Recorder, and Relative References
  3. Introduce VBA Programming
  4. Use Conditional and Loops Statements
  5. Use the most useful VBA Objects
  6. Able to use and code Excel VBA and Macros

Course Modules


To achieve these objectives, Advanced Learning Programs (ALPs) will use the below Lesson Plan:
Lesson 1 - Programming Basics
  1. Variables and constants
  2. Operators
  3. Programming Logic
Lesson 2 - Introduction to VBA
  1. Excel VBA
  2. Macro Recorder
  3. Absolute vs. Relative Reference
Lesson 3 - Basics of VBA Programming
  1. VBA Environment
  2. Excel VBA Variables
  3. Range, Cells, Active Cells
  4. VBA Worksheets and Workbooks
  5. Introduction to Functions
Lesson 4 - VBA Conditional Statements
  1. IF-Then-Else
  2. Select Case Statement
Lesson 5 - VBA Loops Statements
  1. Do While and Do Until Loop Statement
  2. For Loop Statement
Lesson 6 - VBA Message Box and Input Box
  1. Message Box
  2. Input Box
Lesson 7 - Introduction to Forms
  1. Introduction to Forms
  2. Basic Objects – Forms, Buttons, Text Boxes, Combo Box
  3. ActiveX Control

- Flexible length - sessions as short as 1-hour
- Cost effective - great group pricing
- Greatest impact in the shortest time
- Excellent Team Building Opportunity
- Certificate of Completion

Request Quotation

Download the course PDF now!

Fullname

E-mail

Course