You have now finished spreadsheets.

Here is a wee summary as to what you should now be able to do:

Nested IF Statements

3D Formulae

Pivot Tables

Sub-Totalling

Lookups

Comments

Conditional Formatting

Complex Formulae

Let me know if anything is worrying you from the list – and keep practising at home, using the downloadable files!

So, I’ve not updated this blog for a while – tut, tut, I hear you cry! Anyway, to make up for it, I’ve now posted a zip file with all electronic files for the whole course. This means that you can collect booklets from the filing cabinet to practice all spreadsheet, wordprocessing and database tasks to your heart’s content. All files for exams are there also, so feel free to do other work at home – perhaps by redoing any exams we’ve already done in class. There are also practice exams – called Versions 1-10. These are “old style” exams but will still give you some work doing IT. Click on the link above and download the file to your home desktop computers. All the files are there – enjoy!!