Best Query Core Podcasts (2024)

1
Handy hack to create timeline charts 10:29

10d 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
Master calendar creation in Excel 17:14

13d 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
091: Season 5 Wrap-up 42:39

1M 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
How to add a user interaction into Power Query 11:57

2M 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

3M 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
089: View transitions 41:51

3M 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

3M 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

3M 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

4M 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
086: Nesting 2024+ 8:10

4M 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
085: Linear easing function fun 16:10

4M 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

4M 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
084: Text Wrap 12:47

5M 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
083: :has() tips and tricks 36:14

5M 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
3 powerful macros to streamline your workflow 9:13

6M 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

6M 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
081: Trigonometric Functions 43:04

6M 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

6M 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…

1
79: Popover and Dialog 19:55

6M ago19:55

19:55

The CSS Podcast is back, with an episode highlighting the popover API and dialog element! Learn what they can do, and when to use which when. Links Popover API lands in Baseline → https://goo.gle/3Vo2dIs Dialogs and popovers seem similar. How are they different? → https://goo.gle/3wXD1z5 Dialog dilemmas and modal mischief → https://goo.gle/3R9nmDE …

1
Level up your custom functions skills 10:05

6M ago10:05

10:05

Tune in to discover how mastering custom functions can help simplify two complex issues with Excel formulas. Improve your problem-solving skills by harnessing the power of custom functions. For fast access, use these timestamps: 0:20 - Custom functions, episode overview. 1:39 - Summing spill ranges. 2:58 - Using prefixes in functions. 4:07 - Settin…

1
How to create a dashboard using Excel’s dynamic arrays 10:57

8M ago10:57

10:57

Do you want to improve your dashboard-creating skills in Excel? Look no further. This episode has all the expert tips you need to know using dynamic arrays to create a dashboard. For fast access, use these timestamps: About the report template and using dynamic arrays - 0:17 About dynamic arrays - 0:55 Dynamic charts and dashboards using dynamic ar…

1
Episode #28: TODAY I am 35 years old, 35 Years Drug-Free TODAY. Recovery Rocks! 12:39

8M ago12:39

12:39

This topic here feels way too big to even address, dang, it’s huge. Earlier this week I planned a half-hearted attempt to do something about it, but then stopped. With the subject looming overhead, I tried to just move on with my daily activities, you know, staying busy and trying not to think about it. Alas I could not escape, I had no choice. A f…

1
How to automate report building in Excel (part 2) 11:47

9M ago11:47

11:47

Don’t miss this episode, the second in a three-part series that explains how you can use the power of dynamic arrays in report building. Learn how to review a report that’s using dynamic arrays to create an automated month and year-to-date report. For fast access, use these timestamps: About the report template and using dynamic arrays 00:18 Range …

1
Episode #27: Depression, Breaking the Chains of this Dark Daemon 1:21:21

9M ago1:21:21

1:21:21

How do we even begin to define depression? Well, from where I sit it appears to be an unsettled emotional state that crosses over into a physical ailment, brought on by a belief of being held down or pushed aside. Under mild conditions we are perhaps agitated, self-loathing, and unhopeful. Advancing then to moderate levels, a helplessness arrives, …

1
How to automate report building in Excel 11:53

10M ago11:53

11:53

Are you an accountant or finance professional looking to enhance your daily workflows? Don’t miss this episode, which delves into the exciting capabilities of dynamic arrays, empowering you to effortlessly build automated reports. For fast access, use these timestamps: The tutorial example report, and companion file 1:50 Dynamic array calculation a…

1
Episode #26: Co-host Shequila Hoye...growing up without a mother, stopping the cycle of generational substance abuse, accidental overdose, the stages of personal change, depression, love queries aftermath ... 2:07:04

10M ago2:07:04

2:07:04

There is so much adhesive hardship in life, aka trauma. Within this vibrant episode, my dear gal pal Shequila and I discuss substance abuse, poor mental health, and more. Shequila knows the all-consuming grip of addiction too-too well, having witnessed her mother's struggle with abusing heroin and other substances for three decades. She shouldered …

1
Master the latest Excel changes: your ultimate guide 15:41

11M ago15:41

15:41

For accounting and finance professionals, it’s vital that you keep up-to-date with changes to Microsoft Excel functionality. This episode explains what you need to know, including the latest changes to three Excel functions, and opening and working with CSV files. Tune in now for insights that will help enhance your productivity in 2024. For fast a…

1
How to master using different Excel techniques together 17:13

11M ago17:13

17:13

Do you want to improve your Excel skills in 2024? Start the new year on a positive note with these essential tips that can help you master a couple of Excel techniques together. In this episode, we show you how to build custom lists and use range names. For fast access, use these timestamps: Custom lists explained – 0:29 Creating custom lists – 1:3…

