Advanced Microsoft Excel

Time Table

 

Lesson

Class A

Topic and Remark

Lesson 1

9 November 2019 – Saturday

10:30 – 13:00 (WK-S1102)

Outline, Editing and Formatting

Exercise 1, Source File

 

Validation, Filtering and Consolidation

Exercise 2, Source File

 

9 November 2019 – Saturday

14:00 – 16:30 (WK-S1102)

Plotting Chart

Exercise 3, Source File

 

Lesson 2

16 November 2019 – Saturday

10:30 – 13:00 (WK-S1102)

Using Formula and Function

Exercise 4, Source File

 

16 November 2019 – Saturday

14:00 – 16:30 (WK-S1102)

Data Analysis and Problem Solving

Exercise 5, Source File

Student Feedback Questionnaire