Unlock 7 underused Excel features you still need today

Unlock 7 underused Excel features you still need today

From Excel Tips by CPA Australia

December 1, 2025 · 16 min

About this episode

This episode highlights overlooked Excel features that enhance workflow efficiency and productivity.

Handy n ew 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 – w hich is why t his 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. R ead more of Neale's Excel articles on INTHEBLACK . Loving this content? Would you like to…

People in this episode

Host: Neale Blackwood CPA

Topics covered

  • Excel features
  • workflow efficiency
  • spreadsheet tips
  • data management
  • Excel functions

Keywords

  • Excel
  • features
  • workflow
  • reporting
  • data
  • functions
  • tips

Mentioned in this episode

Organizations: CPA Australia

More episodes of Excel Tips

Explore listener stats, chart rankings, contacts and more on the Excel Tips podcast page.