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
- Learn programming basics
- Learn the use of Excel VBA, Macro Recorder, and Relative References
- Introduce VBA Programming
- Use Conditional and Loops Statements
- Use the most useful VBA Objects
- Able to use and code Excel VBA and Macros
Course Modules
- Variables and constants
- Operators
- Programming Logic
- Excel VBA
- Macro Recorder
- Absolute vs. Relative Reference
- VBA Environment
- Excel VBA Variables
- Range, Cells, Active Cells
- VBA Worksheets and Workbooks
- Introduction to Functions
- IF-Then-Else
- Select Case Statement
- Do While and Do Until Loop Statement
- For Loop Statement
- Message Box
- Input Box
- Introduction to Forms
- Basic Objects – Forms, Buttons, Text Boxes, Combo Box
- 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
Download the course PDF now!