Being the 115th ranked general Excel blog on the internet sure has a nice ring to it. Well deserving of your e-mail subscription (located in the bottom right hand corner) if I was to be rather James Blunt about it. But what good is a rank if there are multiple categories to be considered? “Voted best burger […]Read more "I’m Unsure How Official This Ranking System Really Is…"
Not since the great territory battles of 7-Eleven Vs. Quiktrip, has there been such an unparalleled rivalry: “VLOOKUP or INDEX/MATCH?“A seemingly innocent question, when asked among Excel users, gives you a general perception of one another. There is one function’s inability to turn left and the others reliance on multiple functions for use. One’s perceived simplicity vs. the others perceived complexity. Are […]Read more "Defining The Great Divide"
This is not an Excel Lesson… This is a Lesson About Excel. Let’s start at the beginning… Download Workbook Day 1 Function: SUM Describe It: Add all the numbers within a range of cells. Syntax: =SUM(number1,number2,…) number1 can be anything from a single cell to a range of adjacent cells number2 and so on can be anything from […]Read more "500 Days of SUM(SUMIFS())"
“If I paint something, I don’t want to have to explain what it is.” -Bob Ross A common theme you will hear me discussing is storytelling. “They” say a picture is worth a thousand words, and the human eye is receptive to shapes and colors as a means for detecting object variances. That’s why telling a visual story is so […]Read more "You Don’t Owe Anyone An Explanation"