Master the latest Excel changes: your ultimate guide

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: 

• INTHEBLACK
• INTHEBLACK Out Loud
• With Interest
• .css-j9qmi7{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-flex-direction:row;-ms-flex-direction:row;flex-direction:row;font-weight:700;margin-bottom:1rem;margin-top:2.8rem;width:100%;-webkit-box-pack:start;-ms-flex-pack:start;-webkit-justify-content:start;justify-content:start;padding-left:5rem;}@media only screen and (max-width: 599px){.css-j9qmi7{padding-left:0;-webkit-box-pack:center;-ms-flex-pack:center;-webkit-justify-content:center;justify-content:center;}}.css-j9qmi7 svg{fill:#27292D;}.css-j9qmi7 .eagfbvw0{-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;color:#27292D;}