))
How to automate report building in Excel (part 2)
Manage episode 410099452 series 3560917
Inhalt bereitgestellt von CPA Australia. Alle Podcast-Inhalte, einschließlich Episoden, Grafiken und Podcast-Beschreibungen, werden direkt von CPA Australia oder seinem Podcast-Plattformpartner hochgeladen und bereitgestellt. Wenn Sie glauben, dass jemand Ihr urheberrechtlich geschütztes Werk ohne Ihre Erlaubnis nutzt, können Sie dem hier beschriebenen Verfahren folgen https://de.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 Episoden
Teilen
