Teaching analytics with modern Excel
I liken Power Query to the Narnia of Power Query -- a magical place, but not so easy to locate: Here's how to load your Excel data into Power Query...and an example what to do with it when you …
Continue Reading about How to load Excel data into Power Query →
A major reason I think it’s easier for Excel users to pick up R versus Python is that these tools tend to "think" more similarly than Python. See what I mean here: let's take a range of numbers and …
Continue Reading about Python was not designed for data analysis (and why that’s OK) →
Not only is Power Query a phenomenal tool for transforming data in Excel, it also enforces good data hygiene 🧼. What do I mean by that? Think about the steps that you take every day to present …
Continue Reading about How Power Query enforces good data hygiene in Excel →
Here’s a little secret: No one is impressed by that giant Frankenformula you wrote in Excel. Just like with writing anything, the less verbose you can write your formulas, the better. ✂ A few ways …
Continue Reading about How to write less verbose Excel formulas →
This is something that happens to me all the time: I've got data in an Excel table and want to add an index column (because I believe every dataset should have an index column). Index columns …
Continue Reading about How to add data to the left of an Excel table →
If you've heard that Excel can only handle 1,047,576 rows... well, that's not so true anymore. With Power Query, it's now possible to work with millions of rows, building a fully reproducible …
Continue Reading about Sigma Rule #1,048,576: Never underestimate Excel →
