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