Advanced Microsoft Excel for Business

Time Table

 

Lesson

Date

Topic and Remark

Lesson 1

4 June 2016 (Saturday)

14:00 – 17:00 (HHB-1208)

Outline, Editing and Formatting

Exercise 1, Source File

 

Data Manipulation

Exercise 2, Source File

 

Lesson 2

11 June 2016 (Saturday)

14:00 – 17:00 (HHB-1208)

Plotting Chart

Exercise 3, Source File

 

Using Formula and Function

Exercise 4, Source File

 

Lesson 3

18 June 2016 (Saturday)

14:00 – 17:00 (HHB-1208)

Data Analysis and Problem Solving

Exercise 5, Source File

 

Lesson 4

25 June 2016 (Saturday)

14:00 – 17:00 (HHB-1208)

Data Security and Mail Merge

Exercise 6, Source File

 

Macro and VBA

Exercise 7