Teaching analytics with modern Excel
In a previous blog post I shared some reasons for storing data in Excel tables and why to get started now. If you've made the leap to tables, perhaps you're perplexed by the format of their formulas. …
Continue Reading about How to use structured references in Excel tables →
One of the first practices I encourage Excel users to pick up is to store all their data in tables. Tables can take some getting used to, especially for those used to the traditional relative and …
Continue Reading about Table time! Reasons to start using Excel tables now →
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 →
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 →
Back in the LinkedIn poll craze of 2021 I will admit I, like many users, got a little carried away. To my credit, all (or at least most 😼) of my polls were done in good faith to generate a …
Continue Reading about We should be teaching Tables and Power Query in Excel way earlier →
