Every time I run a Copilot for Excel workshop, there’s one question that always comes up: “How can I make Copilot remember my prompts so it can do my weekly reports automatically?” Short …
How to stop storing Excel workbooks in xlsb format
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 →
How to support Modern Data Analytics in Excel (besides buying it)
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) →
What are the seven wonders of Modern Excel?
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? →
Modern Data Analytics in Excel (Excel Virtually Global online conference 2024)
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 …
How to understand augmented analytics and the future of Excel
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 →