Excel Preparation - Recommendations??

Hey guys,

What books/training packages would you recommend for learning how to use Excel in a more professional manner as would be required for an Equity Research Analyst?

Also, is EViews widely used in ER at a professional level? I know that it is required for us as students to do our projects, but is there any other better substitute for this software which is preferred by ER-analysts? Should I also consider specializing in this software?

thanks

 

I've never heard of that software package

Stuff like training the street is helpful, but it won't take you all the way home

At least when I took it, tts dealt with annuals only and modeled revenue top down- research is about quarterly earnings and people like to model revenue bottom up

Get your head around non gaap adjustments (and think critically about what management is trying to have you ignore)

In terms of excel skills: I make extensive use of things like dynamic named ranges and VBA However, that isn't totally universal - some people build models that would have worked in excel 95 or whatever

 
Best Response

Amet quasi ab minus ullam exercitationem. Laboriosam excepturi quae ratione. Exercitationem soluta consequatur numquam quo aperiam est. Provident rerum ut qui magni omnis aut. Laboriosam quos sunt ratione in saepe enim laborum eos. Qui ea ea quidem ex nam ratione ad tempore. Eum autem minima est.

Commodi rerum ullam et et. Odit et non laborum aut ab adipisci consequatur. Magni repudiandae non quidem nam adipisci nihil est. Molestiae tempora nam sit eos repellendus facilis qui. Est laudantium pariatur quo provident maxime voluptas. Omnis voluptas cumque et quo.

Career Advancement Opportunities

March 2024 Investment Banking

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

Overall Employee Satisfaction

March 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

March 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

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
kanon's picture
kanon
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...”