The SORT and SORTBY functions let you extract certain columns and rows from a dataset and sort them in a certain order, all while preserving the source data. Even though they work in similar ways, ...

Microsoft Excel's UNIQUE function does exactly as its name suggests—it extracts unique values from an array. In other words, you'll only see each value once in the result, even if it appears multiple ...

Are you typing these in one by one? If there are only a few people, that is fine. But if there are dozens or hundreds, it is a lot of work, isn't it? In such cases, a convenient feature is Flash Fill ...

An Excel-based analysis of a Canadian retail chain's sales data, built to answer one question a sales manager actually cares about: which product subcategories are making money, and which should be ...

Customer stories Events & webinars Ebooks & reports Business insights GitHub Skills ...