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!
Screenshot at March 27th 2023 - 11.56.44 am

Dear Analyst Episode #116: Will Microsoft’s AI Copilot for Excel replace the need for analysts?

This news is a bit old but I figured it’s juicy enough to talk about its future implications on Excel and artificial intelligence in general. Mid-March 2023, Microsoft announced Copilot, it’s artificial intelligence bet that will supposedly change the way we work. The video discusses how Copilot integrates with Office 365 and all your Microsoft […]

0-count-number-of-formatted-colored-cells-google-sheets

Dear Analyst #115: How to count the number of colored cells or formatted cells in Google Sheets

Counting the number of colored cells or formatted cells in Google Sheets or Excel seems like it should be a basic operation. Unfortunately after much Googling, it doesn’t seem as easy as it looks. I came across this Mr. Excel forum thread where someone asks how to count the number of rows where there is […]

0-doug-walters

Dear Analyst Episode #114: How a small real estate investment company uses modern data and cloud tools to make data-driven decisions

When you think of data pipelines, data warehouses, and ETL tools, you may be thinking about some large enterprise that is collecting and processing data from IoT devices or from a mobile app. These companies are using tools from AWS and Google Cloud to build these complex workflows to get data to where it needs […]