Creating Interactive, Self-marking, Diagnostic Activities in Excel
The principal behind this workshop is that we can harness the power of Excel to tackle misconceptions and provide immediate diagnostic feedback for students.

This works on the idea of giving students a multiple-choice question, where the options include the right answer alongside the most common wrong answers obtained by following through a classic student error.
Link to Helpsheet

Protecting a Worksheet
It is useful to protect a sheet so that the students can’t type over formulae and spoil it.
It is also useful to prevent the students from seeing the marking formula because they could work out the right answer from that. This also preserves the ‘magic’!
Link to Helpsheet

Recording a Simple Macro
Macros can be used to record a set of mouse clicks or commands. This means you can record a macro to do things like unhide a hidden column or row which might contain some useful information such as a hint or worked solution.
Link to Helpsheet