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: Cells Formatted as Text
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 →
Hired with Excel: The Bad
This will be you as an analyst -- headphones on, baffled by some spreadsheet your coworker just sent.This post is part of the Hired with Excel series. Read the previous post on the advantages of Excel …
Excel Tip: Freeze, Formula!
I promise I didn't post this just to use this great (free!) photo from Gratisography. No, it's because this is one of the niftier Excel hacks that doesn't get much publicity.Unwinding a formula in …
Highlight Every Cell Containing a Formula
Checking for data accuracy is tricky in Excel. In this blog, I have been presenting some of my tips. This is a great one for more visually-oriented users. We have a simple inventory model below. …
Continue Reading about Highlight Every Cell Containing a Formula →