Best Query Core Podcasts (2025)

1
Python in Excel: Practical applications 11:02

Play Pause

12d ago11:02

11:02

In this second episode of a three-part series, you will build on the basics from part one to gain a clear understanding of how to use Python directly within Excel cells. This includes using the Pandas library, for example, to merge datasets and create data-rich outputs with minimal code. You’ll gain the skills to: Learn key differences between Exce…

1
Getting started with Python in Excel 9:07

1M ago9:07

9:07

Unlock the potential of Python in Excel with this essential first episode in a three-part series. Designed for accountants, finance professionals and Excel power users, this episode introduces the basics of integrating Python code directly into Excel cells. Learn how Python enhances Excel’s capabilities for data handling and visualisation without r…

1
Excel’s GROUPBY and PIVOTBY explained 12:37

2M ago12:37

12:37

Excel’s new functions, GROUPBY and PIVOTBY, offer a smarter way to build reports. Instead of relying on traditional pivot tables, these new tools allow you to summarise datasets using dynamic, formula-based solutions that update automatically when the underlying data changes. In this episode: Understand the key differences between GROUPBY and PIVOT…

1
Better share price reports with Excel’s new tool 12:49

4M ago12:49

12:49

Need to turn stock market data into smart, professional reports? Discover how to use Excel’s new and powerful Stock History function to quickly transform raw share price data into clear, insightful reports. Learn how to streamline reporting, visualise trends and make better-informed decisions with ease. In this episode, gain the skills to: Access d…

1
Elevate your Pareto analysis skills with Excel 10:47

5M ago10:47

10:47

The Pareto principle is a powerful concept for business. In this episode we’ll explore this principle (also known as the 80/20 rule) and learn how to apply it effectively in Excel for smarter, data-driven decisions. Discover how to pinpoint vital data – such as the 20 per cent of clients generating 80 per cent of your revenue as an example – to cre…

1
Unlock the power of Microsoft Forms in Excel 10:14

6M ago10:14

10:14

What if you could seamlessly collect and analyse data right inside Excel? In this episode, learn more about Microsoft Forms, a powerful tool in Microsoft 365 (which, by the time you read this may be renamed Microsoft 365 CoPilot). Discover how Forms integrates directly into Excel, making it easier than ever to gather feedback, conduct quizzes, and …

1
New tool explained: boost your efficiency with checkboxes 10:01

6M ago10:01

10:01

Ready to unlock a hidden gem in your Microsoft Excel subscription? In this episode you’ll discover the power of checkboxes with practical examples to explore how this new function can streamline your workflow. This includes how to use TRUE/FALSE values in formulas and conditional formatting to dynamically control calculations and visuals. Learn fro…

1
Innovating with .NET Core and Blazor Across Platforms with Jeff Fritz - NET 214 1:09:07

7M ago1:09:07

1:09:07

In this exciting episode of Top End Devs, we dive into the world of .NET development with none other than Jeff Fritz, a recognized community manager at Microsoft. Hosted by Sean Clabo and co-hosted by Caleb Wells and Wailu, this episode explores Jeff's impressive journey from working in the finance and pharmaceutical industries to becoming a pivota…

1
What is Command Query Responsibility Segregation (CQRS) with Derek Comartin - .NET 213 50:14

7M ago50:14

50:14

In this episode of Adventures in .NET, guest Derek Comartin talks to us about Command Query Responsibility Segregation. He explains CQRS benefits, downsides and usage in real world situations. Links MediatR Brighter CodeOpinion Jimmy Bogard Picks Shawn - A First Look at Unreal Engine 5 Caleb - DragonHumpers Wai - Ring Fit Adventure Derek - Build St…

1
Improve your PDF data handling with Power Query 12:43

8M ago12:43

12:43

Ever struggled to extract crucial financial data from PDF files into Excel? As accountants and finance professionals, this can be a regular occurrence. To help you, this episode explores Microsoft Excel’s Power Query feature. You’ll uncover how to seamlessly import data from system-generated PDFs like invoices and statements. From tackling tricky f…

1
All .NET Stack All The Time - .NET 212 20:17

8M ago20:17

