MS Excel Expert - Part 4
Description
Creating Macros and Forms
This capstone course introduces automation through macros and VBA, helping you streamline repetitive tasks and standardize data collection across projects. You’ll learn how to create and edit macros, understand the VBA environment, and make safe modifications to code. In addition, participants will design interactive forms with buttons, dropdowns, and checkboxes—bringing a new level of efficiency and professionalism to data entry and reporting. By mastering these tools, you’ll transform Excel into a customized solution that saves time and improves consistency in every aspect of your work.
• Macros
- Creating Macros
- Reviewing the VBA
- Understanding modules
- Compiling VBA script in compiled macros
- Making minor edits within VBA code
• Building Forms
- Add form controls
▪ Buttons,
▪ Check boxes
▪ Dropdown menus
▪ Scroll buttons
- Setting edit permissions
- Assigning calculations and macros to forms
Delivery Method: Virtual Session – Zoom Meetings
Course Fee Includes: Access to the course, course materials, and a digital certificate upon completion.
This course is delivered in partnership with local and provincial construction associations across Canada. You will be participating with a group of industry peers from multiple regions.
Sharing a single registration between two or more individuals is not permitted. Please register each person that will be in attendance.