Advanced Microsoft Excel

Time Table

 

Lesson

Class A

(BSc)

Class B

(MSc)

Topic and Remark

1

19 January 2021 – Tuesday

19:00 – 22:00 (P116)

23 January 2021 – Saturday

10:00 – 13:00 (P116)

Outline, Editing and Formatting

Exercise, Source File

 

2

21 January 2021 – Thursday

19:00 – 22:00 (P116)

23 January 2021 – Saturday

14:00 – 17:00 (P116)

Data Manipulation

Exercise, Source File

 

3

26 January 2021 – Tuesday

19:00 – 22:00 (P116)

6 February 2021 – Saturday

10:00 – 13:00 (P116)

Plotting Chart

Exercise, Source File

 

4

28 January 2021 – Thursday

19:00 – 22:00 (P116)

6 February 2021 – Saturday

14:00 – 17:00 (P116)

Formula and Function

Exercise, Source File

 

5

2 February 2021 – Tuesday

19:00 – 22:00 (P116)

20 February 2021 – Saturday

10:00 – 13:00 (P116)

Problem Solving

Exercise, Source File

 

6

4 February 2021 – Thursday

19:00 – 22:00 (P116)

20 February 2021 – Saturday

14:00 – 17:00 (P116)

Data Analysis and Collaboration

Exercise, Source File

 

7

9 February 2021 – Tuesday

19:00 – 22:00 (P116)

 

6 March 2021 – Saturday

10:00 – 13:00 (P116)

Macro and VBA

Source File