Everyone knows that most Excel champions come from Ohio -- Bill Jelen, Chris Newman, Jordan Goldmeier, et alia.But a very close runner-up has to be Canada -- a land that captures my …
Continue Reading about Maple Lookups: A Canada Day Tribute →
My Guest Post on the Future of Excel
Turns out Microsoft CEO Satya Nadella and I are on the same page.This morning Bill Jelen, "Mr. Excel" posted a cool story from the CEO of Microsoft claiming Excel as the company's most important …
Continue Reading about My Guest Post on the Future of Excel →
Did that just work? Case formatting in Excel
I recently came across this quote from Isaac Asimov -- it is so true:I absolutely love this quote. Breakthroughs hardly happen when you expect them. This requires a level of humility and even …
Continue Reading about Did that just work? Case formatting in Excel →
I Sunk Your Cell Format!
I came across this for the first time today -- A spreadsheet where the columns and rows were both numbers, rather than the normal lettered columns and numbered rows:At first I thought, somebody …
The guide to being me online.
Many people have asked me how I stay so present online with consistent, themed content. I'm often the first name they see on LinkedIn, they say, and they're amazed that I can stay at the top of my …
The no toxic spreadsheet shortcut
Hidden rows in Excel are sketchy. They're part of the reason why some people hate Excel.They give Excel a bad name.The most famous example of hidden cells gone horribly wrong was Barclays not …