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 …
My upcoming O’Reilly business analytics online training courses
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 →
Guest Post: Three Things You’ll Love Doing in Power Query
[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 →
Review: Visual Crossing Weather for Excel
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 →
Three-way lookups in Excel with SUMPRODUCT()
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() →
Pivoting on Text in R (vs. Excel)
This post follows a previous tutorial on pivoting on text in Excel. In this post I will reproduce the exercise in R. This way you begin to see the similarities and differences of the program and begin …