Excel MarkBook
Contents:
Introduction ...................................... 1
Autofill ......................................... 2
AutoFilters ....................................... 5
Conditional formatting ............................ 7
Customising toolbars .............................. 10
The VLOOKUP function .............................. 12
Introduction:
These notes provide details of using Microsoft Excel as an electronic markbook. As a teacher it will be essential that you keep accurate and up-to-date records of your students marks. I have produced these notes to assist you in using Microsoft Excel as a markbook.
Microsoft Excel is perhaps the worlds best known spreadsheet. The first electronic spreadsheet was a program called VisiCalc developed in 1978. Since the 1980’s the business community has made extensive use of electronic spreadsheets.
