Office 應用程式如 Excel 等都含有 Visual Basic for Applications (VBA),它是一種程式語言,能讓您具有擴充應用程式的能力。
VBA 以執行「巨集」的方式運作。而所謂的巨集就是使用 Visual Basic 語言撰寫之循序漸進的步驟流程。學習撰寫程式聽起來好像很難,但只要有耐心再配合一些範例 (像是本文中所提供之範例),許多使用者都會發現,即使只學會一點點 VBA 程式碼,都對他們的工作有莫大的助益,讓他們可以在 Office 內達成之前做不到的事。只要您學會一部分的 VBA,要學會其他的就簡單多了。所以之前的不可能的現在都變成可能了。
1. 課程設計的全方位內容,主題涵蓋完整,包括在電腦和行動裝置上執行的應用軟體、app、作業系統、公用程式,還有網際網路、全球資訊網與雲端運算的介紹。
2. Excel VBA
3. MS OFFICE課程設計的全方位內容
透過實作,學生能奠定紮實的電腦知識,更懂得
如何運用電腦和善用全球資訊網,了解科技趨勢發展並建立宏觀的想法。Office applications such as Excel include Visual Basic for Applications (VBA), a programming language that gives you the ability to extend your applications.
VBA operates by executing "macros". The so-called macro is a step-by-step process written in Visual Basic language. Learning to write programs may sound difficult, but with patience and some examples (like the ones provided in this article), many users will find that learning even a little bit of VBA code has a huge impact on their work. With the help of Office, they can achieve things that they could not do before in Office. Once you learn one part of VBA, it's much easier to learn the rest. So what was impossible before is now possible.
1. The course is designed with all-round content and covers a complete range of topics, including application software, apps, operating systems, and utilities that run on computers and mobile devices, as well as an introduction to the Internet, global information networks, and cloud computing.
2. Excel VBA
3. Comprehensive content of MS OFFICE course design
Through practical practice, students can lay solid computer knowledge and better understand
How to use computers and make good use of global information networks to understand the development of technological trends and establish macro-ideas.
1. 講義
2. 第一次學Excel VBA就上手
作者:七條達弘, 渡辺健, 鍛冶優
出版社:碁峰
語言:繁體中文 ISBN:9789863471998
裝訂:平裝
1. Handouts
2. Get started with Excel VBA the first time you learn it
Author: Tatsuhiro Nanijō, Takeru Watanabe, Yu Kagoya
Publisher: Qi Feng
Language: Traditional Chinese ISBN: 9789863471998
Binding: paperback
評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
---|---|---|
作業與專題作業與專題 Assignments and topics |
40 | |
期中考期中考 midterm exam |
30 | |
期末考與期末分組專題期末考與期末分組專題 Final exam and final group topics |
30 |