Last week I was in a cafe and saw 2 professional-looking middle-aged gentlemen at a table. One guy told the other how he’d advised someone not to take a computerized Excel exam as part of an interview. His personal experience was that those exams are just frustration. “You get in […]
Today we explore this ongoing debate over VLOOKUP vs. INDEX/MATCH. I say it’s a false dichotomy and unnecessary confusion.
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 continue […]
“Teach me Excel” is a hard request to satisfy. Here is why and 5 suggestion on how to get started learning Excel.
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 […]
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.