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

About this episode

This episode explores the latest Excel updates that enhance productivity and simplify workflows for finance and accounting professionals.

Excel Tips Summer Season Encore presentation from October 2025 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: H ow to use TRIMRANGE for flexible range selection W hat's new with pivot table formatting and an exciting update on auto-refresh H ow the TRANSLATE function works for multilingual data T he s implified syntax for BYROW and BYCOL functions H ow 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 v i deo and Excel file will go into more detail to demonstrate these techniques. R ead more of Neale's Excel articles on INTHEBLACK . You can find a CPA at our custom portal on the CPA Australia website. Would you…

People in this episode

Host: Neale Blackwood CPA

Topics covered

• Excel updates
• productivity
• finance
• accounting
• data analysis
• workflow simplification

Keywords

• TRIMRANGE
• pivot table formatting
• auto-refresh
• TRANSLATE function
• BYROW function
• BYCOL function
• Regex functions
• data identification

Mentioned in this episode

Organizations: CPA Australia

Books & works: Advanced Excel Reporting for Management Accountants

More episodes of Excel Tips

• Template tips to boost workflows · May 1, 2026 · 8 min
• Increment dates easily in Excel · April 1, 2026 · 7 min
• Master your messy data · March 2, 2026 · 6 min
• Build Better Excel Models · February 2, 2026 · 12 min
• Unlock 7 underused Excel features you still need today · December 1, 2025 · 16 min
• How to simplify complex calculations with custom functions · November 3, 2025 · 8 min