1
78: Season 4 wrap! 19:58

1y ago19:58

19:58

I can’t believe we’re already at the end of season 4! This season, we’ve been focusing on CSS gotchas and resolving these common CSS pitfalls. And alas, on our last episode of the season, we’re going to take a look back at all of those tips and tricks and pick some of our favorites to highlight in this recap episode. Links: Why isn’t percentage wor…

1
Top Excel tips for your first 100 days in a new job 14:53

1y ago14:53

14:53

Starting a new role in accounting and finance? We understand it can be stressful as you try to make a good first impression. This Excel Tips episode is specially designed with your first 100 days in mind, to help you hit the ground running. For fast access, use these timestamps: Interface setup – 1:29 Pin files and folders and quick access – 2:43 U…

1
77: Why isn't percentage working here? 15:05

1y ago15:05

15:05

In this episode, Una and Adam talk about percentage resolution for various properties like font-size, padding height and width. They break down and explain why percentages may not work or may not be what you expected. Links → https://goo.gle/47XtWU1 Understanding CSS Percentage → https://goo.gle/3RhLJzG CSS Box Sizing Module Level 3 → https://goo.g…

1
Episode #25: Free CHAPTER TWO audio reading from the ADDICT book 1:11:56

1y ago1:11:56

1:11:56

The complete CHAPTER TWO audio recording, read by Roger. CHAPTER ONE can be found in the previous pod episode #23. Chapter Two excerpt: (a poem) Mirror-Mirror Why Do You Hate Me So? Yes I see, yes Mirror I see the glass is clear yes I see… Yet Mirror, why always same-same the seeing? Storm clouds shower thy under-roof’s nest Sans shelter, sans safe…

1
Episode #24: LIVE event. Madison communal symposium on substance abuse. Nov 15, 2023 Madison Wisconsin 1:59:04

1y ago1:59:04

1:59:04

Over 100 friends packed the room, and in excess of 250 joined the FB livestream. Without discussion, we sit amidst an opioid and fentanyl epidemic. National suicide rates have reached true crisis levels. Alas, addiction and poor mental health casts their anguish upon us all. Eager to transcend the torment, chiefly we lack the comprehension of where…

1
76: Why isn't my element stuck where I wanted it to stick? 9:52

1y ago9:52

9:52

In this episode Una and Adam help you uncover moments where a sticky element isn't sticking. There are a couple of gotcha around implementing a sticky element and by the end of the show you'll know what they are and a few ways to work around them. Links: sticky stack - https://goo.gle/3QICxTz sticky desperado - https://goo.gle/3sC3OPj sticky slide …

1
How to create improved data visualisations in Excel 14:48

1y ago14:48

14:48

If you’re looking for ways to display diverse types of data using Excel’s charts and visualisation tools, this podcast, loaded with tips, will show you how. The example in this episode compares one month's data from this financial year with the corresponding month from the previous fiscal year. For fast access, use these timestamps: Column charts: …

1
75: Why isn't my custom property the value I expect? 19:32

1y ago19:32

19:32

In this episode, Una and Adam discuss common gotchas with custom properties, which often feel fully reactive during use, but their limits and implementation details can popup at unexpected times and create a headache. They'll cover these situations and their solutions! Links: Value stages → https://goo.gle/3FDo7yA How custom property values are com…

1
74: How do I center a div? 17:01

1y ago17:01

17:01

In this episode we tackle one of the most asked questions of all CSS history.. how do I center this div? We'll cover multiple strategies that each have tradeoffs and super powers over each other. Links: Centering in CSS → https://goo.gle/3RRki02 Comparing grid and flex place-items and place-content → https://goo.gle/3ZE3NGM Centering in CSS: A Comp…

1
Episode #23: Free CHAPTER ONE audio reading from the ADDICT book 35:16

1y ago35:16

35:16

A read-aloud of chapter one from the new book. Partial text: My scars represent my best lessons…my stumbles hurt me, while teach me. Growing into the learned weathering of up’s and downs, aka residing in the middle, this my greatest challenge awhile my greatest opportunity. I try, I really try, I try to remain honest that even when low, an up perio…

1
Master 10 new and revamped Excel features 14:49

1y ago14:49

14:49

Do you want an Excel edge? Whether you're a seasoned pro or starting out, master these 10 new and revamped features to help streamline your workflow and boost your spreadsheet efficiency. For fast access, use these timestamps: Web based version of Excel: 0:30 Position of the blanks option in filter dropdown: 3:02 Power Query import updates: 4:13 CT…

1
Episode #22: Leaving the shitty life behind, all of it...the self-doubt, the depression, the drugs, and instead...the hope, the faith, the dreams, and the sunshine. PLUS, a book reading. 30:51

