Simple formatting tips in Excel, to improve quality of learning materials

People often talk about what is there favourite e-learning tool or piece of software, and if I am asked, I answer by saying “If I were to be abandoned on a desert island with 30 students, with computers but I was only allowed one piece of software, I would take Microsoft Excel”

Why – quite simply it is a very powerful tool, which when you know how to use it, becomes a very easy tool within which to create learning materials, and even though I have access to more sophisticated tools, over 50% of the learning objects that I create use Excel. A lot of people think that Excel is about tables of data, with an ugly grid behind and complicated tool bars and navigation system – but when creating learning objects, all these can be stripped out, so when the learner views the resource they won’t even realise that it is Excel.

This short screencast shows a few such formatting tips that can be applied to make a learning resource more user friendly.

or –

I will be creating a series of blog post on the use of Excel over the coming weeks, so watch this space for more information.