Unpivot

By UnpivotShowBusiness Technology

Unpivot episodes

December 06, 2025 Red Flag Finds - and a Chris (tmas) Angyal
Question of the Day: When you open a file what are the Red Flags 🚩 that indicates it wasn't created by an expert?

Special Guest Cristian Angyal https://www.linkedin.com/in/cristian-angyal/

🔄️ Will Online Schedule refresh ever come to Excel?
🔏 Password Weakness in Excel
👉🏻 SharePoint List Refresh speed up
🐍 Python in Google https://colab.google/

🚩Any File not created by Mark

🧢👕Unpivot Merch

🌏Global Excel Summit: UNPIVOT for 10% off
1 hr 15 min
November 22, 2025 Best Practice Confessions & Terminology Overload
Question of the Week: What are Best Practices you ignore?

🧢👕Unpivot Merch

🌏Global Excel Summit: UNPIVOT for 10% off

Be prepared for some shocking confessions:
📅 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

Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.

1 hr 10 min
November 08, 2025 Trolls, New Features and Common Data Problems
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

Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.

1 hr 15 min
November 01, 2025 More AI Hype and Modeling Mistakes to Avoid
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

Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
1 hr 5 min
October 11, 2025 Deb, Leila and the Humble MVP
Question of the Week: What shall we ask Deb and Leila?

🚩Red Flags
🦹Serial Killer Tips?
🤖 Excel Agent Mode
➡️ Swipe Right?
❓Excel Autocomplete
🏃‍♀️‍➡️ Is Speed Good?
🔢 Prompt Bingo
🍓Strawberry Laces
🩳Short Shorts?
🎛️ Video Editor Tips

Thanks to our special Guests
Deb Ashby Cellmates - YouTube
Leila Gharani https://www.youtube.com/@LeilaGharani

Links to regular hosts and other content
Unpivot Show Links Page
1 hr 6 min
September 27, 2025 Conference and Networking Hacks
Question of the Week: What's your Conference and Networking tips / hacks?

🥨Vienna Fabcon
🤝All about the members
🗞️News - Dataflows Gen 2 and UDFs
😶‍🌫️ How to Enter and Exit a conversation
⌛ Time Capsule

Thanks to our sponsor 😆✈️Cabeau https://cabeau.com/products/evolution-s3-neck-pillow

Links to hosts and other content
Unpivot Show Links Page
1 hr 4 min
September 14, 2025 Hardware Takes a Turn
Question of the Week: What's your favourite hardware?

⌚Tardy Giles
🎤 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

Links to hosts and other content
Unpivot Show Links Page
1 hr 8 min
August 30, 2025 =COPILOT Rant, AI Hype and Competitive Excel Pressure
NO QUESTION OF THE WEEK???!!!
Too much other stuff to chat about...

⌚Tardy Mark
😥Competition Pressure
🧘🏻‍♀️Sue's Zen advice
🎤East 17 Tribute Band request
😡Wyn's =COPILOT rant
💡Mark's =COPILOT use case
🥰Brian Julius Shout Out https://www.moderndata101.com/network/brian-julius
🔢 32,767
💚XLOOKUP day
🫶🏻 - Fwends
🐁Mark's wired

Links to hosts and other content
Unpivot Show Links Page

Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
1 hr 1 min
August 16, 2025 What technology are you ignoring - with Ken Puls

Special guest Ken Puls returns to the pod this week.

Question of the week: What technologies are you currently ignoring and why?

Other topics:
😴 Falling asleep during presentations
🐻 Out running a bear
🙊 Don’t say the C word
💬 Arguing with AI

Links to hosts and other content
Unpivot Show Links Page

Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
🐒🔨🪛Ken Puls: https://excelguru.ca/
1 hr 4 min
August 03, 2025 What are your favourite defaults?
Question of the Week: What are your favourite defaults and what would be on your wish list?

We all learn something new in this episode!!

🗣️ Wyn's emphasis game and talking to a wall
💙 Join us on BlueSky
⚓ Giles's ever-growing tattoo
🎬 Editing v just getting it out there
👁️Strava , social networks and why Mark left Facebook
Links to hosts and other content
Unpivot Show Links Page

Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
1 hr 2 min