Note -- LinkedIn Pulse picked up this piece, and it's getting some good interaction there -- check it out and if you haven't already, connect with me on LinkedIn while you're there. I've been …
Data Realism and the Missing Keystrokes
April is over, and so is Oz du Soleil's daily video blog. I am still enjoying these.Tonight I caught up on a look at Oz's Excel work environment.It's fascinating to see others' Excel work habits -- …
Continue Reading about Data Realism and the Missing Keystrokes →
Messy Data Horror Stories! I Brought My Own to Share
Last night I called in to a Blab hosted by Bob King starring Oz du Soleil. I mentioned some of the inconsistency and false logic I see with data. The pretty dashboards and statistics are the easy …
Continue Reading about Messy Data Horror Stories! I Brought My Own to Share →
How to Learn Excel from Scratch (Slides)
A common reaction I get when people learn I'm an Excel blogger:"Oh, you know Excel? I should learn Excel. Tell me what to do."This is a hard question, because as the old disclaimer goes, "not all …
Continue Reading about How to Learn Excel from Scratch (Slides) →
Hold that Date! Timestamped Printouts in Excel
It's not uncommon at my office to see "version 37" of a budget, sales plan, or other big project. Keeping track of all these changes can be a mess.While Excel has some functionality to track changes, …
Continue Reading about Hold that Date! Timestamped Printouts in Excel →
Humanity First: In Defense of Helper Cells
In blogging about Excel I have faced a dilemma: do I teach the user-friendly but impure Excel, or Excel for the initiated?I am not the savviest Excel guy in the blogging world. I make up for that with …
Continue Reading about Humanity First: In Defense of Helper Cells →