本課程介紹Excel VBA的操作以及程式語法，由資料型別、函數以及樞紐分析的使用，並透過期未專題制作，提昇學生解決問題能力、實務應用能力、團隊合作能力以及知識整合能力，達到學以致用的目標。This course introduces the operation and programming syntax of Excel VBA, including the use of data types, functions and pivot analysis, and through the production of final topics, it improves students' problem-solving abilities, practical application abilities, teamwork abilities and knowledge integration abilities to achieve learning goals. for practical purposes.
Introduce the basic concept of computing systems. Topics include computer hardware, system software, application software and computer network
introduce the BASIC concept of computing systems. topics include computer hardware, system software, application software and computer network
1. Excel 2016 高效實用範例必修16課，文淵閣工作室，碁峰資訊股份有限公司。ISBN:9789864762583
2. 跟我學Excel VBA：從入門變高手，江高舉，碁峰資訊股份有限公司。ISBN：9789864760398
3. Excel VBA：基礎必修課（適用Excel 2010/2013/2016），張志成、吳明哲。碁峰資訊股份有限公司。ISBN：9789864763948
4. 超簡單的Excel巨集&VBA，門脇香奈子，許郁文譯，旗標出版。ISBN: 9789863124177
5. Excel 2010嚴選教材，楊世瑩，碁峰資訊股份有限公司。ISBN: 9789862761434
6. 會計人的Excel VBA小教室，贊贊小屋，碁峰資訊股份有限公司。ISBN: 9789864764150
1. 16 Compulsory Courses on Excel 2016 Efficient and Practical Examples, Wenyuange Studio, Qifeng Information Co., Ltd. ISBN:9789864762583
2. Learn Excel VBA from me: from beginner to master, Jiang Gaoju, Qifeng Information Co., Ltd. ISBN: 9789864760398
3. Excel VBA: Basic compulsory course (applicable to Excel 2010/2013/2016), Zhang Zhicheng, Wu Mingzhe. Qifeng Information Co., Ltd. ISBN: 9789864763948
4. Super simple Excel macro & VBA, translated by Kanako Kadowaki, translated by Xu Yuwen, published by Banner. ISBN: 9789863124177
5. Excel 2010 carefully selected textbooks, Yang Shiying, Qifeng Information Co., Ltd. ISBN: 9789862761434
6. Excel VBA classroom for accountants, Zanzan House, Qifeng Information Co., Ltd. ISBN: 9789864764150
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 實作實作 Implementation |
20 | |
| 期中考期中考 midterm exam |
25 | |
| 期末專題報告期末專題報告 Final special report |
25 | |
| 平時成績(含出席及參與)平時成績(含出席及參與) Daily results (including attendance and participation) |
30 | 無故缺席一次扣20分 |
