The Pinocchio Theory & 3 Basics Where Excel Whoops Google

The Pinocchio Theory & 3 Basics Where Excel Whoops Google

THE PINOCCHIO THEORY In 1977 Bootsy Collins released the hit song Pinocchio Theory. Its main warning is: If you fake the funk, your nose will grow   There are a lot of long noses in the data world–specifically with folks who continually bash Excel and write its obituary. Excel users cannot […]

Excel, Christmas, Krampus & Kids

Excel, Christmas, Krampus & Kids

Mynda Treacy’s recent blogpost at MyOnlineTrainingHub is a hot one! Excel Custom Validation to Limit Entries poses a fun and excellent solution that Santa probably deals with every year: How does Santa set up Excel to allow a kid to request no more than 3 presents for Christmas? Mynda creates a solution that takes us […]

Getting to the Sexy Data

Getting to the Sexy Data

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.

Guerrilla Data Analysis Has Been Re-Written!

Guerrilla Data Analysis Has Been Re-Written!

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! […]

What Made My Trainee Cry?

What Made My Trainee Cry?

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 […]

Follow

Get every new post delivered to your Inbox

Join other followers: