You probably didn’t expect etymology in this book, but it here goes. When I probably should have been learning Excel in high school, I took a Greek class instead.I haven’t used my Greek a lot, but one …
Anchors Away! A Better VLOOKUP
There is nothing wrong with the average vlookup. But do you really want to be average? The coveted analyst needs exceptional Excel skills. How can we make Vlookup even more accurate and …
#VlookupProblems: Cells Formatted as Text
This is a common problem that interns and coworkers often approach me with."Can you take a look at my vlookup? I'm doing everything right but getting errors."The culprit: incorrectly formatted …
Continue Reading about #VlookupProblems: Cells Formatted as Text →
BI: Errors Wanted
If you’re not embarrassed by the first version of your product, you’ve launched too late. -- Reid HoffmanI recently finished Bold by Peter Diamandis and Steven Kotler. The book is part economic …
CMWorld 2015
When I sent my mom the above photo she asked me if Hollywood Squares was in town.Even better: last week was Content Marketing World. The world's largest content marketing event is held every year in …
An even better Vlookup: IFERROR
Download the exercise file here.You have a pretty slick vlookup now. You are adding to the efficiency and the accuracy of your work. Bosses will notice. It is time to put the cap on your vlookup …