Excel's vision fulfilled Think Excel is obsolete? You may want to have a word with Microsoft CEO Satya Nadella, who has called it the organization's most important consumer product. And features …
Learning guide: Power Query with Excel, half-day workshop
Ever heard the following? "Excel can't handle millions of rows of data""Excel can't build reproducible data-cleaning processes""Excel can't collect and transform external data sources" Power …
Continue Reading about Learning guide: Power Query with Excel, half-day workshop →
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 →
Pivoting on Text in Excel: Awards by Player PivotTable
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 →
Calculating Games Behind: “Max If” in R and Excel
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 →