Advanced Microsoft Excel

Time Table

 

Lesson

Round 1

Round 2

Round 3

Topic and Remark

Lesson 1

10 March 2018 – Saturday

10:30 – 13:00 (S1101)

24 March 2018 – Saturday

10:30 – 13:00 (S1101)

14 April 2018 – Saturday

10:30 – 13:00 (S1101)

Outline, Editing and Formatting

Exercise 1, Source File

 

Validation, Filtering and Consolidation

Exercise 2, Source File

 

10 March 2018 – Saturday

14:30 – 17:00 (S1101)

24 March 2018 – Saturday

14:30 – 17:00 (S1101)

14 April 2018 – Saturday

14:30 – 17:00 (S1101)

Plotting Chart

Exercise 3, Source File

 

Lesson 2

17 March 2018 – Saturday

10:30 – 13:00 (S1101)

7 April 2018 – Saturday

10:30 – 13:00 (S1101)

21 April 2018 – Saturday

10:30 – 13:00 (S1101)

Using Formula and Function

Exercise 4, Source File

 

17 March 2018 – Saturday

14:30 – 17:00 (S1101)

7 April 2018 – Saturday

14:30 – 17:00 (S1101)

21 April 2018 – Saturday

14:30 – 17:00 (S1101)

Data Analysis and Problem Solving

Exercise 5, Source File