Tag Archives: modeling

Dear Analyst #44: Referencing CO₂ emissions data with INDIRECT and FILTER to build a model

I recently had the opportunity to build a growth model at work, and it’s been fun getting back to my roots in Excel/Google Sheets. Been a while since I’ve built a model from scratch so I of course referenced previous models my colleagues have built. Interesting to see the use of FILTER and INDIRECT in […]

International Financial Modeling Competition Modeloff 2017 Recap

The last time I wrote about Modeloff was in 2013, the first international financial modeling competition I attended when KeyCuts just started. The result of the Modeloff competition in 2013 were a series of blog posts detailing some of the questions asked during the competition and the ways to solve the problems. Check out this […]

Join our community of 5,000+ Excel and data analysis enthusiasts!

  • Learn Excel techniques and shortcuts
  • Episode updates from the Dear Analyst podcast about Excel
  • Updates on online and offline data workshops

Enter your e-mail and hit the blue button!