If you often find yourself repeating the same steps in Microsoft Excel, automation can dramatically improve your efficiency. This two-day hands-on course introduces participants to the power of Macros and Visual Basic for Applications (VBA). Participants will learn how to record, edit, and write simple VBA codes to automate repetitive tasks, enhance productivity, and customize Excel functionalities. Through guided practice, they will also explore form controls, create interactive user forms, and automate common Excel objects like PivotTables and Charts. By the end of the course, participants will gain the confidence to apply Macros to their daily workflow, transforming Excel into a smarter, time-saving tool that works for them. This HRD Corp (HRDC) Claimable Course (Previously Known as SBL-Khas) Is Delivered by a Penang-Based Training Provider Registered with HRD Corp (Formerly Known as HRDF), Specializing in Corporate Skills Development and Workforce Upskilling Across Malaysia. 100% HRD Corp Claimable | Penang Training Provider | Corporate Training Malaysia
DAY 1
Module 1: Using Macros
Understanding the usage of Macros
Opening a Workbook containing Macros
Performing Security Settings
Module 2: Recording Macros
Activating the Developer Tab
Recording a Macro
Assigning a Shortcut Key
Selecting Macro storage location
Entering Macro Comments
Assigning Macro to a Button
Running a Macro
Saving a Macro File
Using Relative and Absolute References
Lunch
Continue Module 2
Module 3: Editing Macros
Using the Visual Basic Editor
Editing VBA codes
Deleting and resetting Macros
Understanding Basic VBA codes
Writing simple VBA codes
Mini Project: Enable Auto Load and Run VBA scripts
DAY 2
Module 4: Using a Custom Button
Adding a Custom Button in Quick Access Toolbar
Changing a Button Image
Deleting a Custom Button
Module 5: Adding Form Controls
Creating and formatting Form Controls
Moving, resizing, and copying Form Controls
Using Formulas with Form Controls
Assigning Macros to Controls
Creating a UserForm in Visual Basic Editor
Project: Designing a UserForm
Lunch
Continue Module 5
Module 6: Automating Objects
Automating a PivotTable
Automating a Chart
