Teaching analytics with modern Excel
[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() →
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 …
This post is inspired by a Mr. Excel tutorial on using "text instead of numbers in a Pivot Table." Our goal is to create a Pivot-Table like report that creates a comma-separated list …
Continue Reading about Pivoting on Text in Excel: Awards by Player PivotTable →
In a recent post I walked through baseball's Pythagorean theorem in Excel. I am finding baseball statistics a great post subject for a variety of reasons: it's freely available, it can be analyzed in …
Continue Reading about Calculating Games Behind: “Max If” in R and Excel →