20:17

Caleb recently started a new job. The project he is working on is all in .NET (MVC, Web Api, Azure, etc.). Caleb and Shawn discuss some of the features of MVC and Power BI that Caleb is learning on the fly. Join us for a quick episode all about .NET Picks Shawn - Drive-in Movie Theaters Caleb - HP Spectre x360 Become a supporter of this podcast: ht…

1
Product Management? - .NET 211 28:53

8M ago28:53

28:53

Most developers we know find project management to be a necessary evil but without it a lot of us would be stumbling around in the dark. Shawn and Caleb look back over their careers to discuss different project management methodologies. Whether it is waterfall, agile, scrum, or none of these, projects are hard to manage. Both Shawn and Caleb have s…

1
Getting into Source Generators in .Net - .NET 210 30:55

8M ago30:55

30:55

Unsure about how and why to use Source Generators in .NET? Stefan Schranz explains them in an easy-to-understand way. He compares them to T4 templates and explains that there’s a new and more powerful way to generate code. Learn about how to get started, the limitations, and their use cases in this episode. Links Getting into source generators in .…

1
Blangular (Blazor + Angular) - .NET 209 27:12

8M ago27:12

27:12

Have you ever thought about mixing two SPA frameworks together? In today's episode we discuss doing just that, Blazor and Angular running in the same application. Both Angular and Blazor have ways to export code as web components that can be reused in other applications. In order to use Angular in Blazor you have to get familiar with IJSRuntime and…

1
Blockchain on Azure - NET 208 1:04:54

9M ago1:04:54

1:04:54

Today we take a look at how Microsoft is working with blockchain in Azure. Stefano Tempesta is a senior program manager at Microsoft on Azure confidential computing. Azure confidential computing focuses on securing data in use and one of the technologies they are working with is blockchain. Microsoft is working to develop blockchain solutions that …

1
Handy hack to create timeline charts 10:29

9M ago10:29

10:29

Excel doesn’t have a built-in timeline chart but we’ll show you how to create one. In this episode you’ll learn how using a scatter chart can help you build a timeline chart. For easy reference, here are the episode timestamps: 0:17 - About timeline charts in Excel 1:33 - Hacking the scatter chart to make a timeline chart 2:43 - Formatting dates us…

1
Interactive C# with VS Code Notebooks with Eric Potter - NET 207 35:25

9M ago35:25

35:25

VS Code Notebooks provides a way to write quick interactive C# along with documentation to learn and train with. Links .NET Interactive Notebooks Aptera Software Humble Toolsmith Binder Project Jupyter | The Binder Project LINQPad - The .NET Programmer’s Playground Twitter: Eric Potter ( @pottereric ) Picks Eric- Concurrency in C# Cookbook Shawn- B…

1
Performant Applications using the Actor Pattern & Akka.NET with Aaron Stannard - .NET 206 1:08:08

9M ago1:08:08

1:08:08

Aaron Stannard joins the Adventures in .NET team this week to discuss Akka.NET. He digs into the Actor model, the reasons to use it and what gave him the impetus to port Akka to .NET. Links https://petabridge.com/bootcamp Building Your First Whiskey Collection Picks Shawn - Locke & Key Caleb- Animal Crossing: New Horizons Joel - Fender Special Edit…

1
Product Management? - .NET 205 28:53

9M ago28:53

28:53

Most developers we know find project management to be a necessary evil but without it a lot of us would be stumbling around in the dark. Shawn and Caleb look back over their careers to discuss different project management methodologies. Whether it is waterfall, agile, scrum, or none of these, projects are hard to manage. Both Shawn and Caleb have s…

1
Integration Testing - The Why and How - .NET 204 49:08

9M ago49:08

49:08

We talk to Martin Costello - a .NET developer with a QA background - about integration testing. We walk through the different types of automated testing and discuss the benefits and purpose for each type. Martin introduces us to useful tools he uses to write tests within the .NET ecosystem and discusses what we should and shouldn't be testing as we…

1
Master calendar creation in Excel 17:14

10M ago17:14

17:14

