))
How to automate report building in Excel (part 2)
Manage episode 410099452 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://ppacc.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]
37 episodes
Share
