CS08204-082-11: Advanced Microsoft Excel

Time Table

 

Week

Lesson

Date and Time

Topic and Remark

Week 1

Lesson 1

24 February 2009 – Tuesday

19:30 – 21:30 (S1101)

Editing and Formatting Technique

Outline, Exercise 1

Week 2

Lesson 2

03 March 2009 – Tuesday

19:30 – 21:30 (S1101)

Sorting and Filtering Technique

Exercise 2, Source File

Week 3

Lesson 3

10 March 2009 – Tuesday

19:30 – 21:30 (S1101)

Plotting Graph

Exercise 3, Source File

Week 4

Lesson 4

17 March 2009 – Tuesday

19:30 – 21:30 (S1101)

Using Formula and Function

Exercise 4, Source File

Week 5

Lesson 5

24 March 2009 – Tuesday

19:30 – 21:30 (S1101)

Data Analysis and Problem Solving Technique

Exercise 5, Source File

Week 6

Lesson 6

31 March 2009 – Tuesday

19:30 – 21:30 (S1101)

Macro and VBA

Exercise 6, Source File