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 …
#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 …
Vlookup: The Mechanics
This post is part of a series on one of Excel's best functions, VLOOKUP. Check out the entire series here. Then, subscribe to my newsletter for the latest. Vlookup is the duct tape of Excel Go back …
Hired with Excel: The Pareto Handyman
This is part of the "Hired with Excel" series. Read the previous posts on the good and the bad in Excel.This series will give you actionable tips on the two most commonly used Excel tools. …
Continue Reading about Hired with Excel: The Pareto Handyman →
Hired with Excel: Why Vlookup?
We are finally covering Excel content. I've discussed everything from what an analyst does to the good and the bad in Excel.Why the slow windup? It's because being a good analyst is more about having …