Analytics & AI for Modern Excel
Blog post views certainly follow a Pareto distribution, with a handful of posts getting the disproportionate attention and the rest sentenced to lurk in the shadows: For whatever reason, one …
Continue Reading about How to create a grawlix generator in Excel →
Excel PivotTables are great for summarizing a variety of columns of a dataset in a variety of ways. But there's one particular use case where the classic PivotTable falls short. Let's take a look at …
Continue Reading about How to get the count of distinct items using Excel PivotTables →
In the past, getting a count of distinct items in Excel using formulas only was quite cumbersome. With the help of dynamic arrays, we can get it done quickly. Let's look at an example using a list of …
Continue Reading about How to get a count of distinct items in Excel →
Have you ever had a group of items separated by commas in Excel that you wanted to break into separate cells? Take the following example: Here we have a list of signups for an upcoming office …
Continue Reading about How to split data into rows using Excel Power Query →
SORT() and SORTBY() in Excel?Among the dynamic array functions of Excel are two that sound awfully familiar -- SORT() and SORTBY(). Their titles make it pretty clear what they do... they sort data. But how do they do it …
Continue Reading about What is the difference between SORT() and SORTBY() in Excel? →
Here are some overplayed topics in analytics social media: Keyboard shortcuts. They can help but are so insignificantly less important than learning to touch type, for example."It's not about the …
Continue Reading about Here are some overplayed topics in analytics social media… →
