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 #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 […]

Dear Analyst #118

Dear Analyst #118: Uncovering trends and insights behind Facebook News Feed, Reels, and Recommendations using data science with Akos Lada

No, this isn’t an episode about how Facebook’s algorithm and feed works. The data science function is popping up in companies small and large given the amount of data swimming around. No other company understand the power and influence that data science can have on the customer experience than Facebook (Meta, to be exact). Akos […]

Dear Analyst #117 cover

Dear Analyst #117: New 2023 Google Sheets functions for data manipulation that already exist in Excel

The Google Workspace team announced a slew of Google Sheets functions a few months ago (February 2023). These functions look familiar and that’s because Microsoft Excel released most of them two years ago. I never had a chance to play around with the new functions in Excel since I don’t have the latest Office 365 […]