Search a title or topic

Over 20 million podcasts, powered by 

Player FM logo
Artwork

Content provided by CPA Australia. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by CPA Australia or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://podcastplayer.com/legal.
Player FM - Podcast App
Go offline with the Player FM app!

Unlock 7 underused Excel features you still need today

16:17
 
Share
 

Manage episode 522086809 series 3560917
Content provided by CPA Australia. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by CPA Australia or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://podcastplayer.com/legal.

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]

  continue reading

42 episodes

Artwork
iconShare
 
Manage episode 522086809 series 3560917
Content provided by CPA Australia. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by CPA Australia or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://podcastplayer.com/legal.

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]

  continue reading

42 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Copyright 2025 | Privacy Policy | Terms of Service | | Copyright
Listen to this show while you explore
Play