Online Excel training

The Excel for the Real World series on Skillshare has over 40,000 students becoming faster in Excel. Learn the basics of Excel to creating a data-driven presentation in PowerPoint!

Live & Virtual Workshops

Our live Excel workshops have been taken by more than 1,000 MBA students and Fortune 500 employees in the U.S. Our virtual and in-person Excel workshops are engaging and for all skill levels!

Excel Newsletter & Podcast

Keep your Excel knowledge fresh by subscribing to the Dear Analyst podcast and following our Excel blog. You can also follow the Dear Analyst LinkedIn newsletter reaching 15,000+ analysts!
sumproduct formula

Splitting Costs With Friends Just Got Easier In A Spreadsheet [+Template]

How many times have you gone on a group trip with friends, and figure out the costs at the end of the trip? Maybe one person pays for the hotel, one person pays for the rental car, and someone else pays for the dinners. Or maybe one person pays for everything, making splitting costs much […]

Dear Analyst 121

Dear Analyst #121: Fabricating and skewing Excel survey data about honesty with behavioral economists Dan Ariely and Francesca Gino

One of the more popular courses you could take at my college to fulfill the finance major requirements was Behavioral Finance. The main “textbook” was Inefficient Markets and we learned about how there are qualitative ways to value a security beyond what the efficient market hypothesis purports. During the financial crisis of 2008, psychology professor […]

dear analyst episode 120 zach wilner pear eyewear

Dear Analyst #120: Marketing attribution, sensitivity models, and building data infrastructure from the ground up with Zach Wilner

Data analytics and business analytics are still relatively new areas of study (in terms of academics). The subject borders business and computer science. When I went to school, the only data analytics classes available were special electives offered through our school’s continuing education department. In this episode, I spoke with Zach Wilner who currently leads […]

Dear Analyst #119

Dear Analyst #119: Developing the holy “grail” model at Lyft, user journeys, and hidden analytics with Sean Taylor

Future Dear Analyst episodes will get more sporadic since, well, life gets in the way. Unfortunately curiosity (in most cases) doesn’t pay the bills. Nevertheless, when I come across an idea or person that I think is worth sharing/learning more about, I’ll try my best to post. In this episode, I interview the Chief Scientist […]