The tools and skills every analyst should have
Hey fellow monkeys,
I just recently started as a Finance analyst for one of the consulting firms and have set myself the goal of learning as many tools and skills as I can.
I have done quite a bit of research online however most say 'presentation skills, communication' etc which are just too general. I am looking for 'specific' tools I can learn or skills to develop.
So far I am working on:
- Excel: Pivot tables. Maybe I should look at commonly used formulas next?
- Mnemonics: Also for general every day use
- Different kinds of project planning and management tools (that I have used/can find at my firm)
- Joining Toastmasters.
So, I put it to you all out there, what tools and skills would be useful both at the analyst level and beyond that? Being specific (i.e. staying away from terms like 'analytical skills') would be appreciated.
Trying to learn specific things is a waste of time in my opinion - what you actually do and need will be learnt on the job. Instead, I would try and focus on what are (in my opinion) two of the most important skills:
TL;DR - Learn efficiency and accuracy, not specifics.
You should use the resources provided by Wall Street Oasis. Namely, the excel modelling skills.
Also, read the WSJ everyday and discuss the most interesting articles with friends, professors, or coworkers.
You should be confident in the skills you have, which you represented on your resume to get the job, and do your best to learn the rest when you start.
I'd put PowerPoint at the top of the list. You'll probably be producing 100+ slide decks. To be more specific, becoming good at PPT involves more than knowing the shortcuts -- it includes storyboarding/storylining, using the right diagrams/visuals, writing good headlines/copy, etc. This is a good book on creating consulting decks - http://learnppt.com/ebook.php
For Excel, I've found it very useful to know some basic Excel VBA. This really helps in automating, because there's a lot that pivot tables and formulas either can't do or do too inefficiently (i.e. will crash your Excel).
Read the FT also.
Accuracy is the most important aspect. Be able to read annual reports and other financial data effortlessly. Know what traps to look for in that can often be found in the "notes" section - off balance sheet commitments, restructuring, etc.
Efficiency! The truth is quicker you can get stuff done, the quicker you can put in front of clients/managers, and the quicker you can get feedback, and the quicker you can refine and build on your mistakes. Best way to build efficiency is by learning how to work the tools you have.
For excel, pivot tables are fine, but on a scale of 1 -5 i would rate those skills as noob level (although i tried the powerpivot extension which you have to download. Thats more useful but since most people won't have the extension downloaded, it is really for your personal use). learn hotkeys, someone mentioned INDEX MATCH, thats a life savior. if you can learn how to mix that up with ARRAY formulas, VBA scripts, and table formatting you can do magic in excel.
powerpoint is a little trickier because even if you learn all the tools and shortcuts, theres a decent amount of creativity that goes into it. e.g. you can learn to use a brush and paint and canvas, but doesnt mean you can make good decks. this is where efficiency helps because the more feedback you can get the better your decks will be. i look at some of my work from 3 years ago and i would be embarrassed to present it now. I posted some tips here: http://writingintransit.wordpress.com/2013/03/20/the-delicate-art-of-ma…
If you are specializing in a certain area, it obviously helps to read up on that industry/function. WSJ, Economist, FT are all good general resources but most industries have specialized publications - pick those up.
finally i would say dont be afraid to ask questions and be wrong, especially internally (in front of clients be mindful of who you are talking to. e.g. dont walk in to a strategy session and ask whats SWOT). if you dont understand something, ask for clarification or an explanation. I have found most people are happy to keep talking anyway so they tend not to mind answering INTELLIGENT questions. but be respectful of peoples time. if you have 10 questions, compile a list and set up a meeting rather than bugging the person every 2 minutes.
Skills to be a successful analyst? (Originally Posted: 06/10/2011)
I just finished my first year at school and I'm interested in pursuing a few years of analyst work after I graduate, mostly for exit opportunities. I haven't taken any courses relevant to finance yet, and I'm curious what I'm going to need to learn to perform as a successful analyst.
How much of the work analysts do has a strong foundation in classroom material and how much is based on things that you learn on the job?
Also, can anyone suggest any material that I should become familiar with and can teach myself over the next few years to make my time as an analyst go smoother, assuming I land a position at some point?
Thanks fo the help.
COOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOooool
you live a sad life
This website has some good material for wall street preparation. You should check them out. But basically an analyst's core skills should include:
-Being able to make powerpoints look pretty -Being able to be someone's slave -Being able to work up to 21 hours a day
these skills will go super far in the world of finance
Being able to crank
Being able to crank
being able to fondle and suck at the same time
close your mind, shut your mouth, open your ears, crank
do this...regards
Skills necessary for Financial Analyst corporate (Originally Posted: 09/07/2012)
Hi ! I am level 3 Candidate for CFA Program and recently relocated to US. I have 3 years Financial Analyst Experience back home .I had my Masters from Australia. Now when I am trying to enter Industry here , I am finding it difficult. Firstly, i know no body here so networking is at a very slow pace. Secondly, some roles require SAP , some require Hyperion. I am not sure thus is getting SAP FICO training would help me be a Financial Analyst in Corporation. Please advise me what to do ?? I am in DFW, TX...
Being a Financial Analyst for F500 is like being a pizza delivery guy... There are a few types: 1) The guy that doesn't know where he's going, has to call back to the shop for directions. When the pizza finally arrives, it's cold and no one is hungry. 2) The guy that arrives on time; but, when I open the box, the pizza is mushed and the all the delicious toppings are stuck to the box. Plus, dude forgot the garlic sauce! 3) The guy that delivers the pizza and everything is as expected. 4) The guy that comes early, sets the table, pours me a drink, and lights the candles. The pizza is just as I expect it; hell, he brought me extra garlic sauce. I love that shit. Which pizza guy are you?
Et illum aut facilis quia. Eligendi cum qui reiciendis incidunt nulla iure qui. Minima qui libero modi quo iste explicabo voluptatibus. Sit similique nihil quia ea exercitationem nihil. Velit nostrum dolorem nihil ad. Quibusdam rerum vero esse at reiciendis.
Velit voluptas at harum nesciunt veniam qui eius. Quae aut sed officia ratione quaerat cupiditate dolor. Quia omnis quae officiis voluptas consequatur dolorem atque aliquam. Magni officiis quia vitae dolorum quibusdam quia quidem.
Ipsam ut sit in odit. Et tenetur porro soluta. Mollitia magnam odit et quia et quis. Explicabo pariatur harum eum consequuntur explicabo quod. Magnam distinctio voluptas in vel nobis dolores eius. Officiis id nisi placeat eos illum. Ad omnis cupiditate nemo aliquam dicta molestias exercitationem.
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...