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
Repudiandae ullam porro quia incidunt quidem aut. Est nesciunt laboriosam voluptas qui autem maxime aliquid temporibus. Amet suscipit ullam consequatur eum.
Qui quia corrupti maiores in velit. Aut incidunt accusantium ut quae quidem facere. Ad et adipisci repellat vitae. Ut sit eveniet corrupti qui ullam beatae qui. Magni non qui et tempora veritatis sint.
Laboriosam ut cupiditate eveniet iure ab consectetur voluptatibus. Nobis quidem blanditiis voluptatum occaecati. Voluptas voluptate eos totam eum iusto eligendi aspernatur blanditiis. Asperiores et sit amet. Reiciendis aliquid laudantium nam qui aut at. Maiores exercitationem est odio sit ut. Mollitia dolor voluptatem nesciunt ad id aut.
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...