Hi guys. I am starting at MBB in three weeks from a scientific background and have thus only used excel for basic statistics and a bit of data analysis.
I would really appreciate some insight into what resources in excel you actually used on your first project. So if any recent hires could tell me what is really good to know from day one and what you can just learn as you go.
Thanks a bunch, and a happy new year to everybody :D
15% Off wall st. prep Financial Modeling Training Click Here
Excel Skills Needed for Analyst Position
Becoming sharp with excel is critical in both consulting and banking positions. Having a working knowledge before you start can save you many hours and help you make a good early impression. That being said, our users shared functions and skills that will be helpful to learn ahead of starting in a consulting role.
Above all, you should work on developing familiarity with the excel shortcuts. Use the "Alt" key to open up the shortcut prompts.
Excel Functions to Learn:
- Pivot Tables
- Vlookups, Hlookups, Index/Match
- Macros - are an added plus but unnecessary
- Short cuts for formatting
- Text to columns
- Conditional formatting
- If Statements
- Min Max Functions
- Sum Product / Sum If
- Proper, Lower, Upper
- Advanced Chart Techniques
- Circular error trouble shooting
User @Dorsk shared:
If you know how to do pivot tables and vlookups then you're probably fine. That being said, the more you know how to do and the quicker you can do it, the more you'll impress people. If you can do array formulas, macros, match/index, etc. it really will make a difference in your reviews.
User @frgna shared:
Get really fast using arrows/ctrl to bop around. I think even more important than shortcuts is general excel etiquette/best practices - things like never enter a number into part of a cell, never hide a column/row, etc. I can go more into that if you like.
Want to Learn All This and More?
Sign up for our financial modeling and excel training course to master all these excel commands and impress during your internship or time as an analyst.