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