|
Week
|
Topics
|
Study Metarials
|
|
1
|
Introduction to MS Office programs
|
K1.Lecture Note
|
|
2
|
Basic Excel operations
|
K1.Lecture Note
|
|
3
|
Data and table operations with Excel
|
K1.Lecture Note
|
|
4
|
Introduction to formulas in Excel
|
K1.Lecture Note
|
|
5
|
Formulas and applications in Excel 1
|
K1.Lecture Note
|
|
6
|
Formulas and applications in Excel 2
|
K1.Lecture Note
|
|
7
|
Intoduction to macros in Excel 1
|
K1.Lecture Note
|
|
8
|
Intoduction to macros in Excel 2
|
K1.Lecture Note
|
|
9
|
Macro operations in Excel 1
|
K1.Lecture Note
|
|
10
|
Macro operations in Excel 2
|
K1.Lecture Note
|
|
11
|
Basic Access operations
|
K1.Lecture Note
|
|
12
|
Database operations with Access commands 1
|
K1.Lecture Note
|
|
13
|
Database operations with Access commands 2
|
K1.Lecture Note
|
|
14
|
Visual reporting with Powerpoint program
|
K1.Lecture Note
|