Unpivot

UnpivotShow

Light-hearted discussion about Excel and Power BI - aimed at the business users of the world

  1. 1 DAY AGO

    Learning Limits, Kit Kats, Claude and Compatibility

    Wyn is back with tales of KitKats from Japan, Sue is away bathing in Ice Lakes, Giles is gearing up for life in a Campervan, and Mark is still not happy with =IMPORTCSV Worth a follow: Andy Cutler   Andrew Moss   Hilary Smart    Question of the Week: Can Anyone Learn Excel and Power BI   And then... 🚽 Phantom Toilet seats 🐙 Takoyaki  🚅Trapped on a Train 🚙 Giles on Tour 🔓 Unlocking Spreadsheets 🎣 Not Biting on LinkedIn 🔢 Versions in Excel      Unpivot Show Links Page Hosts Wyn Hopkins Mark Proctor and Giles Male ( absent Sue Bayes  )

    1h 8m

  2. 29 JAN

    If you could ask any question to the Excel World Champion, what would you ask?

    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 😡 New feature rant 🏃‍♀️ Running 51 miles in a week ➕ 99.5 is NOT 100 🍄 Mushrooms of knowledge 🚙 Back on the road again     Unpivot Show Links Page Hosts Mark Proctor,  Sue Bayes and Giles Male ( absent Wyn Hopkins, )

    1h 6m

  3. 8 JAN

    Are you ready for 2026?

    Question of the Week:   2026 Plans and coping with back to work blues. 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off  Warning: May Contain Traces of Technical Content 🍫🪓Chocolate Chisels ❄️Snow 🚃Stockholm 🛷 Stair Sledging 🦒Australian Christmas 🛞Wagon Wheels 🎯Long Distance Darts 😰January Blues 🤔2025 Review       Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor,  Sue Bayes and Giles Male.

    1 hr

  4. 20/12/2025

    Christmas Livestream - Die Hard Try Harder

    Watch on YouTube: YouTube Live Question of the Year:   Highlights and Lowlights of 2025 plus hopes for 2026 🧢👕Unpivot Merch 🌏Global Excel Summit: UNPIVOT for 10% off  Quiz of the year SharePoint Full Marathon Qualifiers Struggling with top 10 Features Die Hard Try Harder   Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor,  Sue Bayes and Giles Male.

    1h 2m

  5. 06/12/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

    1h 15m

  6. 22/11/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.

    1h 9m

  7. 08/11/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.

    1h 14m

  8. 01/11/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.

    1h 5m
See All (45)

Ratings & Reviews

5
out of 5
3 Ratings

About

Light-hearted discussion about Excel and Power BI - aimed at the business users of the world

Information

  • Creator
    UnpivotShow
  • Years Active
    2024 - 2026
  • Episodes
    45
  • Rating
    Clean
  • Copyright
    © Copyright 2024 All rights reserved.
  • Show Website
    Unpivot

You Might Also Like