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 …
Labor Day Reflections
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, …
#Vlookupproblems: The Zoolander Problem
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 →
Hired with Excel: Get In the Door
Find the analyst jobWhen looking for jobs, LinkedIn is crucial. It is as important to professional networking as Excel is to business analysis. I’m saying this out of experience: I was hired twice …
Hey, Data Analyst, Learn Some Content Marketing
One resource that's been particularly helpful since I've started writing is the Content Marketing Institute. Much to my amazement, this organization is based in my hometown of Cleveland, OH. This is …
Continue Reading about Hey, Data Analyst, Learn Some Content Marketing →