Advanced Microsoft Excel

Time Table

 

Lesson

Date

Topic and Remark

Lesson 1

23 January 2018 – Tuesday

19:00 – 22:00 (P116)

Outline, Editing and Formatting

Exercise, Source File

 

Data Manipulation

Exercise, Source File

 

Lesson 2

24 January 2018 – Wednesday

19:00 – 22:00 (P116)

Plotting Chart

Exercise, Source File

 

Lesson 3

25 January 2018 – Thursday

19:00 – 22:00 (P116)

Using Formula and Function

Exercise, Source File

 

Lesson 4

30 January 2018 –Tuesday

19:00 – 22:00 (P116)

Data Analysis and Problem Solving

Exercise, Source File

 

Lesson 5

31 February 2018 – Wednesday

19:00 – 22:00 (P116)

Collaborating and Security

Exercise, Source File

 

Lesson 6

1 February 2018 – Thursday

19:00 – 22:00 (P116)

Macro and VBA

Exercise, Source File