Income & Expense Tracker – Buy One, Give One

Income & Expense Tracker – Buy One, Give One

Income & Expense Tracker It’s almost that time of year again – when carrier bags of business receipts, full to the top, need to be put in to some kind of organisation for a self-assessment tax return. Well I have a system for that, and of course...
What gets measured gets managed

What gets measured gets managed

What gets measured gets managed We’ve been pleased to be helping a good friend, John Lamerton, with a spreadsheet to accompany his new book – Routine Machine: How successful people improve their morning routine, daily habits and guarantee themselves...
How to create a data entry form in Excel

How to create a data entry form in Excel

How to Create a Data Entry Form in Excel A spreadsheet is a great place to enter tables of data, such as price lists, but to enter records a row at a time from left to right isn’t always user friendly. Did you know that there’s a handy form feature so you...
How to create a dynamic drop down list in Excel

How to create a dynamic drop down list in Excel

Today I’m going to show you how to create a drop-down list in Excel; and not just any old drop-down list but one where if you change the items in your list, then the drop-down that you’ve created will also change. You may be familiar with using Data...
What do you think about speedos?

What do you think about speedos?

One of the first things I’m often asked for when building a dashboard is “one of those speedo things – you know, a dial with a moving needle”. They’re not always the most useful chart to have on your dashboard as they only show you a single absolute value – but… well...
Valuing your time on Twitter

Valuing your time on Twitter

How do you know if your marketing activities are working? One I sometimes struggle with is Twitter. The content moves so fast and I don’t feel I know if my short ramblings have just disappeared in the fast flowing action or if they’re actually doing...