Analytics & AI for Modern Excel
I was pleased to be asked to contribute this year, and for my selection I chose what I called an often overlooked feature of Excel: the status bar. It's the gray bar way at the bottom of your …
Continue Reading about Catch me on the MyExcelOnline Podcast’s “Best of 2019” →
Survey says... Excel can do that? A common frustration in the analog world was how to disperse, collect and analyze a survey. Today, services like Qualtrics, SurveyMonkey and Google Forms make the …
Next week is my first installment of live training offered through O'Reilly Media's online platform. I'm so excited to partner with this outstanding organization to deliver workshops on business …
Continue Reading about My upcoming O’Reilly business analytics online training courses →
[Note: This guest post is from Aprajita Sharma at ExcelChamps.com. I am a friend of ExcelChamps co-founder, Puneet, and look forward to learning from Aprajita as well. Today she shares how to perform …
Continue Reading about Guest Post: Three Things You’ll Love Doing in Power Query →
They say that when you have nothing to talk about, you've got two topics to keep the conversation going: The weather, and Excel. (What, did you think I was going to say sports?) My …
Continue Reading about Review: Visual Crossing Weather for Excel →
It's wild to think that everything we do with computers comes down to manipulating its 0 and 1 states. So, it makes sense that using Boolean logic (that is, the manipulation of 0 and 1 or FALSE and …
Continue Reading about Three-way lookups in Excel with SUMPRODUCT() →
