Synopsis:
This course builds upon basic spreadsheet skills and introduces advanced features of spreadsheet, more complex calculations, multiple worksheets, and importing / exporting data. Participants should already be familiar with the basic features of MS Excel (we will cover Excel 2003 or 2007).
Who is this course for:
This course is for anyone wishing to master spreadsheets, making use of the advanced
features of MS Excel to create, store and analyse classroom/school data.
Objectives:
▪To carry out complex calculations involving formulas and functions employing relative and
absolute referencing.
▪To create and link multiple worksheets.
▪To produce effective charts and graphs and link or embed them into other documents .
Duration:
Full day (can be tailored to a half-day / twilight session if required).
Facilities Required:
The presenter will require access to a PC with: digital projector and screen (preferably an
interactive whiteboard) and MS Excel.
Each participant will require access to a computer and MS Excel.