From botched dates to missing records and more, poor spreadsheet management has led to major problems in scientific research. The prestigious journal Nature last week shared six tips for better …
How to unpivot a dataset in Excel Power Query vs R vs Python
What makes data clean? You may not be able to name those qualities, but you likely know messy data when you see it. In this blog post, we'll look at a frequent offender: unpivoted data. You'll learn …
Continue Reading about How to unpivot a dataset in Excel Power Query vs R vs Python →
How to load Excel data into Power Query
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 →
Python was not designed for data analysis (and why that’s OK)
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) →
How Power Query enforces good data hygiene in Excel
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 →
How to write less verbose Excel formulas
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 →