I147-1-A: Advanced Microsoft Excel

Time Table

Week	Lesson	Date and Time	Topic and Remark
Week 1	Lesson 1	24 May 2010 – Monday 19:30 – 21:30 (M407)	Outline, Editing and Formatting Technique Exercise 1, Source File
Week 2	Lesson 2	31 May 2010 – Monday 19:30 – 21:30 (M407)	Sorting and Filtering Technique Exercise 2, Source File
Week 3	Lesson 3	7 June 2010 – Monday 19:30 – 21:30 (M402)	Plotting Graph Exercise 3, Source File
Week 4	Lesson 4	14 June 2010 – Monday 19:30 – 21:30 (M402)	Using Formula and Function Exercise 4, Source File
Week 5	Lesson 5	21 June 2010 – Monday 19:30 – 21:30 (M402)	Data Analysis and Problem Solving Technique Exercise 5, Source File
Week 6	Lesson 6	28 June 2010 – Monday 19:30 – 21:30 (M402)	Macro and VBA Exercise 6, Source File