Holy cannoli. Somehow we've hit 100 hundred episodes of the Dear Analyst podcast. This podcast started off as an experiment because I was lazy and got tired of writing. I figured speaking about Excel and data analytics would be easier than coming up with prose. Ironically, I'm still writing because all the show notes for each episode are summarized through this blog and in the LinkedIn newsletter. Source: scaffmag I started publishing episodes more regularly during the pandemic because I was always at home and what else was there to do? Perhaps I was also fulfilling my millennial obligation to have my own podcast as well. This episode is a look back at some of my favorite episodes and I'll include snippets of these older episodes as well. To all you data nerds out there, thank you for listening to the podcast and reading the show notes. I could say something trite like "I'm doing this all for you." The reality is I do it for myself to explore topics I'm interested in :). 1. Episode #1: The inaugural episode about paste special values in Excel Episode #1 The first episode was published on March 3rd, 2019. I had no idea what I was doing (I still don't). At the time, I thought talking about a relatively technical subject where most people learn via video would be a good idea. Was I ever this young and naive? I had started working at Coda less than a year at this point and was creating content at work comparing Excel and Coda. Needless to say, I was questioning a lot of the common behaviors we do in Excel and paste special values was one of them. I pretty much just read the original blog post I wrote about this subject and framed it as a "why" paste special values is not that great versus "how" to do paste special values. Source: Super User 2. Episode #28: Filling values down to the last row of data Explaining formulas and technical concepts over audio is tricky. As a listener, you're trying to visualize the Excel file I'm explaining. This episode is deep in the weeds of how to fill values down to the last row of your data. The reason why this is one of my favorite episodes is because the blog post with the show notes has become one of the most trafficked posts on thekeycuts.com. I guess a lot of people are looking for ways to fill their values down? Prior to this episode/blog post, the post with the most views is this post on how to split costs with friends (published in 2014). From an SEO perspective, I didn't expect this blog post to get so much search traffic in such a short period of time. 3. Episode #50: First guest on Dear Analyst, Shawn Wang Episode #50 was also a big milestone for the podcast.