Teaching analytics with modern Excel
Have you ever had two files that you wanted to vertically "stack" together into one in Excel? How did you do it? I'm guessing that short of some complicated script you just copy-and-pasted them …
Continue Reading about How to append two files together in Excel Power Query →
The paired samples t-test can be used to test for a significant difference in measurements across observations from one time period to another. This post will demonstrate how to conduct the test using …
Continue Reading about How to perform a paired samples t-test in Excel →
I love the "Modern Excel" suite of tools and wish more spreadsheet users would adopt them. But I can understand the slow adoption... it's confusing! For example, you may be interested to start using …
Continue Reading about What’s the difference between Get & Transform and Power Query in Excel? →
This post is sponsored by TIBCO. Thank you for supporting the organizations I trust. If you’re an analytics professional, chances are the way you work has changed dramatically over the last two …
Continue Reading about The world has changed… your analytics has not →
If, as I write in Advancing into Analytics, lookup functions like VLOOKUP() are the duct tape of Excel, then relational joins in Power Query are like a full-on blowtorch, allowing you to contort data …
Continue Reading about How to do a Cartesian/cross join in Excel Power Query →
Blog post views certainly follow a Pareto distribution, with a handful of posts getting the disproportionate attention and the rest sentenced to lurk in the shadows: For whatever reason, one …
Continue Reading about How to create a grawlix generator in Excel →
