))
How to automate report building in Excel (part 2)
Manage episode 410099452 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.
Don't miss this episode, the second in a three-part series that explains how you can use the power of dynamic arrays in report building. Learn how to review a report that's using dynamic arrays to create an automated month and year-to-date report.
For fast access, use these timestamps:
- About the report template and using dynamic arrays 00:18
- Range names for formatted tables 2:35
- Budget layout and structure setup 3:34
- The offset function 4:15
- The filter function 5:11
- SUM IF S function 6:54
- Using the wildcard character 7:49
- Variance calculations 8:41
- The ABS function 9:39
- Additional resources 10:49
Tune in now to learn more about this handy Excel subscription version functionality.
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]
42 episod
Kongsi
