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!
0-vlookup-multiple-conditions

How to do a VLOOKUP with multiple conditions or criteria (3 methods)

Once you learn the VLOOKUP formula, your world opens up in terms of being able to analyze and manipulate data. There are hundreds if not thousands of tutorials on how to use the VLOOKUP formula since it’s such a powerful formula for finding the data you need in a long list. Comparable formulas include the […]

0-austin-dowd

Dear Analyst #104: Creating a single source of truth by cleaning marketing analytics data with Austin Dowd

I’m always fascinated by how different people on the podcast find their way into data, and this episode is no exception. Austin Dowd has always enjoyed photography. He was associated with the American Marketing Association and was always curious in the metrics for his photos. After pestering the analytics person in the AMA in terms […]

12-copy-paste-pivot-table-slicer

Dear Analyst #103: How to use one of the best features in PivotTables to filter your data (Slicers)

I used to create a monthly 30-slide report and each slide had a different table or chart that I copied and pasted from Excel. As a naive analyst, I literally filtered my list of data using regular dropdown filters on each column to get the numbers I needed. I would filter, sum or average the […]