Advanced Microsoft Excel

Time Table

 

Lesson

X4-XT-CDP-0071-A

(Cantonese)

X4-XT-CDP-0071-B

(Cantonese)

X4-XT-CDP-0071-C

(Cantonese)

X4-XT-CDP-0071-D

(Cantonese)

Topic and Remark

Lesson 1

16 May 2016 – Monday

19:30 – 21:30 (M402)

17 May 2016 – Tuesday

19:30 – 21:30 (M402)

18 May 2016 – Wednesday

19:30 – 21:30 (M402)

21 May 2016 – Saturday

10:30 – 12:30 (M402)

Outline, Editing and Formatting

Exercise 1, Source File

 

Lesson 2

23 May 2016 – Monday

19:30 – 21:30 (M402)

24 May 2016 – Tuesday

19:30 – 21:30 (M402)

25 May 2016 – Wednesday

19:30 – 21:30 (M402)

28 May 2016 – Saturday

10:30 – 12:30 (M402)

Validation, Filtering and Consolidation

Exercise 2, Source File

 

Lesson 3

30 May 2016 – Monday

19:30 – 21:30 (M402)

31 May 2016 – Tuesday

19:30 – 21:30 (M402)

1 Jun 2016 – Wednesday

19:30 – 21:30 (M402)

4 Jun 2016 – Saturday

10:30 – 12:30 (M402)

Plotting Chart

Exercise 3, Source File

 

Lesson 4

6 Jun 2016 – Monday

19:30 – 21:30 (M402)

7 Jun 2016 – Tuesday

19:30 – 21:30 (M402)

8 Jun 2016 – Wednesday

19:30 – 21:30 (M402)

11 Jun 2016 – Saturday

10:30 – 12:30 (M402)

Using Formula and Function

Exercise 4, Source File

 

Lesson 5

13 Jun 2016 – Monday

19:30 – 21:30 (M402)

14 Jun 2016 – Tuesday

19:30 – 21:30 (M402)

15 Jun 2016 – Wednesday

19:30 – 21:30 (M402)

18 Jun 2016 – Saturday

10:30 – 12:30 (M402)

Data Analysis and Problem Solving

Exercise 5, Source File

 

Lesson 6

20 Jun 2016 – Monday

19:30 – 21:30 (M402)

21 Jun 2016 – Tuesday

19:30 – 21:30 (M402)

22 Jun 2016 – Wednesday

19:30 – 21:30 (M402)

25 Jun 2016 – Saturday

10:30 – 12:30 (M402)

Macro and VBA

Exercise 6, Source File