This week we have special guest Dim Early - the reigning Excel World Champion - who took part in our new feature called “If you could ask any question to the Excel World Champion what would you ask? But since you’re not hear we’ll ask on your behalf”. It’s not a catchy title but it is descriptive 😁

Plus, we had Question of the Week: To be an expert, what’s more important, depth of knowledge of breadth of knowledge.

And there where the usual set of unexpected revelations

🎤 Mic drops

🏃‍♀️ Running 51 miles in a week

➕ 99.5 is NOT 100

🍄 Mushrooms of knowledge

🚙 Back on the road again

Unpivot Show Links Page

Question of the Week:   2026 Plans and coping with back to work blues.

🍫🪓Chocolate Chisels

Unpivot Show Links Page

Watch on YouTube: YouTube Live

SharePoint Full

Marathon Qualifiers

Struggling with top 10 Features

Die Hard Try Harder

Unpivot Show Links Page

Question of the Day:   When you open a file what are the Red Flags 🚩 that indicates it wasn't created by an expert?

Question of the Week:   What are Best Practices you ignore?

📅 Wyn doesn’t set date tables

🧮 Giles abandons simple formulas

➡️ Mark uses Merge & Centre

🧹Sue leaves unused measures to collect dust

Plus, there the usual unexpected revelations:

🙎‍♂️ Mansplaining remains un-explained

📋 Ontology becomes an everyday word

🎄 Who gets invited to Christmas parties?

🥊 Power BI vs Excel… Bring it on.

🛌 Stickering a hotel room

💻 Is Export to Excel OK?

Unpivot Show Links Page

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 Page

Question of the Week:   What are your top 3 modeling mistakes to avoid. 

👾 10 Goto 20 - Reminiscing Coding and Games of the Past

😬 Mark feels like a spare part ( "I do not think that word means what you think it means")

😳 Giles suffers from foot-in-mouth disease

🤖 AI over-Hyped?  Surely not?

🍫 Will chocolate ever be a healthy snack?

Unpivot Show Links Page

Question of the Week:  What shall we ask Deb and Leila?

🦹Serial Killer Tips?

🤖 Excel Agent Mode

➡️ Swipe Right?

❓Excel Autocomplete

🏃‍♀️‍➡️ Is Speed Good?

🔢 Prompt Bingo

🍓Strawberry Laces

🩳Short Shorts?

🎛️ Video Editor Tips

Unpivot Show Links Page

Question of the Week:  What's your Conference and Networking tips / hacks?

🤝All about the members

🗞️News - Dataflows Gen 2 and UDFs

😶‍🌫️ How to Enter and Exit a conversation

⌛ Time Capsule

Unpivot Show Links Page

Question of the Week:  What's your favourite hardware?

🎤 Rap Review

❎ Sue's XLOOKUP admission

⌨️Fn Backspace

🕜Sue's mysterious object

🤬Cross(ed) Wires - the most boring topic so far goes off!

⏲️ They call him Mark "High-Tech" Proctor

🦶🏻Foot Fans?

✈️Cabeau https://cabeau.com/products/evolution-s3-neck-pillow

Unpivot Show Links Page