Excel進行計算分析是可以寫個程式語言來加速以及進行自動化的工作。本課程就是教學生從事Excel程式的撰寫。課程的內容集中在利用Classical Visual Basic 與Modern Visual Basic 語言進行Excel程式的撰寫。
本課程分成三個部分，第一部份是Excel的基本操作與應用。第二部份是用classic visual basic 來進行Excel Programming。第三部份是Modern Visual Basic Programming, 課堂上也會觸及物件導向程式設計及視窗應用程式的撰寫。第四部份是利用Modern Visual Basic 語言來進行Excel Programming.



Week 1: Introduction
Week 2-4: Excel operation
1. 基本操作, Cell,
2. 定義名稱,
3. 四則運算,
4. Copy and Paste,
5. 相對位址與絕對位址,
6. 內定函數Sin(x), Cos(x), Sum, Average,
7. 繪圖, xy plot(Table Format), 3D Plot(Carpet Format), Isocontour, Dplot.
8. User Defined function (VBA),
9. Find the roots of algebraic equation.
10. Matrix Operations

Week 5 : Excel Programming Examples
1. Numerical method: using Iterative method to solve system of equations
2. Applications of steam table
3. Fourier Series
4. Analytical solution of 1D Heat conduction
5. Finite Difference Method: 1D Heat conduction, 2D Heat transfer Problem.

Week 6-9 Classical VBA Macro
Chapter 3, Terminology , VBA Macro Made Easy
Chapter 4, A Sample Macro
Chapter 5, Using Macro Recorder
Chapter 6, Introduction to Variables
Chapter 7, Introduction to Arrays
Chapter 8, Command Controls
Chapter 9, More on Macros
Chapter 10, Creating Functions
Chapter 11, Debugging your Macros
Chapter 12, Handling Errors
Week 10
1. User Form
2. Textbox, Label, Checkbox, Optional Button, List Box

Week 11-14 Modern Visual Basic (Visual Basic.NET)
1. Control Structures
2. Variables and Operators
3. Arrays
4. Programming Units
5. Object Oriented Programming
6. Windows Applications
Week 15-16 Excel Programming using Modern Visual Basic