- International Fees
International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Course Overview
This intensive hands-on seminar builds on top of COMP 0269 or COMP 2364. Those with prior knowledge of MS Excel are shown how to increase productivity by creating macros to automate routine procedures. Students work through a variety of real-life examples to acquire the skills to create and modify macro procedures. Exercises include how to standardize document formats, many times without having to write a single line of code. Topics include: examining tools on the Developer tab, creating custom command buttons to execute macro code, and macro security. Reviewing the VBA Editor window to edit basic procedures using VBA (Visual Basic for Applications) is also discussed. Upon completion of COMP 0379 successful students will be able to create macros to control MS Excel and to save time on repetitive tasks. COMP 0379 will be offered once a year in the Fall (September) term.
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of the course, the student will be able to:
- Display the Developer tab.
- Identify and use the Code tools on the Developer tab.
- Use the Macro Recorder to create macros in MS Excel.
- Understand the difference between Relative vs Absolute recording.
- Execute macro functions using shortcut keys.
- Save macros in the current workbook, new workbook or Personal Macro Workbook.
- Create command buttons, attach and execute macros through buttons.
- Understand macro security in workbooks and to enable trusted locations.
- Customize the Ribbon by adding macro procedures onto the Ribbon and onto the Quick Access Toolbar.
- Access the VBA Editor window and examine the VBA code written behind macros.
- Edit basic macro code in the VBA Editor window.
- Write basic VBA procedures.
- Use built-in VBA functions.
Effective as of Spring/Summer 2017
Programs and courses are subject to change without notice.