In the digital age, it’s time to put the abacus away

Now more than ever it seems increasingly important to not lose sight of our small successes. Big wins are great, but the cumulative effects of multiple small wins are often underestimated. Along this line, a short interaction I had with somebody last week makes for a great example worth sharing. It resulted in the retirement...

Read More →

Excel + Google Maps = Advanced Trucking Estimation and Analysis

This is my second post of the series, #IDidntKnowExcelCouldDoThat, inspired by my clients saying, “wow, I didn’t know Excel could do that!”. Earlier this week I started this series with an article on LinkedIn about leveraging public data for business intelligence purposes. The end of that article resulted in looking at a data set geographically on...

Read More →

Leveraging Free Public Data Using Excel’s Power Query (for Business Intelligence and Business Development)

This article touches on a few hot topics: free public data, business intelligence, business development, and my personal favourite… #IDidntKnowExcelCouldDoThat.  For those of you that are avid LinkedIn users, I have also posted a version of this article here. For years I have been listening to my clients say, “wow, I didn’t know Excel could...

Read More →

To version or not to version, that is the question

Often good practices prevent a significant number of problems from occurring.  Other times, its those same good practices that are the actual source of the problems.  How so? Let me explain... Let’s say you are preparing to embark on the journey of preparing a spreadsheet to report the stellar annual performance of your department to...

Read More →