Debra Dalgleish

Happy Pi Day! Excel's date format examples use March 14th. Tribute to Pi, or strange coincidence? #Excel #PiDay

With @msexcel now offering a native choice between @AnthropicAI Claude Opus 6.3 and @OpenAI GPT 5.2, I show how that Hanks Pizza Copilot commercial would have given even better advice by choosing Claude. youtu.be/HtgXkOFto3U

Yes, the results for Hank were definitely real. Nice analysis by @MrExcel... I often like running both models to check each others work. youtube.com/watch?v=oBqKKy… youtube.com/watch?v=HtgXkO…

BIG NEWS *INCREDIBLE DISCOVERY* Kathleen Pettigrew, the real Miss Moneypenny, private papers FOUND! A year ago I rushed down to #Sidmouth in beautiful Devon because the museum had received an anonymous donation. I couldn’t believe it. The trailblazing MI6 officer’s entire life contained within one simple storage box, a treasure trove of personal photographs, diaries, passports, mysterious reports and papers, maps, foreign currency, a plethora of personal, private and secret letters, as well as important MI6 ephemera never before seen. You can read all about the discovery in the paperback of #HerSecretService in the new Postscript. You can also look forward to future posts about the amazing items in the collection. I am delighted that the collection has recently been acquired by the Sid Vale Association and will be on future display at Sidmouth Museum for all to enjoy! I am speaking about Kathleen Pettigrew in Sidmouth tomorrow afternoon, Thursday 12 March. Event details in post below ⬇️ Please do join us. @wnbooks @NorthbankTalent @SidmouthMuseum @BBCDevon @sidmouthherald @DevonLiveNews @JeremyVineOn5 #womenshistorymonth #MI6 #spyhistory #herstory

In 2021, after 6 years of shopping at my local Sainsbury’s and tracking where I parked each time on a spreadsheet, I completed all 211 parking spots the store had to offer. In 2024 I moved to a new town - and guess what I’ve been busy doing since :) A thread 🧵

We've now fully switched over everyone with an M365 Copilot license to have Excel Copilot agentic by default: techcommunity.microsoft.com/blog/microsoft…

I'm excited to be leading my live #SelfServiceBI Boot Camp in London on May 18, 19, and 22 as part of @ExcelSummit! Not just for #DataAnalysts, it’s for anyone looking to harness the full potential of #BusinessIntelligence with #Excel and #PowerBI! Go to xlguru.ca/ssbi-london

▶️The recording for yesterday's Vancouver #PowerBI and Modern #Excel is now available: youtube.com/watch?v=mvGRsB… We loved hearing from Anne Walsh, an experienced Excel and Power BI trainer, who shared insights from more than 25 years of teaching Excel. 👩‍🏫

I'm looking forward to being back at this year's summit!

When I'm writing, I make a spreadsheet in Excel to keep track of my characters. I copy and paste their appearance and their age at each point in the narrative. This way, I’m less likely to give someone blue eyes in Chapter 5 and brown in Chapter 15.

Why does a #PivotTable count three Lines of Credit as “used” when one of them has a zero balance and shouldn’t be counted? 🤷🏾‍ And more importantly — do you need #PowerPivot and #DAX to fix it? Here, I'll show you that you don't: youtu.be/-X-ELoJ9Kiw #PowerQuery #ExcelTips

"Howdy Folks, I'm Michael Pyrcz, a professor at The University of Texas at Austin, and I record all of my lectures and put them on YouTube so anyone can follow along!" ...and I kept doing that, and writing a Python package, along with 2 free, online e-books, 100s of Python demonstration workflows, dozens of synthetic datasets, etc. etc. Why? So anyone can follow along! Education changes lives. I know because it changed mine. I’m just paying it forward.

During a recent Ask Ken Anything session, an attendee shared a frustration: “ChatGPT told me to create multiple calendar tables – should I?” 📆❓ I showed how smarter models come from understanding relationships, not adding tables. 💡 #PowerQuery #FinancialAnalytics #Excel

🎥The recording of last week's Vancouver #PowerBI and Modern #Excel meet-up is ready: youtube.com/watch?v=mNpUG9… Joseph Yeates shared what's new in PBI, and Cristian Angyal showed how #PowerQuery Custom Functions can reduce repetitive steps, improve maintainability and reusability.

It’s time to show your data a little love! 😍 Save 20% on all our #BusinessIntelligence courses through @skillwave_ from Feb 14-28. Go to skw-t.com/lovedata and use this code at checkout: LOVE20 (Offer excludes subscriptions to Ask Ken Anything.) #DataModeling #DataViz

In this episode of Monkey Shorts 🐵🩳, I'll show you how to keep your queries organized within #PowerQuery. In addition, you'll see how the #Excel Queries Pane and the Power Query Navigator Pane have some slight behavioral differences: youtube.com/watch?v=j7y3WI…

After 25+ years of providing #Excel training, you pick up a few lessons from the trenches... or should that be rows? At our Vancouver #PowerBI and Modern Excel meet-up on Mar 5, Anne Walsh will share the lessons she's learned teaching Excel. RSVP here: meetup.com/vancouver-powe…

In a recent AKA call, ! walked through how to adapt our standard #PowerQuery Approximate Match recipe to make it work with multiple criteria. Like recipes in the kitchen, you may need to add or substitute an ingredient or two. 🔑Strong models match on logic – not just keys.

@kpuls Thanks, Ken!

Very helpful!

If you prefer to keep your #PowerPivot or #PowerBI Measures on a dedicated measure table, I'll show you an easy way to create a measure table with #PowerQuery, and what you must do in order to avoid the "Relationships May be Needed" error in #Excel: youtube.com/watch?v=Mu0YFQ…