Advanced Microsoft Excel

Time Table

 

Lesson

Class A

(Cantonese)

Class B

(English)

Topic and Remark

Lesson 1

14 January 2019 – Monday

19:00 – 22:00 (P116)

2 March 2019 – Saturday

10:00 – 13:00 (P116)

Outline, Editing and Formatting

Exercise, Source File

 

Data Manipulation

Exercise, Source File

 

Lesson 2

15 January 2019 – Tuesday

19:00 – 22:00 (P116)

2 March 2019 – Saturday

14:00 – 17:00 (P116)

Plotting Chart

Exercise, Source File

 

Lesson 3

17 January 2019 – Thursday

19:00 – 22:00 (P116)

9 March 2019 – Saturday

09:00 – 12:00 (P116)

Using Formula and Function

Exercise, Source File

 

Lesson 4

22 January 2019 – Tuesday

19:00 – 22:00 (P116)

9 March 2019 – Saturday

13:00 – 16:00 (P116)

Data Analysis and Problem Solving

Exercise, Source File

 

Lesson 5

29 January 2019 – Tuesday

19:00 – 22:00 (P116)

16 March 2019 – Saturday

09:00 – 12:00 (P116)

Collaborating and Security

Exercise, Source File

 

Lesson 6

31 January 2019 – Thursday

19:00 – 22:00 (P116)

16 March 2019 – Saturday

13:00 – 16:00 (P116)

Macro and VBA Programming

Exercise, Source File