|
|
General
information about this module can be found here.
Previous
years tests can be found here.
Part I
Lecture
notes:
Lecture notes
will be posted in this page before every lecture.
Students are however advised to take their own notes during the
lectures.
- Lecture 1 (Basic Excel Terminology and
Features):
pdf
- Lecture 2 (Basic Operations in
Excel):
pdf
- Lecture 3 (Cell Referencing and Excel Built-in
Functions):
pdf
- Lecture 4 (Excel Built-in Functions
II):
pdf
- Lecture 5 (LookUp and Reference Functions):
pdf
- Lecture 6 (VBA and User Defined Functions):
pdf
- Lecture 7 (Variable Types, IF Structures and Flow Charts):
pdf
- Lecture 8 (LookUp and IF Structures in VBA):
pdf
- Lecture 9 (The Select Case Structure):
pdf
- Lecture 10 (Revision):
pdf
Task sheets:
Lab exercise
sheets will be
posted in this page before every lab session.
Detailed solutions to these sheets will be posted here after every lab
session.>
|
