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:

1. Custom lists explained – 0:29
2. Creating custom lists – 1:34
3. Automating lists with range names – 4:08
4. Creating range names (method 1) – 4:52
5. Transpose function – 7:30
6. The downside of using range names (method 1) – 7:59
7. Using formatted tables for range names (method 2) – 8:33
8. Array based range names – 10:08
9. Special values keyboard shortcut – 11:37
10. Examples using the range names – 12:43
11. Using helper cells and the index function – 13:45
12. Repeating the range name sequence – 14:48
13. 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:

• With Interest
• INTHEBLACK
• INTHEBLACK Out Loud
• Excel Tips

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au