Analytics & AI for Modern Excel
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 →
I've been a casual student and advocate of cryptocurrencies since ca. 2014, but recent news has attracted me (along with everyone else and their Uber driver) to them more seriously. Subscribe to my …
Continue Reading about Get Real-Time Cryptocurrency Prices from Yahoo! Finance to Excel →
