Artwork
iconShare
 
Manage episode 407475548 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://staging.podcastplayer.com/legal.

For accounting and finance professionals, it’s vital that you keep up-to-date with changes to Microsoft Excel functionality.

This episode explains what you need to know, including the latest changes to three Excel functions, and opening and working with CSV files.

Tune in now for insights that will help enhance your productivity in 2024.

For fast access, use these timestamps:

  1. Importing and using CSV files – 0:38
  2. MAP, SCAN and REDUCE functions – 3:10
  3. Using the MAP function with ranges and LAMBDA – 4:01
  4. Using the SCAN and REDUCE functions – 9:16

Tune in now. Read the companion article here.

Host: Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

Search for them in your podcast platform.

You can email the podcast team at [email protected]

  continue reading

37 episodes