|
01-19-2016, 06:39 PM | #23 |
Colonel
1859
Rep 2,537
Posts |
The critical thinking and analysis behind the model is a very big deal yes. BUT you also need to look at what your bosses do every day and start becoming better at those things as well. If it is PE/VC/Banking how well do you understand a stock purchase agreement and any other legal documentation involved? How well do you understand the 5,000 negotiating points that exist inside of every deal and what effect each would have on your outcome? How are your people skills? Do you know what it takes to sell whatever it is you do? How are your presentation skills? You get the point I'm sure. At the end of the day an excel model is a very small piece of the success or failure of your firm. Don't neglect all the other pieces.
|
Appreciate
1
|
02-23-2016, 01:56 PM | #24 |
Major General
3640
Rep 9,783
Posts |
I'm doing a simple vlookup and it's skipping over some of them and just doesn't work past a certain row. I did a spot check and the data is there. All the cells are formatted as numbers.
Help? |
Appreciate
0
|
02-23-2016, 03:58 PM | #25 |
Major General
3234
Rep 6,217
Posts |
You just need to be creative in the modeling logic. Without that you will never be great at it. Once you know the how - I want this to reference that and this to do that and so on - you can start googling how to make this do that. I've learned a lot on the job but the bulk of the advanced skills I learned was to teach myself how to execute the logic. I'm one of those don't even use the mouse guys.
__________________
|
Appreciate
0
|
02-23-2016, 04:00 PM | #26 | |
Major General
3234
Rep 6,217
Posts |
Quote:
__________________
|
|
Appreciate
0
|
02-23-2016, 04:02 PM | #27 | ||
Major General
3234
Rep 6,217
Posts |
Quote:
__________________
|
||
Appreciate
0
|
02-23-2016, 04:11 PM | #28 |
Major General
3234
Rep 6,217
Posts |
how many columns is your lookup table??
__________________
|
Appreciate
0
|
02-23-2016, 04:25 PM | #29 |
Colonel
1200
Rep 2,132
Posts |
"Crazy formulas" are usually just long, nested IF statements, etc.
The real key to Excel is being able to do the job in a concise formula. The best people I've seen in Excel have eloquent solutions to problems. The "formula gurus" always make things too complicated, increasing run times and calculations. Long story short, long formulas usually are inefficient and the people who use them don't think outside the box well. I'd focus on the latter. For example, having a formula with hard coated numbers = stupid (making long, complex formulas. Use tables and lookup references instead. Besides, using Excel is for worker bees....ever notice how directors and VPs are shit at Excel to the point that can't even do a simple pivot table? |
Appreciate
2
|
02-23-2016, 04:33 PM | #31 | |
Major General
3234
Rep 6,217
Posts |
Quote:
VP's don't really know well because excel and or the amount of metadata wasn't as big back then and they aren't really going to be the ones putting the stuff together. The smart ones know though, how the data should be parsed out and ask if you have done that already. One of our former VPs said when she first started the job 25 years ago people were using paper and pencil. WTF!!
__________________
|
|
Appreciate
1
|
02-23-2016, 04:34 PM | #32 |
Major General
3234
Rep 6,217
Posts |
sometimes excel gets foggy. I would start practicing index match rather than lookups.
__________________
|
Appreciate
0
|
02-23-2016, 04:41 PM | #33 |
Major General
2458
Rep 7,341
Posts |
This. I use INDEX/MATCH dozens of times each day.
Another finance guy here... I've taught myself quite a bit of excel VBA as well and the best method to learn is to do until you hit a roadblock then just google it. Almost every question I've ever had has been addressed on Mr Excel or Stack Overflow so I just thumb through until I find my solution. I'm constantly amazed by what the program is capable of. I have monthly presentations that used to take me two days to update (~100 pgs). I took a few days when it was slow to macro most of it and I've managed to shave an entire workday from the updating process. Aside from the time saved, it has also eliminated all human error which used to be a constant issue. I <3 Excel.
__________________
The views and opinions expressed in this post are those of the author and do not necessarily reflect the official policy or position of Bimmerpost.
2018 Jeep Grand Cherokee High Altitude Hemi | 2010 S4 Sold | 2010 BMW 135i Retired | 2006 Lotus Exige Sold |
Appreciate
1
|
02-23-2016, 04:43 PM | #34 |
Major General
3640
Rep 9,783
Posts |
|
Appreciate
0
|
02-23-2016, 04:48 PM | #35 | |
Major General
3234
Rep 6,217
Posts |
Quote:
Who is the VP going to ask to put together a complex analysis - someone who can do it quickly and accurately then spot check or someone who does it manually and then needs to check over their work manually for a while. That's how I've been able to succeed. To all, finance is such a broad term what do you guys do?
__________________
|
|
Appreciate
0
|
02-23-2016, 04:53 PM | #36 | |
Major General
3234
Rep 6,217
Posts |
Quote:
Are you by chance the person who left work to pursue some fun for a bit?
__________________
|
|
Appreciate
0
|
02-23-2016, 06:20 PM | #38 | |
Major General
3640
Rep 9,783
Posts |
Quote:
Always keeping an eye out for even better opportunities though. |
|
Appreciate
0
|
02-23-2016, 06:29 PM | #39 |
Major
990
Rep 1,017
Posts |
...this may be true, but us Drs had to start somewhere to get where we may be today, so to those looking to grow, excel is an ok skill to have. It is true i rarely need my vba skills much anymore, but from time to time I still do my own proofs or revalidations in certain situations and still can use vlooks with th best of 'em. But in enterprise situations, excel is not a preferred solution, in fact it's not used much as itsso inefficient, same goes for access which is a nono. If you are forward thinking in this space (finance and big data business intelligence) learn how to use etl tools along with reporting engines like business objects, tableau and the like, that's how u can unlock the power of the data
__________________
'22 X4 ///M Competition…Carbon Black Metallic/Sakhir Orange...pure driving excitement!!! ‘22 X3 Jetblack + some other stuff not from Munich
Dearly departed...'19 X2 M35i Past lives ‘16 M3…'13 640i GC...'13 335i...'08 M6 ...'05 645Ci...'00 323i...'85 735i...'77 630CSi...'86 325es ...'01 740iL...'09 X3 |
Appreciate
0
|
02-23-2016, 06:31 PM | #40 | ||
Major General
3234
Rep 6,217
Posts |
Quote:
I did market intelligence for about a year and it did take my excel skills above what you typically need in an fp&a role. So it's helped me build addition skills that my competition in my field doesn't have. So I've been able to land a new job at a start up like company basically building a finance dept from scratch. I start next week and it should be fun!
__________________
|
||
Appreciate
0
|
02-23-2016, 06:36 PM | #41 | |
Major General
3640
Rep 9,783
Posts |
Quote:
Lately I've been thinking in doing Sales Ops, Sales, or some role that deals with people more on a regular basis. Extrovert so the interaction gives me energy. Lol |
|
Appreciate
0
|
02-23-2016, 06:38 PM | #42 | |
Major General
3234
Rep 6,217
Posts |
Quote:
In excel modeling you can do a data dump and cut it however you want. In my field half the work is of ad hoc nature. There is no system that spit out what you want. No two analysis are the same. You have to take the data and manipulate it. That's the beauty of excel. Can you tell systems to alter assumptions to provide pro forma estimates quickly or to manually tweak a number here and there to alter the outcome? Different tools do different things better.
__________________
|
|
Appreciate
0
|
02-23-2016, 06:39 PM | #43 | |
Major General
3234
Rep 6,217
Posts |
Quote:
In excel modeling you can do a data dump and cut it however you want. In my field half the work is of ad hoc nature. There is no system that spit out what you want. No two analysis are the same. You have to take the data and manipulate it. That's the beauty of excel.
__________________
|
|
Appreciate
0
|
02-23-2016, 06:40 PM | #44 | ||
Major General
3234
Rep 6,217
Posts |
Quote:
__________________
|
||
Appreciate
0
|
Post Reply |
Bookmarks |
|
|