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-Powered Excel: How to prepare your data for best results
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 →
How to get AI-powered insights in Excel with Analyze Data
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 →
How to understand the relationship between pandas, openpyxl and Power Query
In 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 →
How to improve your Excel skills (FP&A Today podcast)
I had a great discussion with host Paul Barnhurst along with fellow guests and Excel MVPs Mark Proctor and Celia Alves on why and how finance and FP&A can be more effective and efficient in …
Continue Reading about How to improve your Excel skills (FP&A Today podcast) →
How to understand the difference between left outer and inner joins in Excel Power Query
In a previous post, we looked at some of the limitations of XLOOKUP() and other Excel "duct tape" lookup functions. Relational joins in Power Query were introduced as a more robust alternative. This …