 |
 |
|
| . |
.. .. |
... .. |
| . |
| About
| Site Map | Disclaimer | Contact | |
Contact Us
 |
. |
 |
Information
at your fingertips |
| . |
. |
Information Technology |
IT |
| . |
. |
| Welcome to
my MS Excel Page ,
for information, resources and tutorials for lectures JA Chang delivered
at Singapore Genetic Computer School.. |
|
 |
|
- Lessons on Basic Excel
as given by JA Chang at Genetic Computer School are part of the MS Excel 2000 Course content.
Find information on entering text, number and formula. Short introduction to use of IF functions and its use for Grading
are given.
- Tutorials
on MS Excel 2000 will further supplement the lectures as given.
- Comprehensive
Excel 2000 Tutorial pages of guidance and hints
are given at this link.
- Functions and Formulae Links are given for your reference
- Excel VBA Introduction to Macro.
- Visit the
Excellent Excel Resources for
Microsoft Excel Home Pages,FAQ's,Newsgroups, VBA books and tools..
-
 Visit
the MS
Excel Quiz to test your understanding on MS Excel.
|
|
|
|
|
|
|
- Come to
the Formula Worksheet Functions for
advice on use of sumif, logical AND,OR, sum + IF, Index, Match,Vlookup
and Hlookup.
-
Typical lessons covered for the advanced MS Excel 2000.
|
|
|
|
. |
- One student has a range of cells
called BlanksRange. Some of the cells
in this range contain data, and others are blank. He is
interested in extracting the non-blank entries from this range, and
returning them to the first rows of another range. He is satisfied that he has obtained the answer from attending the Advanced Excel Course
-
One
student has its price list in Singapore Dollars, but he needs to quote
a price list in US$ to his clients. He has wanted to execute
this task but by one button. He did it
- One student prepared a time sheet
calculation for hourly rate workers. He managed to calculate the
start time one hour before midnight and stop time at 6:00 am the next
morning.
- If you have worksheets that you would like to make available to
students please email.
|
|
|
|
| ... |
. |
|