Microcomputer Applications - Alternative course material in English
Lecture 1 - Word processing basics (Demostration 1)
Lecture 2 - Using and creating styles and templates (Demostration 1 and 2)
Lecture 3 - Index, Table of Contents, References and Word Processing Tools (demostration 2)
Lecture 4 - Mail Merge and Spreadsheet Basics (demostration 3)
Lecture 5 - Cell References, Styles and Functions (demostration 3)
Lecture 6 - Worksheet Functions (demostration 4)
- Refer to the same cell or range on multiple sheets by using a 3-D reference - Microsoft Excel 2000 Help
- Find out from Microsoft Excel 2000 Help what next worksheet functions do
- Math & Trig
- SUM, SUMIF, RAND, PI, PRODUCT
- Statistical
- Information
- ISBLANK
- and the basic idea of information functions
- Financial
- Date & Time
- Lookup and reference
- INDIRECT, COLUMNS, ROWS, INDEX, HLOOKUP, VLOOKUP
- Logical
Lecture 7 - Charts (demostration 5)
Lecture 8 - Spreadsheet tools (demonstration 6)
- Find out from Microsoft Excel 2000 Help what next database functions do
- Database Functions - General Information
- DAVERAGE, DCOUNT, DMAX, DMIN, DSUM, DPRODUCT
- Read the following articles from Microsoft Excel 2000 Help
- About sorting a list
- Ways to find values in a list by using filters
- About PivotTable reports: interactive data analysis
- Add a record to a list by using a data form
- Specify the valid entries for cells
or read the following web articles
Lecture 9 - Macros (demostration 7)
Lecture 10 - Presentation graphic (demonstration 8)
Lecture 11 - Putting It All Together (demonstration 8)