DiscoverUnpivot
Unpivot
Claim Ownership

Unpivot

Author: UnpivotShow

Subscribed: 21Played: 424
Share

Description

Light-hearted discussion about Excel and Power BI - aimed at the business users of the world
43 Episodes
Reverse
Are you ready for 2026?

Are you ready for 2026?

2026-01-0801:00:28

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.  
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.
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 
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.  
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.
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.
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
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
Hardware Takes a Turn

Hardware Takes a Turn

2025-09-1401:07:17

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
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.
  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/
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.
Sue's back! Question of the Week:   How do you set things up for when you're away   Mark's offer: https://exceloffthegrid.com/modern-excel-formulas/   🔄️Pivot Refresh ☠️ Giles's new Tattoo ↔️ Excel compatibility versions 🐻 Running in the woods with Bears 🧑🏻‍✈️ Power BI Copilot Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor,  Sue Bayes and Giles Male.
Mr Excel

Mr Excel

2025-07-0501:10:08

It's the one and only Bill Jelen!  🫡 Find Bill's Channel here:  https://www.youtube.com/@MrXL/videos   Question of the Week:   Ask Bill Anything   💚Surprise Guest for Giles 💛 Awards for Mark And Giles 💚 Wyn's #Nightmare 💛 Bill's Fatboy Slim experience 💚 Publishing / Flighting / In Person / AI   Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor,  Sue Bayes and Giles Male.  
watch the video intro https://youtu.be/pzmaa74LErc?si=xydH-biTfjTbKUYh It's our 1-year anniversary and our Question of the Week is: What should and shouldn't you put on your CV and say in an interview   Also discussion around: 💚Excel Stats for Accountants 💛 Visual Calcs updates 💚 Clip-Champ 💛 Training day tips   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/ QotW: What motivates you? Other chat: AI Theft  Ultramarathon Can you keep up, how to avoid the stress 18 years as an MVP Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor,  Sue Bayes and Giles Male. 📢 Special Mention: The Secrets Behind the Graph: Mastering Any Chart in Excel | Laura Szepesi https://youtu.be/Hd_yfUr7pDo?si=giYOFS3i_EtDB3_x  
Data Hall Of Fame

Data Hall Of Fame

2025-05-2401:06:57

#Excel #PowerBI QotW: Who or What is in your Data Hall of Fame? Other chat: Trying to start the pod without Wyn Bike Thief #YouveBeenHumbled Giles Issue with Cheat Sheets explored Is it still worth writing blog posts? QotW Jingle Theft! Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.
Mark and Giles do a mini pod discussing recent Excel updates including Copilot Copilot Dark Mode Copilot 🙄 Tokens and more...  
#Excel #PowerBI Please leave a 5 Star Review ⭐⭐⭐⭐⭐ QotW: What is a Microsoft MVP? Other chat: Is Excel getting too complicated? Deb's Marathon horror story Dogs and Chocolate DUREX <> ANDREX Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Deb Ashby and Giles Male. EVERYTHING SEARCH TOOLBAR https://www.linkedin.com/posts/brianjuliusdc_windows-tipsandtricks-search-activity-7187144578196492288-6SmG/
Wyn and Sue try out a shorter 2-person pod discussing recent Power BI Updates including Live edit of semantic models in Direct Lake mode in Desktop F2 Capacity now can use Copilot Style Presets PowerPoint Annotation File Picker and more...     April Blog: https://powerbi.microsoft.com/en-us/blog/power-bi-april-2025-feature-summary/ Azure Maps https://powerbi.microsoft.com/en-us/blog/power-bi-april-2025-feature-summary/#post-29602-_Toc195631038   #PowerBI 🔗Other chat links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.
loading
Comments