Handy new Excel features are added regularly – but some "older" functions are still particularly useful to your workflows.

Smart power users know these older functions and their value – which is why this episode highlights some of the overlooked Excel features that are still valuable to your spreadsheet work today.

Tips include:

• How multiple windows make it easier to copy and compare

• How the grouping feature works well with rows and columns

• How auto outline and subtotals automate structure and hierarchy in datasets

• Techniques for selecting visible cells to avoid errors during copying

• How custom lists save time and support non-alphabetic sorting

This is a practical guide for anyone looking to sharpen their Excel capability, streamline reporting and improve their workflow efficiency.

Listen 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.

For more, check out the accompanying YouTube video of this episode.

Read more of Neale's Excel articles on INTHEBLACK.

Loving this content?

Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel.

And don't forget to subscribe to the channel.

You can find a CPA at our custom portal on the CPA Australia website.

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]