Trading Assistant Excel Skills?

Just wondering what those of you who've had this type of position have needed the most when it comes to Excel. I have basic skills, but nothing more. However, I can teach myself things pretty quickly. Have made a few contacts in this area and have a few things potentially in the works and I just want to make sure I know what I need to in the event I get an interview out of one of them.

Thanks in advance.

15 Comments
 

excel skills won't be a make it or break it factor at all. I know a few of the top chicago shops have excel tests on-site for interviews, but again it really doesnt matter, as long as you are smart and good with numbers you will be fine. anyone can learn excel, and unlike in banking, they are tapping you for your intellectual ability, not your ability to write up pricing models and such (unless you're a quant, in which excel would be irrelevant anyway).

TL:DR dont wast time on excel or brain teasers, focus on probability and why you think you would be a good trader

 

Thanks for the advice.

I only ask because for one particular position I've got my name in for, they list it specifically as a highly desirable factor. But I'm definitely focusing on everything else you've listed. Probability especially.

"When you stop striving for perfection, you might as well be dead."
 
OilBaron

Most places don't want to waste time teaching excel. Learning it will only help. Google is your friend.

I plan on it...just wanted to know what the best things to focus on given a limited period of time to brush up. Thanks for the input.

"When you stop striving for perfection, you might as well be dead."
 

I understand that, I'm just trying to make sure I am, that's all. Never was taught how to use it so I'm just kind of doing this on my own.

"When you stop striving for perfection, you might as well be dead."
 

I knew zero Excel coming into the jobs and now I can easily just use the keyboards and write complicated formulas and coding in VBA just by teaching myself on the job by googling and trial and error. Trust me the first time it was not easy but time would make it much easier. The more you do it on the job: building complicated Excel models, the more you get better at it.

 

Makes a lot of sense, that's the only real way to learn things I feel. I've never learned anything by forced memorization, only by doing it and realizing why it works. Working through a book right now to teach myself some things but I can tell already it won't stick until I have to use it every day.

"When you stop striving for perfection, you might as well be dead."
 

REGRESSION is THE most important tool in excel, especially for trading. Learn how to fit one properly using theory, not just finding the perfect fit line. I'm shocked at how many traders and bankers have no idea how to properly apply the most used and abused analytic tool out there

 

Atque temporibus autem occaecati. Itaque tempore aut perferendis inventore vitae.

Mollitia officia eligendi autem commodi ea nemo at et. Sed laboriosam quidem ut quam veritatis. Libero id totam officiis et magni eius. Omnis quo maxime et et. Quos veniam voluptates pariatur voluptatem aut.

Ea aperiam et quia eius. Unde aspernatur enim praesentium. Quidem qui deleniti qui perspiciatis. Aperiam sit enim culpa laboriosam nesciunt cum beatae.

Quia facere dignissimos non animi ut aut sit. Libero earum fuga aperiam illum modi nemo. Aut perspiciatis illo sit illum.

"When you stop striving for perfection, you might as well be dead."

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 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 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 (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (65) $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
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
DrApeman's picture
DrApeman
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
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...”