))
How to master using different Excel techniques together
Manage episode 407475549 series 3560917
内容由CPA Australia提供。所有播客内容（包括剧集、图形和播客描述）均由 CPA Australia 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品，您可以按照此处概述的流程进行操作https://zh.player.fm/legal。
Do you want to improve your Excel skills in 2024? Start the new year on a positive note with these essential tips that can help you master a couple of Excel techniques together.
In this episode, we show you how to build custom lists and use range names.
For fast access, use these timestamps:
- Custom lists explained – 0:29
- Creating custom lists – 1:34
- Automating lists with range names – 4:08
- Creating range names (method 1) – 4:52
- Transpose function – 7:30
- The downside of using range names (method 1) – 7:59
- Using formatted tables for range names (method 2) – 8:33
- Array based range names – 10:08
- Special values keyboard shortcut – 11:37
- Examples using the range names – 12:43
- Using helper cells and the index function – 13:45
- Repeating the range name sequence – 14:48
- Recap and benefits of automated custom lists 15:46
Tune in now.
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集单集
分享
