Feel like an idiot, lost on technical stuff

So I’m 5 months in to a Southern California IB role. I’ve gotten decently fast at updating decks, taking good notes, scheduling calls, rolling forward simple stuff. I got put on a mandate 5 months ago and it just came alive again and I got assigned dealing with part of the raw client data, cleaning/reconciling, etc. and I have no idea how to do it. I understand a DCF/LBO but I’m so far out of my wheelhouse with this stuff, just have been staring and asking dumb questions but feels really disheartening. Anyone been in this spot?

5 Comments
 

Hey there, don't beat yourself up! Everyone starts somewhere, and it's completely normal to feel out of your depth when you're thrown into the deep end with something new, like handling raw client data. Based on the most helpful WSO content, here are a few steps you can take to get a grip on the situation:

  1. Ask for Help: It's better to ask those "dumb" questions now rather than later. Most people are willing to help if you show that you're eager to learn. Remember, the only dumb question is the one not asked.

  2. Online Resources: WSO has a plethora of resources that can help you understand the technical aspects of finance. Dive into the WSO Courses or WSO Academy for tutorials and guides.

  3. Mentorship: Find someone in your firm who has been in your shoes and ask for guidance. A mentor can provide invaluable insights and tips on how to manage the data effectively.

  4. Practice: Get your hands dirty with the data. The more you work with it, the more comfortable you'll become. Practice makes perfect, or at least competent!

  5. Stay Organized: Keep your work and thoughts organized. This will help you manage the data more efficiently and make it easier to spot errors or inconsistencies.

  6. Take a Break: Sometimes stepping away for a moment can give you a fresh perspective when you return.

Remember, everyone feels incompetent at times, especially when facing new challenges. It's part of the growth process in any career, especially in high-stakes environments like investment banking. Keep pushing through, and you'll come out stronger on the other side. Swing from those vines with confidence—you've got this!

Sources: Anyone else get overwhelmed by their career sometimes?, Feeling incompetent because I can't code?, Help. Feeling Lost, From BO to FO and back again, or, how I learned to stop worrying and love technology, Life after PE - the other road

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

The default advice is spend time reviewing past models/analysis.  That is good, obvious, advice but can also sometimes exacerbate the issue of feeling overwhelmed and disheartened.  Opening v78 of a model for a business that you haven't spent anytime with isn't always the best spot to start as you are completely missing any business- or transaction- specific information that has informed what you're reviewing.  I liked to click through versions of the early drafts to get an idea of the starting point and how it evolved. 

That aside, if you're being tasked with cleaning up due diligence files, my advice is keep it simple and show your work.  For example, with the raw client data:

  • Have a "raw data" tab - completely as you received it from the client, untouched.
  • Create a "clean" tab - this is the raw file but you'd added headers, source notes, data tags (for sumif et al), checks vs prior tab
  • Create an "analysis" tab - this is your summary, you're using your tags from the prior tab to present findings or themes, checks vs. prior tab

There is a common misconception that fancy, complicated formulas drive good analysis but it is really good organization and structure that do that. 

 

Why are you asking these moronic questions? Just stay an idiot, that's what I'd love to see in my analysts. Everyone is confused, noone has a clue what's going on, everyone slips and falls on their face, I laugh and tell people about it

 

Quas est suscipit voluptas optio quia dolores recusandae. Saepe alias asperiores aut alias veritatis ut voluptas. Fugit et dolorem voluptatem et dolores perferendis voluptatibus quae. Sint et eius et qui. Ea tempore impedit veniam modi et sunt.

Rerum quos qui aut corporis optio enim. Et in accusamus qui ullam alias illum. Excepturi sit voluptas ratione amet et dolorum. Qui dolor velit et est voluptatum aperiam. Aut ab ipsa reprehenderit aut.

Career Advancement Opportunities

June 2026 Investment Banking

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

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • Intern/Summer Analyst (72) $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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Mimbs's picture
Mimbs
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...”