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

Where to start with Kaizen, if you just aren't sure

Kaizen is a great word. It is a word that can unleash the potential of both a business and an individual. Kaizen means more than just continuous improvement. It is a word that is linked to: Confidence Growth Exploration Courage Many people I speak to, that are new to improvement projects, aren't sure if they are on the right path when it comes to embracing the spirit of Kaizen. If you are also one of these people then let me share with you a few thoughts that can help you feel at ease about starting and leading change. Start with your concerns A great place to start your improvement life is with anything that isn't right. Getting your concerns out into the open really is the first step for most of us. If you aren't happy with something, raise it. This isn't only a great place to start, but something that you shouldn't give up. Whenever a standard is not being met, or not even defined, get vocal and then do something about it. Start small The intention of Kaizen is

Stimulating Kaizen opportunities - the 'mechanical' way!

I often end up in conversations about how to stimulate Kaizen ideas and opportunities. If you have read my other posts, you will know that I split the improvement journey into two halves. For many people, the initial Kaizen focus is all around fixing things that are wrong / not working properly. Once you get past this point you need something else to focus and motivate you to generate improvement opportunities. The two halves of the Kaizen journey The discussion that I often end up in, is the one around the imagination quandary. People talk to me about not being creative, or not being inspired to come up with improvement ideas. Do you ever feel this way? It seems that there is a popular view that some people are creative and some aren't. Great Kaizen ideas are not just the product of 'creative' people. There are lots of ways that you can generate improvement ideas without having to sit on a mountain top cross legged waiting for inspiration. Finding a 'mechanical' w

Kaizen projects: being honest about being off track

Projects, especially improvement projects, have a tendency to get off track. There is often a clear distinction between projects for customers and projects for ourselves. If our improvement projects fall behind then our customers won't be barking at us; it is no wonder that if something is going to slip it is our Kaizen endeavours. For some people this can be a tough conversation to have. No one wants to be a 'failure' and pride often gets in the way. In my experience it seems that it is believed to be far more credible to ignore the requirement to improve than to admit that we aren't making progress. So, if you find yourself (and your business) in this situation, what can you do about it? Let me share with you two options to increase the visibility in your business around progress with projects and four options to help get your projects back on track. Increasing visibility Ok, no more hiding the status of Kaizen activities . This also means no more being precious about