Anyone have any good tips to start training with the neccasary Excel concepts that are useful in a ER position. Thanks all
Financial Modeling, Uses Excel - Simon Benninga
Financial Modeling, Uses Excel - Simon Benninga
I just picked up Benninga’s book yesterday on amazon.com. From what I’ve read it looks like a good purchase.
I didn’t use any really advanced Excel techniques in ER. I think it’s very important to understand how financial statements work together and then be incredibly detail orientated in making these things work together correctly in Excel. Get very comfortable with formulas that link to numerous other cells on multiple sheets.
brianr Wrote: ------------------------------------------------------- > I just picked up Benninga’s book yesterday on > amazon.com. From what I’ve read it looks like a > good purchase. Hey Brian…Did you purchase the 3rd edition (red cover and came out in February) or an earlier edition? Thanks.
Just remember: ctrl+shift+7 draws a box around your selected cells. Looks complicated and impresses the people standing behind you to no end. That, or download ASAP Utilities - it does all the common-sense things you wish Excel would do.
Just curious, what kind of advance excel features you guys use? What are Pivot tables used for?
As far as modeling knowledge goes, you can start by simply learning how to build a basic, three-statement model with the statements linked to one another…more commonly referred to as a fully-integrated model or a working model. Just ask around for a sell-side model and see how they’ve constructed it. In terms of most commonly used functions and keystrokes? Hmm…here are the ones I can think of: = + - * / ^ Alt-E-S series Alt-I-E F5 (go to cell) F9 (if on manual mode) Ctrl-Shift-7 (outline borders) Ctrl-Space or Shift-Space (to highlight entire columns or rows) SUMIF, COUNTIF VLOOKUP, HLOOKUP Alt-F4 (my favorite…means I can go home) That’s about all you need to know.
Since wer discussing Excel … I’m trying to drop the data field ( base currency market value ) into my pivot table however it does not show the actual values in the table , for some reason it drops the COUNT of the values in the table . Ex: Manager X has 9 securities in AUD , when i drop the data into the table instead of displaying the $ value of the 9 securities it shows 9 . I tried to change the field settings to SUM and then it gives me back 0 instead of the total ?
rudeboi, maybe its not recognising your data as numbers?
CFAdummy Wrote: ------------------------------------------------------- > Just curious, what kind of advance excel features > you guys use? What are Pivot tables used for? I love pivot tables. I think of them as dynamic charts. Grab a database and get ready for a thrill ride.
bluey Wrote: ------------------------------------------------------- > rudeboi, maybe its not recognising your data as > numbers? I think so . How do I fix it ? I’ve been trying this since last night …I went over the data page and formatted the cells as NUMBER .I’m not sure how else I can get my pivot table to recognise the data as numbers .
MPT, I picked up the Third edition. Sealed with CD for $56 shipped.
ChadD Wrote: ------------------------------------------------------- > Grab a database and get ready for a thrill ride. A thrill ride? You need to get out more! LOL
Rudeboi Wrote: ------------------------------------------------------- > bluey Wrote: > -------------------------------------------------- > ----- > > rudeboi, maybe its not recognising your data as > > numbers? > > I think so . How do I fix it ? I’ve been trying > this since last night …I went over the data page > and formatted the cells as NUMBER .I’m not sure > how else I can get my pivot table > to recognise the data as numbers . I’ve had this happen before and sometimes when the #'s were not being recognized even reformatting to “number” wouldn’t work, but copying the data into a new sheet (pasting special “value only”) sometimes works. As for the sum vs count- the only way to get the actual figure to show up is if the count=1, otherwise it will be the summation of all of the values. What I do sometimes if I just want to see the # and don’t want any sort of formula involved is to simply drop the data into the column field instead of the “data” field, that way it just shows up as is from the source. In office '07 the formatting is different so you have to change the “table settings” to have it straight across tabular as it was in the previous version.
Try using the Value() function (search Excel’s on-line help for details)
I;m not too sure what i did but i managed to get it to work …
All you gotta do is double click on where it says count on the table and that will bring up a menu where you can pick sum, average, count, min, max ect.
MPT, Follow up… it arrived today. I’m in the middle of chapter one, want to be as thorough as possible and I have to say this is well worth the price. If you have not already I would recommend picking it up. The reviews said it was a cookbook to modeling and honestly that is the best explanation I can give.