Teaching analytics with modern Excel
When you think of predictive analytics, maybe you picture programming languages like R and Python or cloud platforms like Azure or Amazon AWS. The humble Excel spreadsheet is probably not top of mind …
Continue Reading about How to perform predictive analytics in Excel using the XLMiner add-in →
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 →
In an earlier blog post, I reviewed Flash Fill as a fast, accessible AI-powered tool for pattern recognition in Excel. Helpful though as it is, Flash Fill is not the most scalable solution -- that …
Continue Reading about How to create a Column from Examples in Excel Power Query →
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 a previous blog post I shared some reasons for storing data in Excel tables and why to get started now. If you've made the leap to tables, perhaps you're perplexed by the format of their formulas. …
Continue Reading about How to use structured references in Excel tables →
One of the first practices I encourage Excel users to pick up is to store all their data in tables. Tables can take some getting used to, especially for those used to the traditional relative and …
Continue Reading about Table time! Reasons to start using Excel tables now →
