Advanced Microsoft Excel

Time Table

 

Lesson

Date

Topic and Remark

Lesson 1

16 January 2016 – Monday

19:00 – 22:00 (P116)

Outline, Editing and Formatting

Exercise, Source File

 

Data Manipulation

Exercise, Source File

 

Lesson 2

17 January 2016 – Tuesday

19:00 – 22:00 (P116)

Plotting Chart

Exercise, Source File

 

Lesson 3

19 January 2016 – Thursday

19:00 – 22:00 (P116)

Using Formula and Function

Exercise, Source File

 

Lesson 4

26 January 2016 –Thursday

19:00 – 22:00 (P116)

Data Analysis and Problem Solving

Exercise, Source File

 

Lesson 5

7 February 2016 – Tuesday

19:00 – 22:00 (P116)

Collaborating and Security

Exercise, Source File

 

Lesson 6

9 February 2016 – Thursday

19:00 – 22:00 (P116)

Macro and VBA

Exercise, Source File