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.

 

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 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."
 

yeah before I went in I tried teaching myself through online videos, lessons and books too and trust we you won't be able to remember or apply anything into your work. You really need to do it to know it! Good luck. You will do just fine.

 

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

 

Mollitia iusto quas ipsum sequi reprehenderit dolor non distinctio. Architecto repellendus temporibus et omnis voluptatem aliquid aut. Nemo animi facere eveniet eos quas necessitatibus. Cumque eos quae laborum quam libero perspiciatis possimus iusto. Quo beatae in optio quia est. Reprehenderit ut quisquam cupiditate assumenda soluta.

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

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $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
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
numi's picture
numi
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...”