Moving from exhell to excel


For years I had a backlash against excel spreadsheets. To me they provoked too many questions. They changed things I didn’t want to be changed. It was never as neat as I wanted it to be. They reminded me of endless hours of imputing in a previous job. And, they said the dreaded word equations which automatically makes me tense up.

However, I have now had an epiphany and a change of heart about excel. I have actually started using them and I have to say I misjudged them. They are extemely useful for recording results and progress in a format that is easily readable and can create consistancy across a department – one tab for each class. They also take up a lot less space and are easier to format that endless word documents.

The trick is to have someone to create a template for you that you can modify easily and imput the information for your own classes. I’ve been very lucky to have that and it makes a world of difference to see how to use and manipulate it properly.

I know the tech savvy out there will think this is all old hat but for those of us who forsook computing aged 13 this is a revelation.

Here are some things I have discovered in my move from exhell to excel:

1. Merging cells / creating headers

2. Using smilies to grade rather than marks – finally a reason for wingdings font!

3. Freezing the name cells so that you still know who you are clicking on when you’ve moved along

4. Colour coding – who is doing well, who is doing ok, who needs a hand – all at a glance

5. Being able to share results easily and reliably


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: