Teaching analytics with modern Excel
You’re Finally Hired....Congratulations!Now what?First of all, know that with these skills you are going to impress your boss. Your coworkers will appreciate you, too. Good spreadsheet analysts are …
Continue Reading about Hired with Excel: You’re Hired! Now What? →
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 …
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 …
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 →
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 …
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 →
