))
How to master using different Excel techniques together
Manage episode 407475549 series 3560917
A tartalmat a CPA Australia biztosítja. Az összes podcast-tartalmat, beleértve az epizódokat, grafikákat és podcast-leírásokat, közvetlenül a CPA Australia vagy a podcast platform partnere tölti fel és biztosítja. Ha úgy gondolja, hogy valaki az Ön engedélye nélkül használja fel a szerzői joggal védett művét, kövesse az itt leírt folyamatot https://hu.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 epizódok
Megosztás
