Teaching analytics with modern Excel
Let's be honest, there are a lot of terms in tech that sound way more complicated than they really are. Maybe it goes by an acronym for peak confusion. But peel back the concept and it makes perfect …
Continue Reading about How Power Query serves as an extract, transform, load (ETL) tool for Excel →
Earlier this week I posted a new article in the journal Nature titled "Six tips for better spreadsheets." Today I'd like to share a 2018 article in The American Statistician along the same …
Continue Reading about Broman & Woo’s “Data Organization in Spreadsheets” →
Power Query is possibly the most exciting new Excel feature of its generation... but you might never know it considering how hidden it is from the Excel interface! If you're looking to connect a data …
Continue Reading about A tour of the Power Query Editor in Excel →
1 hour to Power Query in Excel (PDQ = Pretty Darn Quick!) It's the most exciting Excel development in a generation... but you'd be forgiven for not knowing about it! Overview This one-hour …
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 …
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 →
