DiscoverExcel TipsSmarter, faster, easier: Here’s what’s new in Excel
Smarter, faster, easier: Here’s what’s new in Excel

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

Update: 2025-10-01
Share

Description

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 filewill go into more detail to demonstrate these techniques. 

 

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 <a class="Hyperlink SCXW264493702 BCX0" href="https://www.cpaaustralia.com.au/tools-and-resources/pod

Comments 
loading
00:00
00:00
1.0x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

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

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

CPA Australia