Teaching analytics with modern Excel
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 →
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? →
