I147-1-A: Advanced Microsoft Excel

Time Table

Week	Lesson	Class A	Class B	Topic and Remark
Week 1	Lesson 1	8 February 2011 – Wednesday 19:30 – 21:30 (M403)	9 February 2011 – Thursday 19:30 – 21:30 (M403)	Outline, Editing and Formatting Technique Exercise 1, Source File
Week 2	Lesson 2	15 February 2012 – Wednesday 19:30 – 21:30 (M403)	16 February 2012 – Thursday 19:30 – 21:30 (M403)	Sorting and Filtering Technique Exercise 2, Source File
Week 3	Lesson 3	22 February 2012 – Wednesday 19:30 – 21:30 (M403)	23 February 2012 – Thursday 19:30 – 21:30 (M403)	Plotting Graph Exercise 3, Source File
Week 4	Lesson 4	29 February 2012 – Wednesday 19:30 – 21:30 (M403)	1 March 2012 – Thursday 19:30 – 21:30 (M403)	Using Formula and Function Exercise 4, Source File
Week 5	Lesson 5	7 March 2012 – Wednesday 14 9:30 – 21:30 (M403)	8 March 2012 – Thursday 19:30 – 21:30 (M403)	Data Analysis and Problem Solving Technique Exercise 5, Source File
Week 6	Lesson 6	14 March 2012 – Wednesday 19:30 – 21:30 (M403)	15 March 2012 – Thursday 19:30 – 21:30 (M403)	Macro and VBA Exercise 6, Source File