Course Overview

Do you use Excel every day for repetitive tasks? Have you ever thought about making your work easier with automation? This course teaches you how to write programs using Excel's own VBA (Visual Basic for Applications) language to handle repetitive or complex processing. You can record all manual operations into a program, letting the computer execute them for you, finding simpler ways to handle daily repetitive work—saving both time and effort.

This course focuses on learning to write Excel VBA programs. It is suitable for individuals who already have a solid understanding of Excel and wish to learn more advanced tools. Regardless of your prior programming experience, this course will guide you step-by-step through understanding program operation, basic syntax, event handling, and more. The goal is to enable participants to write their own Excel programs by the end of the course to speed up daily work tasks.

Course Content

1. Excel VBA Introduction and Applications
2. Macro Recording
3. Writing Methods and Interface Operations
4. Excel VBA Basic Syntax (Objects, Functions, Properties, Collections, etc.)
5. Common Objects and Examples (Workbooks, Worksheets, Application, etc.)
6. Excel VBA Event Handling Applications
7. Typical Case Studies and Practice

Notes

• An attendance certificate issued by Stage (驛站) will be awarded for attendance rates of 70% or higher.
• This course is suitable for individuals who already have a considerable understanding of Excel.
• The computer software used in this course is Microsoft Excel 2010.