Look Who it Was Random video

Excel - How to Organize Your Favorite Podcast Episodes in iTunes - Episode 532

294 views · Published 4 August 2009 · 2:50 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  How to Organize Your Favorite Podcast Episodes in iTunes.

Welcome back to the MrExcel netcast! In today's episode, we have a question from Doug about organizing his favorite episodes. If you have a question for the podcast, don't hesitate to leave us a voicemail or send an email and we'll feature it on a future episode.

Doug's question is about marking favorite episodes in iTunes. He wants to know if there's a way to easily keep track of the tips he wants to revisit and the ones he doesn't need to go back to. Today, we'll take a look at the podcast directory in iTunes and show you how to create a custom playlist for your favorite episodes.

First, let's open up iTunes (version 7.02) and RIGHT CLICK on the heading of the podcast directory. On a Mac, this would be CONTROL CLICK. From here, we can add additional columns to the directory. We'll add the MY RATING column and the GROUPING column. The MY RATING column allows you to assign a rating of 1-5 stars to each episode, while the GROUPING column lets you add keywords to help you remember what the episode was about.

Now, let's use the smart playlist feature to create a dynamic playlist. Go to FILE, NEW SMART PLAYLIST and set the criteria to "podcast is true". Then, add a new rule and select "my rating is" and choose 5 stars. This will create a playlist of all your 5-star episodes. You can also customize the synchronization settings for your iPod to only include episodes from this playlist, saving space and making it easier to find your favorite episodes.

Thanks to Doug for sending in this question! While it may not be directly related to Excel, we all share a love for podcasts and I wanted to share this quick tip for organizing your favorite episodes in iTunes. Don't forget to leave us a voicemail or email with your questions and we'll feature them on a future episode. Thanks for watching and we'll see you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


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.

Table of Contents:
(00:00) Introduction and question from Doug
(00:22) How to mark favorite episodes in iTunes
(00:42) Adding columns to the podcast directory
(01:05) Using the "My Rating" and "Grouping" columns
(01:30) Creating a smart playlist in iTunes
(02:10) Saving space on your iPod with the smart playlist
(02:20) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Adding data or words next to picture
Adjusting bounding box
Background removal tool
Bounding box
Chapter 35
Excel 2010
Excel 2010 features
Excel in depth
Keep changes
MrExcel netcast
Picture Background Removal
Removing areas from picture 

This video answers these common search terms:
Dynamic playlist
Excel
Grouping column
iPod
iTunes question
MrExcel netcast
My Rating column
Podcast directory
Smart playlist feature
Synchronization settings
VLOOKUP question
YouTube video

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152552/

More from this channel