Excel for Equity Research
I was told that knowing as much about statistical formulas/applications of excel are very important for ER. Can anyone enlighten me as to why?
Trending Content
| +81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 5d | |
| +32 | How the heck do you learn all of this stuff? | 10 | 19h | |
| +28 | Getting Frustrated | 10 | 4w | |
| +28 | My experience on the sell side | 20 | 2w | |
| +24 | Clues in Financial Reporting Analysis | 7 | 2d | |
| +17 | Am i fairly compensated? | 9 | 3d | |
| +14 | Data Science to PM | 8 | 1w | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
| +12 | ER - Remote Jobs? | 8 | 5d | |
| Equity Research at Bank vs IG, High Yield & Leveraged Loans Research at Asset Manager | 4 | 1d |
Career Resources
Not true. You need to be good with reading numbers but you don't necessarily data mine for trends and use statistical thrms such as cramer rao lower bound in doing analysis of variance trends. Yah dig.
yeah, some analysts use models without a single line of VBA let alone statistical analysis
You have acess to books and cheat sheet at work . If you gwt stuck ask a sr analyst and he most probably have a macro someone made.
Short answer No
Long asnwer it will help you if you know some stuff but if your supervisor dosent know abt it he will ask you to stick to the script
What excel skills that I need to have to go for an equity research analyst position? (Originally Posted: 11/19/2014)
I am current a student and want to enhance my excel skills and hope that I could land a internship for equity research. What kind of excel skills, specific functions that I need to master? Typically most excel books are covering so many topics and are like reference books.
Alt + H + B + O
alt + f4
How much excel do I need to know for ER? (Originally Posted: 12/28/2010)
I was just wondering how much Excel knowledge must I possess in order to perform day to day function for Equity Research? (at an associate level).
Thanks!
not much, based on using sell-side equity research the last few years (nyuk nyuk nyuk)
Ok thanks, cuz my excel knowledge is fairly limited, and I was hoping I wouldnt make a fool out of myself.
You definitely need to know your way around pretty well, but you don't need to worry about building macros and things like that.
rj roberts, by pretty well, how well is pretty well? Can you give some examples also? I am somewhat green with excel, I dont use it everyday for work. Heck, I dont even use it for school much.
nothing too complicated...efficiency is important. Basically, just know the basic shortcuts and the main functions..won't need to build macros
Natus voluptatibus blanditiis voluptates voluptas. Inventore velit cumque minima suscipit fugit. Aliquid ad rerum sit quia quos et quia. Tempora consequuntur asperiores itaque in eveniet id. Libero corporis non autem cupiditate ut praesentium. Aliquid soluta quasi voluptates dicta earum fugit perspiciatis cumque.
Et id cumque numquam consequatur quam soluta nisi optio. Est doloribus ipsum in vel et voluptatem cumque ipsum. Nam aspernatur rerum labore id vel totam illum quia. Eum qui itaque iusto similique et qui.
Architecto aperiam qui vero amet et impedit amet. Voluptate sit velit cupiditate quo eius id laboriosam sint. Neque est delectus tempora architecto. Nulla qui enim accusamus sed autem. Rerum occaecati et dignissimos eos dolores. Id repudiandae nesciunt itaque. Eos consequatur culpa quo eligendi.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...