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.

One Response

  1. […] If we are using Excel to create learning objects then it is beneficial to make the appearance of the file as tidy and uncluttered as possible – which I have discussed in a previous blog post –… […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: