Skip to main content

Manage Only One List Where Possible

Something that I have seen a lot of over the last three months is people trying to juggle numerous lists:

  • To do lists.
  • Action lists.
  • Continuous Improvement lists.
  • Project lists.
  • Issues lists.


...split down by months and / or by working areas in the business.

Most of these lists are held in spreadsheet format (such as Excel) and it begs the following question:

Can you gain more benefit by consolidating the lists and simplifying the management of this one list?

I like lists, but I also recognise the problems that arise when you have too many of them floating around.

If you suffer from having too many lists, and aren't making progress with your actions, then it might be worth considering pulling all of the lists together to create a 'mega list'.

It may look a little daunting having one big list, but by creating some proper categories (i.e. an extra column with a limited number of options entered) and using the 'autofilter' option (usually found in Excel on the home tab 'ribbon' under Editing -> Sort & Filter -> Filter, or see this page from Microsoft).

By doing this, and perhaps being a little creative in terms of using your filters, you can turn your big list into a small, manageable, working list. This small list can then give you the focus to use your time well and make significant progress.

If you have too many 'things' to juggle, and numerous lists floating around your business (or worse, your head!) then it might be time to consider creating a big spreadsheet and learning to create proper categories and use the autofilter option.

Let me know how you get on.


Giles Johnston
...fixing MRP systems and re-engineering business processes

Popular posts from this blog

The Kaizen Checklist is here!

Do you want to get better results from your Kaizen programme? Improve your business results quickly with my downloadable kit (including guidebook, workbook and templates) for only $39. Are you looking for a sustainable way to identify and implement improvements across your business? Practical improvement strategies The Kaizen Checklist is a downloadable kit that you can use with your management team to develop a system that suits your business and allow you to quickly implement Kaizen effectively at your place of work. This works great if you use it as the centre piece of your own internal workshop. The kit includes a 40 page guidebook, a workbook, four appendices and three templates. All parts of this kit are designed to get you up and running as fast as possible. If you are unfamiliar with Kaizen, let me stress that this is a simple improvement philosophy that is so much more than just  ‘a Japanese word for continuous improvement’. I’ll cover what it rea

Take the pressure off! Using the Y-curve with your Kaizen improvements

Do you feel under pressure when you have to make changes happen in your business? It can be scary when we try something that we have never done before. I remember thinking to myself 'how on Earth am I going to figure this out?' on many occasions. I think the last time was a few weeks ago! Years on from becoming reasonable at the art of change I am still faced with the same dilemma. It is scary and it is clear to me why so many people shy away from making change happen. It is natural to get stuck in this oscillation. On one hand you need to make change happen; the business needs the improvement benefits. On the other hand you don't want to screw up... Last week I was talking to a young engineer that I am mentoring. He was paralysed. Changes were not happening at all. There was always some early promise with his projects and then, as completion (and judgement day) loomed, progress would evaporate. The engineer asked me for my views on this  during a recent conversati

Kamishibai Boards

Available to purchase here. Some tools are incredibly simple to use, and also deliver some amazing results. Kamishibai boards are a great example and are superb when you want some visual control over routine tasks. By the way Kamishibai is pronounced "come-e-she-bye" in case you were wondering! As simple as you could want it, a Kamishibai board is a T-card system that has red cards glued to green cards (so that each T-card has a red side and a green side). The red cards are for the incomplete tasks, where as the green cards symbolise that the work has been done. See the photo below of a board in use. On the red side of the card you write the name of the task that needs to be completed, and if appropriate you can include details of how the task is to be completed. This is not expected to replace standard operating procedures, but can be a good opportunity for an aide memoire. The boards can be organised for daily, weekly and even monthly cycles. They are g