Teaching analytics with modern Excel
Many organizations resort to storing data in xlsb binary format for their workbooks, primarily because they find themselves grappling with files that are simply too large and fragile. While it may …
Continue Reading about How to stop storing Excel workbooks in xlsb format →
Modern Data Analytics in Excel is my second book. On the one hand, publishing a second book doesn't seem as daunting or monumental as the first, because I'm familiar with the process. On the other …
Continue Reading about How to support Modern Data Analytics in Excel (besides buying it) →
I asked ChatGPT: if the 7 wonders of the modern world were modern Excel features, which would they be and why? Here's what I got back: 1. Great Wall of China - Power Query The Great Wall is …
Continue Reading about What are the seven wonders of Modern Excel? →
I'll be presenting online at the Excel Virtually Global online conference, this coming Weds, Oct 11 2024 at 1pm Eastern US time on the topic, "Modern Data Analytics in Excel." Get all the details …
As the world of data analytics grows vaster and more complex, what role will Excel serve? Will it become obsolete in an AI-powered data ecosystem? This post explores the emergence of augmented …
Continue Reading about How to understand augmented analytics and the future of Excel →
Between Power Query and Power Pivot alone, "modern" Excel boasts so many features that it's impossible to learn them all. Add to that Office Scripts, Power BI, LAMBDA() and more and it's easy to get …
Continue Reading about What is the role of Python in modern Excel? →
