Tag Archives: vba

Dear Analyst #50: Walking through a VBA script for trading billions of dollars worth of derivatives with Shawn Wang

This little podcast/newsletter started as a little experiment last year. I never thought I would make it to episode number 50, but here we are! Thank you to the few of you out there who listen/read my ramblings about spreadsheets. I decided to give you all a break and invite my first guest to the […]

Never Do Tedious Worksheet Tasks Again With Excel VBA

The moment you discover VBA in Excel, you will never want to do another formatting or data manipulation task in Excel. When we first discovered how to use VBA, it was like getting fed ground beef after you tasted filet mignon: you just can’t go back once you have tasted heaven. Many people think VBA is meant for programmers, and […]

Join our community of 5,000+ Excel and data analysis enthusiasts!

  • Learn Excel techniques and shortcuts
  • Episode updates from the Dear Analyst podcast about Excel
  • Updates on online and offline data workshops

Enter your e-mail and hit the blue button!