We all want to get to the sexy data and none of us are immune to the pain of cleaning data before it’s useful. Today we look deeper into this problem.
After Mike Girvin’s appearance on Excel TV I saw the array formula light!
Here’s an example of an array formula used to find the closest due date for people and their list of tasks.
It’s been quiet around here for the past few months. Why? I’ve been writing an Excel book. Actually, I wrote an Excel book with Mr Excel, Bill Jelen. It was turned in to the publisher on 1JUL14. And what does any self-respecting guerrilla analyst/author do to celebrate? Have a cigar! [...]
On Episode 12 of Excel TV I said a little about a trainee who started crying as I was teaching her the details of her new job. This story comes up in conversations around the challenges of working with data. This particular challenge was a complete data stewardship bull ride, and [...]
This week, Chris Penn’s blogpost was about “When Bad Data Can Be Okay.” I agree with everything he says about distinguishing between data that’s predictably wrong and still useful just plain unreliable and not useful mysterious but you might be able to figure it out if you fiddle with it long enough [...]
Chandoo recently posted about Modular Spreadsheet Development (MDS). Like it was for him, this is a new concept for me but it made sense. The idea of Modular Spreadsheet Development is efficiency. If you’re developing certain spreadsheet elements over and over again, time and expense could be cut down by [...]