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

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

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

Do you need a burst of improvement ideas for your business?

If you haven’t created your improvement action plan for 2020 yet then I have something for you. I have just completed my latest project – The CI Focus Tool . This Android App is now available on Google Play and provides a simple method for generating as many effective improvement ideas as you need. This is the same basic method that I describe in my book Effective Continuous Improvement  and is now available as a simple to use app. In essence it is a brainstorming focus tool. Press the focus button and you will be presented with a random continuous improvement focus. Brainstorm ideas around this focus with your team (whilst the timer is running) and there you go – a number of great ideas for you to prioritise and implement. The reason that this works so well is because of the focus. When your business runs out of its immediate problems to fix you need a different strategy. Very focused brainstorming helps you break past this problem and configuring the app to meet t