Look for any podcast host, guest or anyone
Showing episodes and shows of

UnpivotShow

Shows

UnpivotUnpivotWhat happens when you're away?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. 2025-07-191h 12UnpivotUnpivotMr ExcelIt'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.   2025-07-051h 10UnpivotUnpivotInterview and CV Advice - 1 Year Birthdaywatch 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.  2025-06-211h 06UnpivotUnpivotKen Puls, AI Theft, and the myth of keeping up🐒🔨🪛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   2025-06-071h 00UnpivotUnpivotData Hall Of Fame#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. 2025-05-241h 06UnpivotUnpivotExcel Updates Mini Pod May 2025Mark and Giles do a mini pod discussing recent Excel updates including Copilot Copilot Dark Mode Copilot 🙄 Tokens and more...   2025-05-1635 minUnpivotUnpivotWhat is a Microsoft MVP & Is it all getting too complicated?#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/ 2025-05-101h 13UnpivotUnpivotMini Pod - Power BI Updates April 2025Wyn 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 P...2025-05-0330 minUnpivotUnpivotThe Value of Experience#Excel #PowerBI Please leave a 5 Star Review ⭐⭐⭐⭐⭐ (if we've inspired you to do exercise) QotW: What Value does Experience Have? Other chat: Sue's Swag Becoming fitness influencers Editor's Note-gate Excel Speedrun Power BI course announcement Advanced vs beginner training challenges Merch and Staying Humble Links to hosts and other content Unpivot Show Links Page Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male. Brian Julius DAX Helper https://www.linkedin.com/posts/brianjuliusdc_dax-ai-prompting-activity-7298279526210387968-qhHM/?utm_source=share&utm_medium=member_ios&rcm=ACoAAAJrY_Q...2025-04-251h 02UnpivotUnpivotLivestream with Oz Du Soleil - what drives us to make changes?#Excel #PowerBI Find Oz here: www.youtube.com/@OzduSoleilDATA Oz's songs (YouTube) Tin Man by America On and On by Stephen Bishop QotW: What Drives us to make changes Other chat: QUIZ! Oz goes deep Sue is late, but gets a song Mark meets his target Please leave a 5 Star Review  Links to hosts and other content Unpivot Show Links Page   Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male. 2025-04-111h 27UnpivotUnpivotTime Quotes, 100k Subscribers and Black Box Lambdas#Excel #PowerBI QotW: How to quote for work and estimate time. Other chat: What's the secret to 100K subscribers Are Lambdas a black box? Giles toys with occupational ruin. Sue is not happy with Mark Mark drops shade on Wyn's REGEX idea Please leave a 5 Star Review  Links to hosts and other content Unpivot Show Links Page   Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male. 2025-03-291h 03UnpivotUnpivotData Visualisation Choices in Power BI in ExcelPlease leave a 5 Star Review ⭐⭐⭐⭐⭐ Links to hosts and other content Unpivot Show Links Page QotW: What data visualisation choices do you make? Other chat: Sue chats to everyone Mark chats to no-one Wyn geeks out over PowerToys Giles discusses his port-folio of news Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   💊Giles Ali Torban : https://www.linkedin.com/in/allisontorban/ 🏃🏻‍♂️Mark Stephanie Evergreen https://stephanieevergreen.com/ Book: Effective Data Visualization Robert Mundigl: https://www.clearlyandsimply.com/clear...2025-03-151h 07UnpivotUnpivotJon Acampora, Shirts, Coding and things people get stuck on.Special Guest:  Jon Acampora of Excel Campus Stay tuned to the end for bonus shirt count! QotW: Which features, techniques or concepts do most people get stuck on? How can we make it understandable? Other chat: Sue discovers the Automate tab in Excel Mark takes researching guests too far Jon reveals how many shirts he has Giles dances while cheat sheets fall from the sky Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male. Links to watch and more Unpivot Show Links Page2025-03-011h 13UnpivotUnpivotExcel Summit ABBA and Presentation Tips  QotW:  What are you tips for delivering good presentations Other chat: Mark explains why he doesn't like Chris Webb Giles is sick but soldiers on Sue did DP700 exam and presentation Wyn needs to work on Irish names   Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI 2025-02-151h 21UnpivotUnpivotCopilot Fail and Work Life Balance  QotW:  Can we achieve Work Life Balance? Other chat: Commitments update Wyn rants about Copilot Giles gets invited onto a radio show during the recording Mark gets a new webcam Sue is getting ready for a BIG presentation Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI 2025-02-011h 03UnpivotUnpivotWhen does a business outgrow Excel and Power BI?  QotW:  Can majority of businesses run on Excel and Power BI alone? Commitments update Giles rants about LinkedIn copyright infringement What makes for good visuals At what point do you outgrow Excel Main Topic: Once again we ran out of time! Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI 2025-01-181h 06UnpivotUnpivotShould Power BI be part of Fabric - who is Fabric aimed at?Main Topic: Should Power BI be part of Fabric? QotW: Goals / Resolutions  Christmas Catch up and New Year's resolutions We struggle with maths - How many pies per day does Mark need to eat, how many pounds in 15 stone Mark gets on a hobby horse Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI 2025-01-041h 00UnpivotUnpivotChristmas Livestream Uncut - Live and UneditedMore chaotic than normal and also unedited due to the livestream nature. Hope you enjoy it even if sound is not up to usual standard and some of the content makes more sense if watching. YouTube: https://www.youtube.com/live/T05qrByEarg?si=7QW3uaMwwYfYcFbC 🎄Christmas Quiz🎄 🎄Favourite Features of 2024🎄 Hosts Wyn Hopkins,  Mark Proctor, Sue Bayes, Giles Male.   #Excel #PowerBI 2024-12-201h 08UnpivotUnpivotChandeep Chhabra - Wow Factor Demos - Adapting when moving from Excel to Power BIThanks to special guest Chandeep Chhabra.   QotW:  What’s your show off / wow factor demo / trick?  Main Topic: How to think about Power BI and DAX and the transition from Excel Power BI?   Hosts Wyn Hopkins,  Mark Proctor, Sue Bayes, Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI 2024-12-071h 27UnpivotUnpivotThe Diarmuid Early Episode. Competitions, Challenges and Productivity Toolkit recommendationsThanks to special guest Dim Early   QotW: Does taking part in competitions and challenges help in the real world? If so… how? What skills do they not teach you? Main Topic: What are the best methods for building a personal toolkit for productivity?   Hosts  Mark Proctor, Sue Bayes, Giles Male.   Watch https://www.youtube.com/@Unpivot #Excel #PowerBI 2024-11-261h 11UnpivotUnpivotWhat features would you add to Excel or Power BI & Starting your own businessMark lays down a challenge to who has the easiest dependent drop down list technique Giles is glad not to be in charge and has become a Lambda Lover Sue has run ANOTHER marathon! Wyn has an embarrassing rant online. QotW: What Features would you add to Excel?  Main Topic:  Motivations and Challenges of starting your own business   Mark’s video on Easiest Dependent Drop Downs Wyn's video on Easiest Dependent Drop Downs Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.  2024-11-101h 22UnpivotUnpivotWhen are you an expert and are technical books still relevant?🙏🏻 Special Guest: Rick De Groot ( Gorilla.Bi )  (  Power Query How - Home of the M Language ) QotW: When are you an expert?  Main Topic:  Are technical books still relevant in the world of AI?   Join the conversation on LinkedIn https://www.linkedin.com/company/the-unpivot-show Hosts  Giles Male, Mark Proctor, Sue Bayes, and Rick de Groot 2024-10-261h 08UnpivotUnpivotLate to the Party and Presentation TipsQotW:  What features were you late to discover but now love Main Topic:  Presentation Tips and tricks    Join the conversation on LinkedIn https://www.linkedin.com/company/the-unpivot-show Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   Watch https://youtu.be/LNgzqrepyic #Excel #PowerBI Host Host: Wyn Hopkins is a Power BI and Excel expert known for simplifying complex business intelligence solutions. 2024-10-121h 06UnpivotUnpivotGiles MVP Award and advice to your 20-year-old selfWe also discuss Best Practice  Links mentioned: 1️⃣ Giles MVP award video 2️⃣ Spreadsheet Best Practice Rules 3️⃣ Question Of the Week on LinkedIn Hosts Wyn Hopkins, Giles Male, Mark Proctor and Deb Ashby   YouTube 2024-09-2856 minUnpivotUnpivotEssential Functions and when formulas go wrongLinks mentioned: Data Scotland: https://datascotland.org/ Chris Barber: https://www.starschema.co.uk/  Hosts Wyn Hopkins,, Sue Bayes, Giles Male, and Mark Proctor.   YouTube 2024-09-141h 09UnpivotUnpivotExcel and Power BI Dangerous Features and what to learn?Welcome back Mark! Training Resources: https://pbi.guide/resources/ https://learn.microsoft.com/en-us/?WT.mc_id=M365-MVP-5002589  https://exceloffthegrid.com/  https://www.fullstackmodeller.com/  https://skillwave.training/  https://www.w3schools.com/python/default.asp  Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   YouTube   2024-08-301h 03UnpivotUnpivotExcel v Power BI and what would you change about them 🙏🏻Thanks to special guest Cristian Angyal https://www.linkedin.com/in/cristian-angyal Romania Power BI and Modern Excel User Group | Meetup 🔗Links mentioned in show Ideas: Power BI https://ideas.fabric.microsoft.com/ideas/ Ideas: Excel  https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472     Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   YouTube   2024-08-171h 08UnpivotUnpivotTikTok, Training, and Top Voice 🙏🏻Thanks to special guest Deb Ashby https://www.tiktok.com/@cellmates_ https://www.linkedin.com/in/deborahashby/   🔗Links mentioned in show PowerToys: https://learn.microsoft.com/en-us/windows/powertoys/install Forums: Mr Excel: https://www.mrexcel.com/board/ Power BI Community: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi Excel Tech Community: https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral Reddit Excel: https://www.reddit.com/r/excel/ Reddit Power BI: https://www.reddit.com/r/PowerBI/ 2024-08-031h 25UnpivotUnpivotWorst Mistakes, LinkedIn and CommunityA light hearted discussion about Excel, Power BI and some other occasional tech. Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.   YouTube 2024-07-201h 01UnpivotUnpivotTables and Imposter SyndromeThe one where we discuss Jon Acampora's post that he's stopped recommending Excel Tables and whether we fear we are falling behind with the rapid pace of change. The Kurt Buhler post Does it feel like too much? — DATA GOBLINS (data-goblins.com) A light hearted discussion about Excel, Power BI and some other occasional tech. Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male. 2024-07-0656 minUnpivotUnpivotIntros and AI HypeThe one where we introduce ourselves, chat about Excel World Championships, REGEX, Power BI, Copilot, ChatGPT, running, Sue discovers she’s a programmer, and Mark’s ability to now fit in an old suit. A light hearted discussion about Excel, Power BI and some other occasional tech. Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male. 2024-06-281h 00