))
Boost your skills with tips for Excel function updates
Manage episode 407475553 series 3560917
Kandungan disediakan oleh CPA Australia. Semua kandungan podcast termasuk episod, grafik dan perihalan podcast dimuat naik dan disediakan terus oleh CPA Australia atau rakan kongsi platform podcast mereka. Jika anda percaya seseorang menggunakan karya berhak cipta anda tanpa kebenaran anda, anda boleh mengikuti proses yang digariskan di sini https://ms.player.fm/legal.
Excel is constantly evolving and improving, and it's crucial to stay up to date with all the latest changes. This companion podcast is here to help you sort quickly through the most relevant function updates.
Are you ready to take your Excel skills to the next level? Tune in now.
For fast access, use these timestamps:
0:29 Dynamic arrays
2:29 XLOOKUP
3:19 LET function
3:49 LAMBDA
4:56 TEXTAFTER, TEXTBEFORE and TEXTSPLIT
6:15 BYROW and BYCOL
7:00 the IMAGE function
7:45 VSTACK and HSTACK
8:31 TAKE and DROP functions
10:03 CHOOSEROWS and CHOOSECOLUMNS
10:34 DAX functions
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 three 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]
42 episod
Kongsi
