Blog Archives

Random Problem Solving Skills

I’ve been in a really reflective state lately as I try to weigh some different opportunities.  While I have come up with some really interesting topics for posts, most of them have turned too lengthy or incoherent to clog your Lean reading time.  One of the discarded themes has also come up a couple times lately in conversation and I thought I’d throw it out in print.   Here are three of the less obvious skills that have served me well in solving problems and working in continuous improvement activities over the years.

The first one is utilizing some sorta advanced Excel skills.  For all of you statistics nerds out there, I totally agree with you that Excel is not statistical software.  But it can be really, really helpful in sorting out piles of data in to something useable in a hurry.  For me, sometimes digging through the raw data can help highlight a pattern that I can’t see in aggregate.   Sometimes it can help put information in context and help people make better decisions faster.  I have used functions from Pivot Tables to conditional sums to writing macros (with some excellent assists from Matt) and so on.  It’s not sexy, but it is helpful.

The next skill that has served me well is another Office tool…PowerPoint.  I’m not talking about fancy slide transitions with animated gif’s and musical accompaniment.  I’m more referring to using the existing toolbox to tell concise, effective, clean stories.  You could argue that A3 reporting is much more concise and clean (and I’d agree), but PowerPoint is still massively used.  The ability to create a visually appealing communication is valuable for almost everybody.

Another skill that seems to be on and off the radar is the ability to filter information. Learning how to quickly separate signals from noise is a very underrated skill and one that needs your attention.  Every person and every idea deserves respect and consideration.  But not every idea needs to be implemented.  Abnormal situations should get due attention, but not every abnormal situation should be weighted the same in terms of response.  Developing the ability to say “no” or “not right now” with a reasonable justification can save a lot of inefficiency.

That was my quick list of unspoken skills (in no particular order).  For the record, I’m not propping these up because I consider them strengths of mine.  They’re just things that I do well enough to not do too much harm when I try to bust them out.  Mostly they’re things that I’ve picked up from others and tried to emulate.   What about you?  Do you think I overrated any of these?   Any other not-just-Lean traits that you use or seen others use effectively?