MS Excel: Macro Recording and VBA Programming - 2 Days
Details
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.
You need to join both days. The fee mentioned is fee for both days already.
IMPORTANT DETAILS:
- Certificates will be provided.
- Handouts and workfiles included.
- Bring your own laptop. Practice files will be emailed before the training. (You can ask us about our laptop rental service if you cannot bring a laptop.)
- Coffee, PM snacks, and candies included.
- Lunch included.
- Tax included.
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 us 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
- What 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
- Understanding VBA Syntax
- Different Ways of Calling Cells
- Creating Basic Modules
- Objects, Properties, and Actions
- Dealing with Rows, Columns, and Sheets
- Declaring 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
Schedules
Thu, Fri | 09:00 AM — 04:00 PM |
Wed, Thu | 08:00 AM — 05:00 PM |
No. of Days: | 2 |
Total Hours: | 16 |
Insights Manila (registered as Insights MLA Business Solutions) is a training services company based in Makati. The company believes that the country’s workforce requires ample training that is effective and insightful, yet affordable.
The consultants of Insights Manila are experienced professionals who had executed the courses several times for different companies under various training institutions.
Insights Manila mostly offers exclusive training for companies. The courses are customized to meet specific training needs. The company also offers public classes where individuals can enroll, and one-on-one training for people who wish focused training. Other than training, the company also accepts Excel automation projects and course development projects.
With Insights Manila, you are directly dealing with the consultants– no intermediary parties who just add costs to the training delivery.