Teaching analytics with modern Excel
A common practice in machine learning and predictive analytics is to split a dataset into training and testing subsets. The training subset is used to build the actual model, while the testing is used …
Continue Reading about How to create training and testing data samples in Excel →
Many of my favorite new Excel features like FILTER(), UNIQUE() and SEQUENCE() are so-called "dynamic array" functions. But other than being really great, what does it mean to be a dynamic array …
Continue Reading about How to understand dynamic arrays in 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 →
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? →
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 →
Excel's vision fulfilled Think Excel is obsolete? You may want to have a word with Microsoft CEO Satya Nadella, who has called it the organization's most important consumer product. And features …
