17 min

How to master using different Excel techniques together Excel Tips

    • Education

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: 
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

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: 
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

17 min

Top Podcasts In Education

The Subtle Art of Not Giving a F*ck Podcast
Mark Manson
The Glow Up Secrets
Elicia Goguen
Serendipity With Inky Johnson
INKY JOHNSON NETWORK -
Daily Affirmations for Women
Daily Affirmations for Women
Motivation Daily by Motiversity
Motiversity
Impact Theory with Tom Bilyeu
Impact Theory