Smarter, faster, easier: Here's what's new in Excel

from Excel Tips · host CPA Australia

In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance and accounting professionals. Listeners will learn: How to use TRIMRANGE for flexible range selection What's new with pivot table formatting and an exciting update on auto-refresh How the TRANSLATE function works for multilingual data The simplified syntax for BYROW and BYCOL functions How three new Regex (regular expressions) functions can use patterns to identify data. Packed with practical insights, this episode helps you explore Excel's latest upgrades to save time, improve analysis and elevate decision-making. Tune in now. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. The companion video and Excel file will go into more detail to demonstrate these techniques. Read more of Neale's Excel articles on INTHEBLACK. You can find a CPA at our custom portal on the CPA Australia website. Would you like to listen to more Excel Tips episodes? Head to CPA Australia's YouTube channel. CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting: With Interest INTHEBLACK Excel Tips INTHEBLACK Out Loud Search for them in your podcast platform. You can email the podcast team at [email protected]

NOW PLAYING

0:00 13:55

1×

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

Share this episode

Similar Episodes

Beating loneliness by bridging the generation gap

Apr 21, 2026 ·13m

Robotics and the Future of Aged Care

Apr 19, 2026 ·16m

The Purpose Paradox: Why Baby Boomers Delay Retirement

Apr 17, 2026 ·13m

A Growing Movement Aims to Prepare All Physicians to Care for Older Adults

Apr 15, 2026 ·12m

Defeating Recurring Charges on Cancelled Credit Cards

Apr 13, 2026 ·11m

If Your Dad Has These 11 Odd Habits, He's More Lonely Than He Admits

Apr 11, 2026 ·16m

Similar Podcasts

That Hoarder: Overcome Compulsive Hoarding That Hoarder Hoarding disorder is stigmatised and people who hoard feel vast amounts of shame. This podcast began life as an audio diary, an anonymous outlet for somebody with this weird condition. That Hoarder speaks about her experiences living with compulsive hoarding, she interviews therapists, academics, researchers, children of hoarders, professional organisers and influencers, and she shares insight and tips for others with the problem. Listened to by people who hoard as well as those who love them and those who work with them, Overcome Compulsive Hoarding with That Hoarder aims to shatter the stigma, share the truth and speak openly and honestly to improve lives. PodQuesting Dwight J Randolph- WolfShield Media PodQuesting: -By WolfShield Media and Dwight J RandolphJoin us on an exciting journey to master the world of fiction podcasting! At PodQuesting, we document our quest to improve and innovate, sharing valuable insights, strategies, and behind-the-scenes tips along the way. Whether you're an experienced podcaster or just starting your first show, our podcast is your go-to resource for everything podcasting.Discover practical advice, creative techniques, and lessons from our own experiences as we explore the ever-evolving podcasting landscape. Ready to level up your skills and embark on this adventure with us? Tune in and join the quest!Have questions or feedback? Reach out to us at [email protected] and visit our website:WolfShield.Media LIGHTS, CAMERA, SMILE! Creatives Club Media Lights, Camera, Smile, is a podcast for anyone with a dream to share something with the world, out of the overflow of themselves - be it their mind, their heart, their personalities, and much more. Each of us are alive in this moment in time, with an innate ability to have ideas and create various things to benefit both ourselves and the people around us for a reason, and here, you will find the encouragement, the inspiration, and the motivation to do just that. Hosted by Cicily, founder of Creatives Club, she dives into various topics surrounding creativity and business. Exploring entrepreneurship for creatives in a corporate reality, sharing tips and tricks in a media centered company, answering questions regarding what a creative actually is are just a few of the things discussed on this podcast. Be encouraged to create for yourself as Cicily gets vulnerable by pivoting the camera to herself for the first time.To submit questions for Cicily to answer, or have her address certain t Kaizen Blueprint Aldo Chandra "Kaizen" is a Japanese term for continuous improvement. This podcast provides a blueprint to learn about health, wealth, relationships and everything else in between. Through our podcast, we strive to inspire, educate, and motivate our audience to cultivate a mindset of lifelong learning, productivity, and personal development. By sharing insights, strategies, and practical tips, we aim to guide listeners on their journey towards realizing their fullest potential, fostering success, and creating lasting positive change.

Frequently Asked Questions

How long is this episode of Excel Tips?

This episode is 13 minutes long.

When was this Excel Tips episode published?

This episode was published on October 1, 2025.

What is this episode about?

Can I download this Excel Tips episode?

Yes, you can download this episode by clicking the download button on the episode player, or subscribe to the podcast in your preferred podcast app for automatic downloads.

URL copied to clipboard!