Excel Holding Me Back—Need to Level Up Fast
Currently an AN1 at a BB, really enjoying the job, but getting absolutely crushed on Excel efficiency compared to Associates. Beyond competent in every other area, but my Excel speed and technical ability aren’t at the level needed to get staffed on the more complex projects. It’s frustrating because I know Excel itself isn’t hard, but I’m still lagging behind where I need to be.
That said, my skills are well above what’s expected for an AN1, so it’s not a major concern—just something I need to fix fast.
Anyone been in a similar spot? What resources/courses (WSP, Macabacus, any others?) actually helped you bridge the gap to Associate-level Excel speed? Really looking to turn this around over the next couple of months. Appreciate any advice.
Find one of your firms more complex models, start with the primary outputs (ULFCF, NPV, IRR, etc.) whatever it is, and Alt + M + P it (that precedent traces the cell, conversely Alt + M + D is dependent tracing). I was in a similar situation with my first role that I felt way over my head in from a modeling perspective, you'll figure it out. Following precedent/dependent cells lets you see the derivative formulas that your assumptions build upon. This might be super basic advice, but I recommend taking some downtime between comments or a lull and chatGPT some stuff you specifically want to do faster in excel and then working those shortcuts into a sandbox copy of your models. I literally had issues formatting sumifs logic and when I took some dedicated time to self-teach it made all the difference.
Wallstreet prep has great resources and can get you up to speed quickly. Let me know if you want to know more
Accusantium debitis libero quae molestias id asperiores. Ex commodi sint illo minima suscipit. Consequuntur sunt recusandae adipisci ut consequatur. Sint minima officiis ducimus minima eum sint. Dicta at iure dignissimos eos a.
Ullam non cum aliquid libero ut asperiores. Voluptas porro aliquam quia quo ullam ut. Aperiam consequatur repellat veritatis repudiandae tempora cumque quia. Saepe esse eveniet quia aliquam tempora.
Doloribus nisi cum adipisci aliquam occaecati reiciendis nisi. Nobis voluptas consectetur voluptas laborum repellat molestiae. A inventore sit iusto minima quas sapiente illum. Exercitationem natus possimus eveniet sapiente soluta ducimus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...