Teaching analytics with modern Excel
We've probably all heard by now that data professionals spend 80% of their time cleaning data. But why? It's true that in data analysis, some assembly is required -- whether to meet the assumptions of …
Continue Reading about You’re probably storing your data in Excel the wrong way →
Adding a calculated column is one of the most typical tasks in data cleaning -- profit ratios, date durations, you name it. Power Query makes this a simple part of the data cleaning process through …
Continue Reading about How to create calculated columns in Excel Power Query →
Perhaps the most fundamental data cleaning steps involve working with rows -- sorting and filtering, removing duplicates, and so forth. "Classic" Excel makes this process intuitive through menu-driven …
Continue Reading about How to transform rows in Excel Power Query →
In an earlier blog post, I reviewed Flash Fill as a fast, accessible AI-powered tool for pattern recognition in Excel. Helpful though as it is, Flash Fill is not the most scalable solution -- that …
Continue Reading about How to create a Column from Examples in Excel Power Query →
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 →
.tsv file in Excel Power QueryThis post will show you how to load .tsv (tab-separated values) files into Excel Power Query. To get started, place the below download file into your Downloads folder. Data source: …
Continue Reading about How to read from a .tsv file in Excel Power Query →