Teaching analytics with modern Excel
Fuzzy matching in Excel Power Query is a technique for comparing and linking data that may not be an exact match but instead shares similarities. This approach is particularly beneficial for …
Continue Reading about AI-Powered Excel: How to do fuzzy matching in Power Query →
Copilot for Excel is now live, bringing a suite of AI-powered features directly into your Excel experience. It's time to embrace the future of data analysis and ensure you're fully prepared to utilize …
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 …
AI is often misunderstood as a magical solution, leading people to believe it requires no user effort. But experienced Excel users, who have faced many data challenges, know better. To unlock AI's …
Continue Reading about AI-Powered Excel: How to prepare your data for best results →
Despite claims that AI has made Excel obsolete, the combination of AI and Excel has actually increased the program's power and accessibility for extracting insights and querying data. That said, AI is …
Continue Reading about How to get AI-powered insights in Excel with Analyze Data →
pandas, openpyxl and Power QueryIn an earlier post I provided an overview of how to use the pandas and openpyxl packages together to automate the production of Excel workbooks. In that post, I likened pandas as the "Power Query of …
Continue Reading about How to understand the relationship between pandas, openpyxl and Power Query →