1y ago30:51

30:51

Attempting to begin my life anew, I recognized the biggest challenge is overcoming the worst parts of myself. Beginning to claw my way up and out of that shitty hell, I found the need to silence the defeating voice in my head and go, just go. Dissecting the value of friends in my life, I also share a reading from my new book Daddy Why Were You A Dr…

1
73: Why is my animation glitching? 25:50

1y ago25:50

25:50

On this episode of the #CSSpodcast, we’re diving into how to deal with glitchy animations in your code base! Links: MDN transform-style - https://goo.gle/45YFu8B MDN backface-visibility - https://goo.gle/46mPvfE Una Kravets (co-host) Twitter | Instagram | YouTube Making the web more colorful ✨🎨 Web DevRel @googlechrome Unicorn face host of @toolsda…

1
72: Why does my gradient have muddy colors in the middle? 16:11

1+ y ago16:11

16:11

In this episode, we tackle the issues around getting undesirable gradient results. Sometimes it's you, sometimes it's the color space. We'll help you identify, assess and remedy muddy gradients. Links: HD color guide - https://goo.gle/3RhyvmP various gradients in color spaces - https://goo.gle/3Pc02TV modern css gradient tool - https://goo.gle/3P4K…

1
Boost your skills with tips for Excel function updates 13:05

1+ y ago13:05

13:05

Excel is constantly evolving and improving, and it's crucial to stay up to date with all the latest changes. This companion podcast is here to help you sort quickly through the most relevant function updates. Are you ready to take your Excel skills to the next level? Tune in now. For fast access, use these timestamps: 0:29 Dynamic arrays 2:29 XLOOK…

1
71: Why do I have layout shift? 11:30

1+ y ago11:30

11:30

In this episode we're shifting the topic to layout shift, that moment where you watch the page adapt to something lazily loaded which has impacted the layout in some way where you see content shift around. Links: CLS - https://goo.gle/3kle3AW Optimizing CLS - https://goo.gle/3fxu6IE CSS for Web Vitals - https://goo.gle/3E98gY9 Una Kravets (co-host)…

1
70: Why is my image distorted? 17:52

1+ y ago17:52

17:52

Too small? Too big? Learn how to make your images just right and all the reasons they might be looking a little funky when you’re adding media to your interface. Links: CSS for Web Vitals → https://goo.gle/3E98gY9 Learn Responsive Images → https://goo.gle/45EFuds Aspect Ratio → https://goo.gle/3PdyjDS Demos → https://goo.gle/3qJuQ6z & https://goo.g…

1
69: Why is it overflowing? 15:04

1+ y ago15:04

15:04

In this episode we're overjoyed to overexplain why you may be having overflow in your page. somewhere over the rainbow, an overheating developer overcooked the inline sizes and ended up oversleeping for work the next day. Now let's overanalyze and overshare about CSS overflow. Links: The rules of Margin Collapse → https://goo.gle/441OGaH Everything…

1
68: Why isn't the margin applying? 16:14

1+ y ago16:14

16:14

In this episode we explore why margin may not be working for you. We’ll teach you about block formatting contexts and margin collapsing! We'll make you the space you want in your designs! Links: The Rules of Margin Collapse → https://goo.gle/441OGaH CSS Margins → https://goo.gle/4434Ctj Learn more → https://goo.gle/3YrJDiw Una Kravets (co-host) Twi…

1
67: Why isn't z-index working? 16:55

1+ y ago16:55

16:55

In this episode we explore why z-index isn’t working for you. We’ll teach you about stacking context and how to make sure you’ve set yourself up for layering success! Join us on this journey through positioning, variable architecture, tools, and more, to bring those elements to light. Links: Stacking context → https://goo.gle/43It8jl Una Kravets (c…

1
Unlock 14 expert tips for Excel formulas 23:49

1+ y ago23:49

23:49

Unleash your Excel skills by using the valuable functionality of formulas. Go straight to episode sections: The formula bar – 1:06 Starting formulas – 1:41 Using functions – 2:58 Function arguments – 4:09 Relative and absolute cell and range references – 7:15 The calculation sequence – 9:46 Parentheses (brackets) – 10:39 Colours in formulas – 12:37…

1
Why Excel can be a university student’s secret weapon 26:01

1+ y ago26:01

26:01

Are you a university student or recent graduate? Are you looking to gain a competitive edge in the job market, specifically in the fields of accounting and finance? Then this episode is what you need! Packed with practical advice tailored to your needs, it will equip you with valuable Excel tips that will enhance your employability as you move into…

Podcasts Worth a Listen

Query Core Podcasts

Podcasts Worth a Listen

Quick Reference Guide