Blog

Making sense of a colour coded spreadsheet

Making sense of a colour coded spreadsheet

Your boss has just sent you a colour-coded spreadsheet. She’s asked you to make sense of the information in it but the figures you need are all over the place. When working with spreadsheets, I’d argue it’s better to group information into categories using a different column (or row) for each. That way, when it comes to extracting meaningful information, you can seek out the data with ease. Living in an imperfect world, we don’t always have that luxury. Not all spreadsheets we come across are so neatly organised! To make sense of the data you’re going to need to...

Read more →


Changing your view

Changing your view

Make your spreadsheet a joy to behold with a few simple set up stages Before we eat dinner we set the table, so that the crockery, cutlery, condiments, drinks etc. are ready for us when we sit down to eat. In the same way, we can prepare a spreadsheet before we sit down to work. With everything laid out neatly on view, your spreadsheet will be easier to use and your work more of a pleasure. So, if you don’t want to make a dogs dinner of it, here are some really simple tips for preparing a tasty looking spreadsheet!...

Read more →


Task management with a twist… of fruit!

Task management with a twist… of fruit!

If your workload is driving you bananas, believe it or not, fruit might be the answer! When you’re inundated with tasks it can be hard to know exactly where to start. You need to work through which activities to prioritise and how to tackle each of them, and you need to do it fast. This method uses well-established task management techniques combined with visual symbols to aid recall. According to mind-mapping expert Tony Buzan, “imagery, colour and visual-spatial arrangement… is proven to significantly improve recall when compared to conventional methods of note-taking and learning by rote”. So this technique will...

Read more →


Keyboard shortcuts for Microsoft Excel

Keyboard shortcuts for Microsoft Excel

How keyboard shortcuts help It is worth taking the time to learn the keyboard shortcuts for Excel. Why? Speed – Keyboard clicks are so much faster than mouse moves. It might not seem like much of a difference, but taking longer to complete each small task can add up to a lot of time throughout the day Recall – There is no need to remember which menu contains the task you’re after. Efficiency – You’ll also save the time you spend moving back and forth from keyboard to mouse.   Helpful keyboard shortcuts to get you started Here are some...

Read more →


Doofa – get things done!

Doofa – get things done!

Doofa, a new add-in software product, looks set to make office work simpler and faster than ever before. Doofas are easy-to-use tools that perform common office tasks, drawing on the wide range of functions available in Microsoft Excel. Staff often avoid using the full range of software functions available to them because they are put off by technical jargon and confusing user interfaces. Faced with this most people revert to time-consuming manual methods. Doofa products are designed to be used by even the most inexperienced computer user. Doofas are completely jargon-free and extremely simple to use.  Doofa's founder, Ian Chester,...

Read more →