Look Who it Was Random video

Excel - Analyzing Excel Podcast Numbering Scheme and Taking Thanksgiving Off - Episode 898

560 views · Published 5 January 2009 · 5:16 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Analyzing Excel Podcast Numbering Scheme.

Welcome back to the MrExcel netcast! In today's episode, we're discussing a question that was sent in by none other than myself. As Thanksgiving approaches, I've been wondering whether or not to continue with our usual podcast numbering scheme. Do we keep up the podcast for tomorrow just to maintain the numbering, or is that just a silly reason? To answer this question, I decided to analyze all the air dates and episode numbers using a PivotTable.

In this Excel #898 episode, we're using Excel 2007 to create a PivotTable and analyze the data. I've grouped the data by year and used the new formatting options in Excel 2007 to make the table more visually appealing. After some analysis, I've come to the conclusion that our numbering scheme has worked out perfectly for about 51 to 52 weeks, but there have been times where it was off by 1 or 2 weeks. So, based on this data, I've decided to take Thursday and Friday off for Thanksgiving.

I also want to take this opportunity to thank Leo Laporte for suggesting the MrExcel podcast and offering to help make it a part of the Twit Network. I'm also proud to say that we've been ahead of the daily Giz Wiz podcast in terms of episode counts, and I don't want them to catch up anytime soon. So, even though they started a few months after us, we're still 90 episodes ahead of them. I want to thank everyone in the United States who's celebrating Thanksgiving and wish them a great holiday. And to all our listeners, thank you for making MrExcel a resounding success over the past 10 years. We'll be taking Friday off and will be back on Monday with another netcast. See you then!

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/


In Episode 898, I show off some of the deep features in Excel 2007 pivot tables and offer a sincere thank you to everyone at MrExcel.com.

Table of Contents:
(00:00) Introduction and question
(00:20) Analyzing podcast numbering scheme
(01:06) Creating Pivot Table
(01:30) Grouping data by year
(02:00) Formatting Pivot Table
(02:24) Analysis of data
(03:11) Decision to take Thanksgiving off
(04:16) Comparison with other podcasts
(04:49) 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:
10th Anniversary of MrExcel
Air dates and episode numbers
Comparison with other podcasts
Conditional formatting
Count and analysis by year
Excel 2007 formatting schemes
Pivot Table analysis
Podcast numbering scheme
Taking days off for Thanksgiving


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

More from this channel