Claude on the loose! What skills should I now focus on before I hit the desk?

Title synthesizes what I want to ask, but to provide a bit more color, really interested in how many of you already at the desk think us incoming summer analysts/ft analysts should prep given the changing landscape due to AI (i.e. Claude, etc.).

Is it still seemingly necessary to become extremely proficient and efficient in excel/ppt? What other skills (aside from not being bots and knowing how to communicate) should we focus on to become the best analysts? Also, in what ways would it beneficial to use AI in our skill development so that we can effectively contribute as juniors?

Thanks.

8 Comments
 

To crush it as an incoming analyst in the evolving AI-driven landscape, here's what you should focus on:

1. Excel and Financial Modeling Mastery

  • Despite AI advancements, being highly proficient in Excel and financial modeling remains critical. As one WSO thread highlights, you should aim to be so good at financial modeling that your work stands out—think 3-statement models, DCFs, accretion/dilution analysis, and comps/precedents. Formatting, formulas, and shortcuts should be second nature.

2. PowerPoint Efficiency

  • PPT skills are still essential. Knowing how to create clean, professional decks quickly will save you time and impress your team. Learn shortcuts, formatting tricks, and how to structure presentations effectively.

3. Data Analysis and Interpretation

  • With AI tools like Claude and ChatGPT entering the scene, understanding how to analyze and interpret large datasets is becoming increasingly valuable. While you may not need to code, familiarity with tools like SQL or BI platforms can give you an edge.

4. AI-Assisted Skill Development

  • Use AI tools to accelerate your learning:
    • Financial Modeling Practice: Tools like ChatGPT can help explain concepts or debug formulas.
    • Summarizing Reports: AI can condense lengthy 10-Ks or earnings calls, saving you time.
    • Risk Analysis: AI can highlight key risk factors in filings or earnings transcripts.
  • However, remember that AI is a supplement, not a replacement. You still need to critically evaluate its outputs.

5. Communication and Soft Skills

  • As AI takes over repetitive tasks, your ability to communicate effectively, build relationships, and present ideas will set you apart. Focus on storytelling, active listening, and clear writing.

6. Understanding Human Bias and Decision-Making

  • A WSO thread emphasizes the importance of understanding how humans think and process information. This skill helps you recognize biases—both your own and others'—and make better decisions.

7. Adaptability and Proactivity

  • The landscape is changing, but luck and initiative still play a role. Proactively seek out opportunities to work with top-performing teams or on high-impact projects. Be open to learning new tools and workflows as they emerge.

By combining technical proficiency, AI literacy, and strong interpersonal skills, you'll position yourself as an indispensable analyst in this AI-driven era.

Sources: Interviewing for a SA or Analyst position? Here's what I'd want to hear as a VP., Reflections from year 4 as an equity analyst, Q&A: 2nd Year Analyst at McKinsey in Europe, Work at top AM -- AI will virtually kill of entry-level roles in AM over the next 5yrs

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 
Most Helpful

I can’t even remember how to build some of the more complex Excel formulas I was using 6 months ago because Claude can do it for me in 15 seconds. I feel like a year from now I’m not going to remember how to do anything complex in Excel. It will be really hard for the new generation who never had to learn how to do it in the first place/understand the logic (if they have to fix something) because they always had AI to do it for them.

 

Thanks for your input. So what do you think the future of the new gen will hold when in their junior seats? Is basically everything going to be AI driven hard-skill wise with significant intrinsic ability deterioration? Do you think, as a result, teams are going to lean out, and/or analysts will start getting their hands in the mix with more strategic thinking + client interaction (harping on the human component of things)?

 

"It will be extremely difficult for the young kids to do long complex math without a calculator"

This sentiment just repeats with every piece of new tech.

 

Enim eveniet est quia sit itaque molestias. Sunt aut nulla voluptatem rerum recusandae sed magni. Deleniti alias aut voluptate hic dolores labore corporis dignissimos. Molestiae ut est dicta voluptatem voluptatibus sint dolores dolor.

Quam eos assumenda laborum sunt ex sequi vel. Facilis suscipit et provident. Et explicabo dolorum odio quod in. Accusamus tenetur explicabo provident et ut repudiandae qui.

Distinctio optio voluptatem rerum suscipit qui impedit a. Voluptatem consequatur facere inventore ut magnam odio vel temporibus. Corrupti velit reiciendis est a non. Voluptatem sapiente qui consectetur atque velit laborum.

Dignissimos natus ullam deserunt aliquid. Voluptatem voluptas maxime magni minus. Sit laborum eos id dolores nulla quo exercitationem. Distinctio reiciendis id occaecati ea non dolores repellendus quia. Quae ipsa perspiciatis et at ea sed in. Et ratione perspiciatis sint nisi quisquam unde.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”