Calendars are your go-to tool for planning. In this Excel Tips episode, you'll learn the steps to create a single-month calendar from scratch. Discover how to combine advanced functions to build a two-dimensional calendar structure, and how to format your dates and highlight weekends and holidays. You'll also gain knowledge of how to customise the …

1
Creating Developer Courses with Taurius Litvinavicius - .NET 203 38:03

10M ago38:03

38:03

In this episode of Adventures in .NET, the panel discusses creating Udemy developer courses and .NET Core APIs with course author Taurius Litvinavicus Links https://www.udemy.com/user/taurius-litvinavicius/ Picks Shawn - The Shannara Chronicles Caleb - www.amazon.com/Boys-Season-Official-Teaser-Trailer Wai - Orai Taurius - Azure DevOps Become a sup…

1
Modern Identity: From Internal Directories to Cross-Domain Identity Over the Public Internet with Bobby Johnson - .NET 202 49:45

10M ago49:45

49:45

Bobby Johnson introduces us to modern identity and the use of external providers to outsource your authentication layer. Links Have I Been Pwned: Check if your email has been compromised in a data breach Picks Bobby - Follow Bobby on Twitter @NotMyself , Github, Website Bobby - The Live Coders Bobby - Rest Client Shawn - Follow Shawn on Twitter > @…

1
Microservices Security in Action with Prabath Siriwardena - .NET 201 53:14

10M ago53:14

53:14

Microservice architecture is very popular today. The panel talks with microservice security authors about their book and all aspects of securing microservices. Links Microservices Security in Action: Design secure network and API endpoint security for Microservices applications, with examples using Java, Kubernetes, and Istio APIsecurity.io Picks S…

1
.NET Microservices: From Code To Containers To Steeltoe with David Dieruf - .NET 200 1:07:26

10M ago1:07:26

1:07:26

In this episode of Adventures in .NET, guest David Dieruf joins the panel to discuss .NET microservices. They clear up the confusion about what microservices are and how to use them? Links Steeltoe Project Tye dieruf.net Picks Shawn - Doom Eternal Wai - Tandem David - Identity Server Become a supporter of this podcast: https://www.spreaker.com/podc…

1
091: Season 5 Wrap-up 42:39

11M ago42:39

42:39

