Unpivot

Trolls, New Features and Common Data Problems

Unpivot

Show Notes

Trolls, Features and Common Data problems. In this chaotic episode of Unpivot, the gang kicks things off with Halloween antics and quickly spirals into the wild world of Excel, Power BI, and internet comment drama. From TikTok trolls who think Power Pivot lives in Access (spoiler: it doesn’t) to debates about whether picking pumpkins is just muddy shopping, it’s a rollercoaster of laughs and learning. They also dive into juicy new features like visual calcs, agent mode, and formula-by-example, and share their favourite ways to handle messy data, missing dates, and the eternal mystery of “what does sales actually mean?” Question of the Week: What are Common Data Problems you come across 🎃 What does "Pick your own" actually mean? 😡 Haters gonna Hate 👩‍💻 Lots of New Features in Excel and Power BI 📊 Visual calcs 🤔 Is Excel a database?

Unpivot Show Links PageHosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.

More from Unpivot

Oct 16, 2026

Special Guest Fay Bordbar Question of the week: What are our AI predictions 💃🏻 Barcelona FabCon ✌🏻 Is VLOOKUP making a comeback? 🤓 Alex Powers & Greg Baldini shout-outs 🔁 Power Automate Love 📊 Canvas in Excel 🏃🏻‍♀️‍➡️ Turns out Sue is Competitive ⁉️ Is Giles a "S**k" ? 🪃 Aussie Lingo quiz Unpivot Show Links PageHosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.

Oct 3, 2026

QotW: Lists in Excel? Other topics: 🎂 Birthdays 🤖 Is Copilot actually good now? 📢 Power BI Announcements 🤯 2 Million Billion Calculations per second 🪃 Aussie Lingo Quiz

Sep 19, 2026

Thanks to special guest Oz du Soleil https://www.linkedin.com/in/ozdata/ QotW: My way or the highway: When does advice become dogma and how to find the balance. Other topics: 🏯Japan 🔍Kaleidoscopes 🏊🏻Mile Swim 🦘Word of the week 🙊Do we need an opinion on everything?

Sep 5, 2026

QOTW: Why are Tables so important?

Aug 22, 2026

QOTW: What Personal Projects have use built with Excel or Power BI

See all episodes →