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: 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 →
;;; And I’m Through With You
Here's a nice Excel shortcut. Say you want to leave data in a cell but wish to make it invisible. You can do this by going to the Format Cells menu (keyboard shortcut: Ctrl + 1), selecting Custom, …
Use this Excel Print Formatting Every Time
Even in the digital age, much of what is created on the computer gets printed. You can make a great spreadsheet, but if it doesn't look good in print, it loses credibility. Here is the formatting I …
Continue Reading about Use this Excel Print Formatting Every Time →