top of page

Python Course

Simple ~ Easy to use ~ Powerful

 
Excel VBA

什麼是 Excel VBA？為什麼選擇它？

Microsoft Excel是一款被廣泛應用的處理數據的好工具，只需要將數據填入格中，再配上運算指令，數據中蘊藏的答案便會在你眼前呈現，然而當大量數據同時存在時，處理工作難免會變得枯燥繁鎖。

​

Excel VBA 是VBA (Visual Basic for Applications) 的一種，專為Microsoft office 而設的程式語言。只需簡單的指令，它就能幫助你完成數據篩選工作。此外，亦可以錄製數據處理的過程，讓系統下次自動完成，減少繁複的工作流程。

Excel VBA

What will your students learn?

Record macro

Macro is a major function of Excel VBA, which can help us process repeated operations in batches. We will teach how to use macros, including enabling and quickly executing macros, the relationship between macros and Excel VBA, the limitations of macros and their breakthrough methods.

Know common functions

VBA is also a programming language. We will teach the method of writing VBA and its syntax rules, such as basic statement structure and self-defined functions. Let students process data through programming by themselves, and also understand programming logic from it.

Operation object

We will introduce three execution codes   (Display Alerts, Worksheet Function, Application), then explain how to manage workbooks and operate worksheets, and finally introduce the properties of VBA with examples, and gradually deepen students’ understanding of Knowledge of VBA.

Report making

After learning about macros and programming, students will use macro programming to create embedded charts such as histograms, pivot tables, and custom forms to more easily and effectively visualize the meaning and relationships in data.

01. Zero-based learning

Students can start learning Excel VBA without being particularly familiar with the operation of Excel. The course is step by step, easy to understand.

 

02. Learn important skills

Compared with other programming languages such as Java, C and Python, VBA is less well-known, but Excel is a widely used office software, so the VBA course is an important course that is easily overlooked.

 

03. Inspire interest

For students, simple numbers are unavoidably boring, so we attach a lot of examples to illustrate, so that students can build interest while having fun.

 
bottom of page