Una and Adam recap the season! They share their favorite features, stories, and use cases. Season 5 covered popovers, dialogs, top layers, trig functions, color functions, :has() tricks, balanced text wrapping, linear() easing, nesting, anchoring, state queries, view transitions, and scroll driven animation. What a year for CSS! Una Kravets (co-hos…

1
Moving .NET Solutions to Kubernetes with Andrew Lock - .NET 199 57:17

11M ago57:17

57:17

In this episode of Adventures in .NETm we get deep into .NET with Andrew Lock. Kubernetes, .NET Framework to .NET Core and everyone’s favorite topic configuration. Join us and you are guaranteed to learn something new. Links https://andrewlock.net https://helm.sh/docs/chart_best_practices/templates https://helm.sh https://www.jetbrains.com/rider Jo…

1
How to add a user interaction into Power Query 11:57

11M ago11:57

11:57

Reports are crucial to your work, aren't they? Power Query is a valuable tool for importing many types of data into Excel to help you create these reports. However, it does have limitations. In this episode, you’ll learn how to address one of Power Query’s key shortcomings: user interactions. By using staging queries, reference techniques and range…

1
090: Scroll-driven animations 46:33

11M ago46:33

46:33

In this episode our esteemed guest returns! This time to help us grok Scroll Driven Animation. Learn all about scroll(), view(), animation-timeline, timeline-scope, animation-range, and more. Power those animations with off-the-main-thread CSS scroll animation powers. Resources: Bramus's Demos: All mentioned Demos + Tools + Video Course + DevTools …

1
The S in KISS…..Embracing simplicity with Guilherme Ferreira - .NET 198 1:02:39

11M ago1:02:39

1:02:39

Today we look at using simplicity both in your code at work an in your life and why the two are intertwined. How to bring Occam’s Razor to work to help keep projects from getting out of hand. A better way to look at dead time and why its necessary to allow your mind to rest. Links OMNIA-Low-Code Business Application Development Platform Embracing S…

1
089: View transitions 41:51

11M ago41:51

41:51

In this episode Una and Adam bring on an esteemed guest Bramus, who brings us deep knowledge on View Transitions. These are easy to get started with but difficult to master, but not with Bramus here to teach us. He'll be covering introductory to advanced API features and a big bag of examples and demos. Resources: Developer Documentation → https://…

1
088: State queries 23:13

11M ago23:13

23:13

In this episode, Una and Adam discuss a future web capability that builds on container queries: state queries. From CSS, this feature will be able to detect if a container is overflowing, when an element is scroll snapped, and when an element is stuck from position: sticky. Resources: :stuck, :snapped, :on-screen, etc → https://goo.gle/3WVhSi6 stat…

1
Learn a smart way to hide blank or zero rows 9:36

12M ago9:36

9:36

Looking to improve your report-building skills? If so, this is the episode for you. Uncover tips on how to leverage multiple Excel features to create a system that effortlessly hides blank and zero rows in your reports. Also in this episode, you’ll discover the subtotal function’s superpower and learn how you can use it to help identify if a filter…

1
087: Anchor positioning 38:02

12M ago38:02

38:02

In this episode Una and Adam explain anchor positioning and all its amazing features. Resources: Introducing the CSS anchor positioning API → https://goo.gle/3SWrvM5 CSS anchor positioning → https://goo.gle/4dwgmd9 Tab’s talk from CSS Day → https://goo.gle/4ds8g5B Una's Anchor Tool → https://goo.gle/3yDYDSd Una Kravets (co-host) Twitter | Instagram…

1
How Do You Grow? - .NET 197 40:52

12M ago40:52

40:52

Most developers we know are constantly learning new things and growing their skills. Jort Rodenburg has been a book reviewer for Manning for several years and was approached to write a book on C# which he thought would be a great opportunity to grow. His book, Code like a Pro in C#, was a great learning experience for him and is intended to help br…

1
086: Nesting 2024+ 8:10

1y ago8:10

8:10

In this episode Una and Adam catch you up to the latest syntax features of CSS nesting. Resources: Episode 47 → https://goo.gle/3SvM9T4 Episode 65 → https://goo.gle/3ygA7X1 CSS Nesting Update → https://goo.gle/3WHCRpK Una Kravets (co-host) Twitter | Instagram | YouTube Making the web more colorful ✨🎨 Web DevRel @googlechrome Unicorn face host of @t…

1
NET Tools and Azure for .NET developers with Tim Heuer - .NET 196 55:36

1y ago55:36

55:36

Tools like Intellicode and LiveShare make developers more productive. Tim Heuer discusses with the panel about what Azure is good for and what tools help with leveraging it best. Links Visual Studio Roadmap Picks Tim - GitHub Actions Tim - Bardstown Podcast Shawn - JetBrains Monos Caleb - Darknet Diaries Caleb - Malicious Life Wai - Blindness Harve…

1
085: Linear easing function fun 16:10

1y ago16:10

16:10

In this episode Una and Adam cover the linear() CSS easing function that can create bounce and spring effects. Resources: Ep 22 on Animation → https://goo.gle/4frnp8y linear() generator → https://goo.gle/46xs2JZ Complex animation curves in CSS with linear() → https://goo.gle/4ftm0Oz Open Props premade spring and bounce variables → https://goo.gle/4…

1
The power of heat maps for sales and costs data 9:41

1y ago9:41

9:41

Looking for ways to gain deeper insights from your sales and costs data in Excel? This episode explores the power of heat maps, a data visualisation technique often used for climate data, but equally effective for business analysis. For fast access, use these timestamps: 0:15 – Using heat maps for sales and cost information. 1:59 – Colour scales op…

1
Containers with Michael Jolley - .NET 195 47:01

1y ago47:01

47:01

Michael Jolley joins us to talk all things containers, live coding and being bald! Michael is a Developer Advocate for Vonage with 20+ and does live coding multiple days a week on twitch as baldbeardedbuilder. .NET Summit Belarus 2020 | Get 15% off tickets with promocode DOTNETtoDEVCHATTV15 Links SQL Server in Containers Picks Michael - Follow Mich…

1
Enhancing .NET Development: Visualization Tools and Open Source Contributions - .NET 194 52:02

1y ago52:02

52:02

In this episode, they dive deep into the world of development tools and open-source contributions. They explore the unique benefits of JetBrains' Rider versus Visual Studio, highlighting Rider's compatibility and extensibility across platforms. They also discuss how Stack Overflow's evolving landscape, influenced by tools like GitHub Copilot and ch…

1
084: Text Wrap 12:47

1y ago12:47

12:47

In this episode Una and Adam talk about text wrap, a great modern improvement to typography on the web platform. Learn how you can create logical layout rules for your headings and other copy with just one line of code. Resources: text-wrap on MDN → https://goo.gle/3zvwixd soft breaks → https://goo.gle/4cXKLAq Una Kravets (co-host) Twitter | Instag…

1
Community is Key - .NET 193 42:50

1y ago42:50

42:50

Andrea Angella has been involved in many communities over the course of his career and it has helped him become the developer he is today. In this episode of Adventures in .NET we discuss starting out as a .NET developer, being mentored, mentoring others, .NET meetups and staying up-to-date with .NET. There are myriad benefits to being a part of a …

1
083: :has() tips and tricks 36:14

1y ago36:14

36:14

In this episode Una and Adam expand on episode 61 about :has() by focusing specifically on use cases, tips and tricks. Get inspired and discover new ways to make reactive UI from CSS. Resources: Ep 61 → https://goo.gle/4cID6pE Piccali → https://goo.gle/4ePKJMG Ahmad Shadeed → https://goo.gle/4bsk85F The Looper → https://goo.gle/3yKmXkI Una Kravets …

1
Mastering Dotnet Testing: Using Verify to Minimize Assertions - .NET 192 1:00:56

1y ago1:00:56

1:00:56

In this episode, they dive deep into the world of software development. Adam and Shawn are joined by special guest Simon Cropp. Together, they embark on a comprehensive discussion about snapshot testing in the dotnet ecosystem, with a specific focus on the powerful tool known as Verify. You'll learn about the different APIs for managing values, the…

1
3 powerful macros to streamline your workflow 9:13

1y ago9:13

9:13

There's a misconception that Excel macros are outdated or unnecessary. In this episode we set the record straight and explore their continued value. Delve into three practical macros that can streamline various tasks in your Excel workflow. More importantly, you’ll come away with the knowledge to decide when creating a macro makes sense for optimis…

1
082: What's new in color & color functions 18:24

1y ago18:24

18:24

In this episode Una and Adam provide a color update, covering changes to the specs and new functions. Links RCS calc() tool → https://goo.gle/4cRRJHt Apple Annie CSS Color Modules and Changes, Part I → https://goo.gle/3xtTr2A Lea verou article on RCS for contrast → https://goo.gle/3L3x5YF Una Kravets (co-host) Twitter | Instagram | YouTube Making t…

1
Microservices Security in Action with Prabath Siriwardena - .NET 191 53:15

1y ago53:15

53:15

Microservice architecture is very popular today. The panel talks with microservice security authors about their book and all aspects of securing microservices. Links Microservices Security in Action: Design secure network and API endpoint security for Microservices applications, with examples using Java, Kubernetes, and Istio APIsecurity.io Picks S…

1
081: Trigonometric Functions 43:04

1y ago43:04

43:04

In this episode Una and Adam share practical use cases, syntax and strategies for all the new math functions in CSS. From trig to algebra, they'll help you get a good idea on where and how these fit into your UI toolbelt. Links Ana Tudor tests your browser for CSS math function support → https://goo.gle/4cmBm5r Great guide and overview from Daniel …

1
80: Animating to and from top-layer 31:23

1y ago31:23

31:23

In this episode Una and Adam continue talking about dialogs and popovers, but this time it's all about animating them into and out of the top layer.. We'll be introducing starting-style, a new mode for transitioning discrete properties, and the overlay property for smooth entry and exit animations. Links: top-layer CSS spec → https://goo.gle/4c2elU…