As the war wages on between #TEAMVLOOKUP and #TEAMINDEXMATCH, a new challenger has arisen. #SUMPRODUCT, a function often associated with math and trig, has now taken on a new purpose – Boolean logic. But can it compete? Or, will it continue to lurk in the shadows, only to be utilized by Power Users… Download Workbook […]Read more "I Always Feel Like SUMPRODUCT()’s Watching Me"
Undoubtedly you have called a function a formula and a formula a function; it’s just the nature of the Excel-lingo beast. That stops now. I want you to see functions for what they truly are: computer programming. You may feel like you are not yet ready to call yourself a computer programmer – but you are. And I […]Read more "What The Func?!"
“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"