Advanced Microsoft Excel for Applied Sciences

Time Table

 

Lesson

Date

Topic and Remark

Lesson 1

23 May 2016 (Monday)

10:00 – 13:00 (HHB-1203)

Outline, Editing and Formatting

Exercise 1, Source File

 

Data Manipulation

Exercise 2, Source File

 

23 May 2016 (Monday)

14:30 – 17:30 (HHB-1203)

Plotting Chart

Exercise 3, Source File

 

Using Formula and Function

Exercise 4, Source File

 

Lesson 2

24 May 2016 (Tuesday)

10:00 – 13:00 (HHB-1203)

Data Analysis and Problem Solving

Exercise 5, Source File

 

Data Interchange and Security

Exercise 6, Source File

 

24 May 2016 (Tuesday)

14:30 – 18:00 (HHB-1203)

Macro and VBA

Exercise 7, Source File