Microsoft Excel 2019 VBA and Macros

Microsoft Excel VBA and Macros is an exceptional value for those wanting to significantly increase their productivity using VBA and makes a great addition to your library.

Excel Resources

I recently discovered a website titled “Excel Off The Grid” while doing some research for one of our projects.  The post I read was well written, succinct, and the examples were easy to follow.  Although our application required a little more depth, the information presented would be more than sufficient for most people wanting to use the features as discussed. […]

Are you an Excel Hero?

Background Not too long ago, I was approached by a systems consultant to consider writing an Excel solution to create a weekly production schedule for one of his clients.  The reason for using Excel will become clearer in a moment. The current process Sales representatives submit a unique Excel spreadsheet / file for each customer order.  All orders are saved […]

Lean Execution – Excel Site Update

For those of you who are looking to expand your knowledge of Excel, improve your skills, or wish to develop an application in VBA, we have added Ron DeBruin’s web site to our Excel page.  Ron presents some very useful solutions to what could otherwise be some very difficult problems.  We trust you will find the link leads to some very practical solutions for […]

22 Seconds to Burn – Excel VBA Teaches Lean Execution

Background: VBA for Excel has once again provided the opportunity to demonstrate some basic lean tenets.  The methods used to produce the required product or solution can yield significant savings in time and ultimately money.  The current practice is not necessarily the best practice in your industry.  In manufacturing, trivial or minute differences in methods deployed become more apparent during mass production or as […]

Seasons Greetings

This year has been filled with many new experiences, hard times, great times, and many opportunities for learning.  While some may prefer to see this year pass sooner than later, 2009 is hopefully a year that presented many new opportunities and even greater challenges. As lean practitioners, we learn to appreciate failure from a different perspective than most people would enjoy.  The focus is not the […]

5S Your Software (Computer)

We recently discussed how software skills of people in your company can impact their effectiveness and efficiency.  One of our suggestions was to provide additional training and resources to allow staff to upgrade their skill levels. We should also mention that upgrading to the latest software release may also improve their performance.  Microsoft recently announced upgrades to their Office product line so now may be the time to “5S” […]