Analytics & AI for Modern Excel
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… →
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 …
A friend sent me the following Excel question: I am sorting a list, multiple of thousand entries. When I use the magnifying glass and enter a search term I get a pop-up window that says there are …
Continue Reading about How to filter the results of an Excel worksheet in another worksheet →
