Teaching analytics with modern Excel
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? →
Have you ever wanted to grab every column header of a dataset in another part of your Excel workbook? Let's take a look at what I mean, and how to do this: Notice that the data has been …
Continue Reading about How to refer to every column header of an Excel dataset →
Probably one of the most thriving niches of the "learn Excel" industry is to memorize keyboard shortcuts. The idea is that using a mouse is slow and inefficient. Keyboard shortcuts can speed up your …
Continue Reading about Excel users need to do this before memorizing keyboard shortcuts →
Download the white paper here 👇 Be sure to subscribe for complete access to my analytics resource library Thank you for checking out this white paper. Power Query is the most exciting …
