Tag: Lean Office

Lean – Have it Your Way

It’s easy to determine whether the leadership of a company truly embraces lean thinking.  One of the more frustrating “tells” is the insistence of leadership to precisely follow the path others have taken.

The underlying notion of achieving the same or similar results may be appealing but it does not address why the specific path or methodology was chosen by a given company to begin with.  Many automotive companies have learned that lean is not a simple matter of copying and duplicating the practices of a company like Toyota.

If lean is indeed a journey, it is only fair to say that any competitor or other company you have chosen as a model to follow is still in the pursuit of perfection to achieve the ever elusive ideal state.  Since we don’t or can’t possibly know what their ideal state could possibly look like, implementing the best practices of other companies is merely nothing more than a starting point.

To be a “copy-cat” or “me too” company does little to differentiate you from the competition.  What advantage or benefit will the customer realize if you are just like all the others?

The tools of lean and six sigma are not the concern here.  Rather, the concern extends to the very systems and processes of the organization and business itself.  It is the underlying thinking that forms the foundation on which the organif the underlying thinking and assumptions

Innovation is Lean Thinking by Design

Differentiation is a trait best demonstrated by a company like Logitech.  While some companies simply attempt to make products faster and cheaper, Logitech’s appeal is to offer something more in the product itself.

Consider Logitech’s recently introduced flow technology where a single keyboard and mouse combination can seamlessly switch between two computers as though they were one.  Spending a little more money on a premium or advanced product offering is still cheaper than having to buy three of each and also offers the benefit of having more available desk space.

As another example, Logitech recently released the MX Vertical Mouse, an ergonomically designed mouse that improves performance, productivity and reduces the risk of injury that may occur due to prolonged use of the device.  Although the design changes are only slightly radical, they demonstrate the never-ending cycle of continuous improvement.

Systems, methods, processes, and procedures are present in every facet of an organization or business.  Consider how lean thinking can be applied to increase their effectiveness, improve performance, and ultimately eliminate waste.

As I’ve said before, “What you see is how we think.”  I contend that Lean thinking is best demonstrated by what differentiates your company from the competition.  The greatest value may be found in those elements that defy logic and the small things that set you apart to position your company ahead of the curve.

Until Next Time – STAY lean!Versalytics

Related Articles and Resources



Lean Office with Excel and VBA

Have you ever wondered what people do at their computers all day?  How can they possibly be that busy working on their day to day tasks?  The answer may surprise you!  Computers were supposed to make our jobs easier and give us more time to do other things.  The reality is quite the opposite.

We have noted that many people are not as adept at using the software we have placed at their finger tips as we would like to think.  As a result, we have found that one of the significant losses in the front office is time wasted doing work that could easily be done by the software.  Unfortunately, we simply don’t know how to do it.

Time is wasted entering, retrieving, editing, and manipulating data to consolidate and prepare reports that only require further manipulation and editing so an effective analysis can be performed.  This is particularly true for spreadsheet applications.

Pivot Tables are an excellent example of the point we are making here.  Some people are aware of them and even fewer know how to use them.  Pivot Tables make organizing data a relatively simple chore.  Once created, it is a simple matter to refresh the data and regenerate new reports.

We have also observed that many of the tasks being performed using spreadsheets can be easily and readily automated resulting in considerable time savings.  When we discuss these opportunities with the current users, we find that most people only use a fraction of the capabilities that are available to them simply because they are not aware of them or simply have have not been trained.

There is something about our current work methodology that supports learning  just enough to get the job done rather than learning all we can to perform the job efficiently and effectively.


There are many venues available including online training and packaged offsite training programs however, we still prefer learning by the “book”.  Many books include a companion CD that not only includes working examples and tutorials from the book, but often times a copy of the book itself is offered in digital form.

If purchasing books seems to be more of a burden than you bargained for, visit your local library.  They often carry many books that are better borrowed than purchased, especially if you are starting at the most basic level.  In a short period of time, your experience will outweigh the content of the introductory texts.

The next time you find yourself entering even more data and formatting spreadsheets and reports, consider teaching yourself some VBA over the next few weeks to see how much you can do to help yourself by putting your software to work!

Trusted Web Sites

If Microsoft Help will take you online to visit the archives of Microsoft’s help system, it only seems inevitable that you will find yourself searching for an online “solution” as well at some point in the near future.  Rather than list the sites here in this post, we recommend that you look at the Web Sites Page under “Books and Resources” menu or click here.

Visual Basic for Excel

Microsoft Office Excel 2007 Visual Basic for Applications:  Step by Step

We are presently reviewing Microsoft Office Excel 2007 Visual Basic for Applications:  Step by Step, by Reed Jacobson, published by Microsoft.  The book requires a minimal degree of familiarity with the Excel and VBA environments and offers a solid interactive approach to familiarize the reader / student with Macros and VBA.

While this may be a little more than just coincidence, the examples developed in the first few chapters of the book were very similar to an actual situation we encountered only a month ago.  Although we already developed our solution, it was interesting to note that the “HOW TO DO IT” was already out there, bound in a book and sitting on a shelf.

The ERP system would generate a text file that was manually loaded into a spreadsheet, manipulated, formulas added, data edited, and finally formatted to create the final report.  This task would require anywhere from 30 to 45 minutes per day.  Using the macros created through the first few chapters allowed this work to be completed in less than a minute.

While books may not make for a great gift, the time you can save to do other things is the best gift you can receive.  It is interesting how often we hear “I don’t have time”.

Next Steps

We are more than impressed by companies that support in-house libraries where books and other resources are available for their employees.  If you don’t have one where you work, this may make for a great suggestion where everyone wins.

Until Next Time – STAY Lean!

Vergence Analytics