Doug sends in a question today about managing his growing collection of netcasts. Instead of an Excel tip today, Episode 532 shows you how to set up a smart playlist of just your favorite Excel tips.
Transcript of the video:
Hey welcome back to the MrExcel netcast.
Today we have a question sent in by Doug.
If you have a question for the podcast, please either leave us a voicemail or drop me an email and we'll get to you on a future podcast.
Now, Doug sent in a VLOOKUP question which we'll get to another day.
But, his real question is basically an iTunes question.
He says; hey with all these episodes that you have, is there some way to mark which ones are favorites?
Some of the tips you said I renew and I don't necessarily need to go back and look at those.
We're going to take a quick look in iTunes today at the podcast directory.
Now, this is the new version of iTunes, I'm currently, I think that's 7.02 and what I want to do is RIGHT CLICK in the heading of the podcast directory.
Of course, on a Mac that would be CONTROL CLICK, so we'll RIGHT CLICK and there's additional columns that you can add to the podcast directory.
In particular I want to add two here, I'm going to add THE MY RATING COLUMN and then also a GROUPING COLUMN.
Now, what you do with THE MY RATING COLUMN basically is you can assign anywhere from one to five stars, so if we click in there and say; alright well this was a great podcast I want to make sure to keep that one, or you know now I don't think I'm ever going to refer back to this one, I'll keep that one is a one star and then this one might be a five star.
You also can use THE GROUPING COLUMN to add a little keyword.
So for example, if this one was about VLOOKUP, you can leave those notes to yourself.
Now, cool thing to do is to use the smart playlist feature, basically what you do is go to FILE, NEW SMART PLAYLIST and you can build a dynamic playlist.
For example, you could say where the podcast is true and then add a new rule, and say my rating is and then you would choose five stars here.
Now there's a bug on my pc come on this laptop I can't choose five stars, it works on my regular desktop how more I could choose five stars.
Well, click OK, we have untitled playlist to this white be good podcasts and then once you've hooked up your iPod you can go into the synchronization settings and say; only send a good podcast out to the iPod.
Save space on the iPod and things like that.
So thanks to Doug for sending in this question, while I realize it wasn't necessarily Excel, I think one thing we all have in common is we are podcast listeners and wanted to pass on that quick tip about iTunes, both setting up your ratings and a custom smart playlist that will continuously update as you change the rating.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
Today we have a question sent in by Doug.
If you have a question for the podcast, please either leave us a voicemail or drop me an email and we'll get to you on a future podcast.
Now, Doug sent in a VLOOKUP question which we'll get to another day.
But, his real question is basically an iTunes question.
He says; hey with all these episodes that you have, is there some way to mark which ones are favorites?
Some of the tips you said I renew and I don't necessarily need to go back and look at those.
We're going to take a quick look in iTunes today at the podcast directory.
Now, this is the new version of iTunes, I'm currently, I think that's 7.02 and what I want to do is RIGHT CLICK in the heading of the podcast directory.
Of course, on a Mac that would be CONTROL CLICK, so we'll RIGHT CLICK and there's additional columns that you can add to the podcast directory.
In particular I want to add two here, I'm going to add THE MY RATING COLUMN and then also a GROUPING COLUMN.
Now, what you do with THE MY RATING COLUMN basically is you can assign anywhere from one to five stars, so if we click in there and say; alright well this was a great podcast I want to make sure to keep that one, or you know now I don't think I'm ever going to refer back to this one, I'll keep that one is a one star and then this one might be a five star.
You also can use THE GROUPING COLUMN to add a little keyword.
So for example, if this one was about VLOOKUP, you can leave those notes to yourself.
Now, cool thing to do is to use the smart playlist feature, basically what you do is go to FILE, NEW SMART PLAYLIST and you can build a dynamic playlist.
For example, you could say where the podcast is true and then add a new rule, and say my rating is and then you would choose five stars here.
Now there's a bug on my pc come on this laptop I can't choose five stars, it works on my regular desktop how more I could choose five stars.
Well, click OK, we have untitled playlist to this white be good podcasts and then once you've hooked up your iPod you can go into the synchronization settings and say; only send a good podcast out to the iPod.
Save space on the iPod and things like that.
So thanks to Doug for sending in this question, while I realize it wasn't necessarily Excel, I think one thing we all have in common is we are podcast listeners and wanted to pass on that quick tip about iTunes, both setting up your ratings and a custom smart playlist that will continuously update as you change the rating.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
