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 133-banner

Dear Analyst #133: Find or check if a cell contains text from a list of values or partial matching text in a list (3 methods)

There are times when a problem nags at you like a pebble in your shoe. Even when you’re not working on the problem itself, you’re thinking about the problem which make it even worse. Rarely do I come across a Google Sheets/Excel task I cannot solve with formulas, but this one evaded my extensive knowledge […]

Dear Analyst 132

Dear Analyst #132: How the semantic layer translates your physical data into user-centric business data with Frances O’Rafferty

When you think of your data warehouse, the “semantic layer” may not be the first thing that pops in your mind. Prior to reading Frances O’Rafferty‘s blog post on this topic, I didn’t even know this was a concept that mattered in the data stack. To be honest, the concept is still a bit confusing […]

Dear Analyst 131

Dear Analyst #131: Key insights and best practices from writing SQL for 15+ years with Ergest Xheblati

If you could only learn one programming language for the rest of your career, what would be it be? You could Google the most popular programming languages and just pick the one of the top 3 and off you go (FYI they are Python, C++, and C). Or, you could pick measly #10 and build […]