Teaching analytics with modern Excel
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 →
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 …
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 …
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 …
Labor Day isn't my favorite holiday, but it is making me step back and think about work's purpose and its future.I've been working as an analyst in various capacities for nearly four years now, …
The “Zoolander problem”Like Ben Stiller’s male model character in Zoolander, the vlookup has a problem: it can’t turn left. Vlookups only work when the column you are looking up is to the …
Continue Reading about #Vlookupproblems: The Zoolander Problem →
