Teaching analytics with modern Excel
When working with tables of data in Power Query, any operation by definition has to involve either operating on rows or columns of a table. A previous post showed some typical techniques for working …
Continue Reading about How to transform columns in Excel Power Query →
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 →
Converting scanned paper documents into editable computer text files is nothing new -- it's called optical character recognition (OCR) and it's been around since the 1970s. This technology, of course, …
Continue Reading about How to import data from a picture in Excel →
Between Power Query and Power Pivot alone, "modern" Excel boasts so many features that it's impossible to learn them all. Add to that Office Scripts, Power BI, LAMBDA() and more and it's easy to get …
Continue Reading about What is the role of Python in modern Excel? →
