Showing results:
Displaying 351 - 380 of 380
Jane Street VBA and Excel
Hello, I will be going in for an in house interview with Jane Street Capital. My recruiter specifically told me I will be tested on my MS Excel and VBA skill set as they use of a lot Excel on the floor. To quote the exact words she said, "We will go to the trading floor where we will do something on...
excel 2007 used at BB banks?
Just curious if the larger investment banks have upgraded to office 2007? My buy-side firm is about to upgrade and i've heard that excel and PPT 2007 are horrible. really not looking forward to the switch...
Which Financial Modeling book?
Hi guys, I was wondering which Financial Modeling book is the best to learn and practice from it for basic to more advanced bankers? I was thinking about this one: http://www. amazon.com...
...one more Excel Q
Pretty simple one here. I am doing an IF function, and the condition I am testing is whether one cell (let's call it A1) equals a number of cells - let's call those cells B2, C3, D4, and E5. If A1 equals at least one of those four cells, the condition is true. Is there a simpler way to write this...
Interest Expense Loop in Excel
Y do you get a feedback loop in excel for interest expense when modeling?
Excel Question - Different format?
Quick Excel question: I have a large database of M&A transactions (date announced, target, acquiror, transaction value, LTM revenue, etc.) on one sheet. There's hundreds upon hundreds of transactions. One the second sheet, I want to set up six tables, each table showing the deals by a specific...
Hedge Fund Modeling
Guys, I'm starting at a hedge fund (long/short equity) and I'm trying to figure out what kind of modeling is involved. If any experienced folks want to weigh in that would be helpful. Also it'd be great if any of you have any examples that you don't mind sharing. Thanks.
Stupid excel grouping not working
One of the worksheets I've been using group rows for suddenly decided not to allow me to group anymore. I opened up my file this morning and all the group cells became hidden rows instead... and this isn't throughout the rest of my workbook... just this worksheet. I've been alt-d-g-g ing the shit...
Office 2007 questions (Excel 2007 sucks)
In the 2003 Excel , I was able to copy and paste special(enhanced metafile )blue hard-coded numbers into Powerpoint, but the number would show up in black. That way, exhibits in Excel w/ all the different font colors would show up as a standardized black font within a Powerpoint slide. For some...
Excel Question - Trying to build and automate a report
I am trying to build and "automate" a report that pulls data from many spreadsheets. I'm not too bad with excel but have little to no experience with macros, etc. but am willing to learn. Let's say I have a folder on my hard drive with a number of files titled "File 1 Jan 10 2009", "File 1 Jan 11...
Excel question - urgent
Excel gurus , I'm hoping you can help me out. I am currently building a debt schedule, that may be subject to a lot of changes (for one - the start date). I need to find some way to sum up the interest and principal repayment column totals for each year in a separate table. Except, since the dates...
3 dimensional datatable/graph for LBO returns in excel?
Hi, I've just finished a LBO model with a 2 dimensional datatable, with the effect of different values of the purchase price of the company and EBITDA exit multiples on the IRR of the deal. Would it also possible to build a 3 dimensional datatable (or graph?) to display the effect of three variables...
stupid excel question
Lets say cell A1 contains ' Deloitte '. In cell A2, I want it to say 'Big 4' if cell A1 contains 'Deloitte', ' KPMG ', ' Ernst & Young ', or ' PWC '. What should the formula for A2 be? I've tried =IF(A1=OR("Deloitte","KPMG","Ernst & Young","PMC"),"Big 4","Not Big 4") but that doesn't seem to give me...
Preslink for Office 2007
Hello, Does anyone have a copy of Dealmaven Preslink (specifically the application that allows you to link excels to .ppt; if the fastrack macro application is separate, I can do without it) that is compatible with office 2007? I moved jobs and tried installing the dealmaven productivity suite...
Excel 2007 - Have most BBs adopted 2007?
I've done a search on this but couldn't exactly find what I was looking for. Have most BBs adopted Excel /Office 2007 or are they still using 2003? Thanks!
trading comp sci question
Hey guys for an SA working on a rates trading desk this summer, what kind of programming languages should I brush up on or probably be using the most. VBA? C++? Java? Just basic excel?
Quick and Dirty LBO Model
Does anyone have or know of a good source to find quick and dirty LBO xls models. I'm talking your basic assumptions, sources and uses, simplified IRR calcs and then a simple operating model with IS, BS , SoCF and debt paydown schedule. In practicing for LBO modeling tests I was hoping to find some...
Excel question (groups)
Anybody know the xls shortcut to expand and collapse groups through the keyboard? thanks
Excel Help - Where is a tab name & range?
I need to use the following func. =+VLOOKUP($C13, ,4,FALSE) where is a tab name & range (that is computed) in cell A1 I can do Indirect(a1) and it works fine. Is there a way instead of using indirect and i can directly plug /compute that with vlookup func? thanks -Wiseguy
How long do traders out of college last at prop. shops on average?
Thought this was an interesting topic to explore. For those that suck, the longest I've seen is just over one year when they get the axe. I've actually seen shorter than a year (around 6-8 months) where the traders just quit b/c they make no money. What is the norm you've seen??
this is not rocket science
I’ve realized when your senior tells you “This is not rocket science.” repeatedly it’s a very polite way of saying “Are you a f**in idiot?” I had to make a chart which had two y axes, a line chart and a bar chart, and the two had different ranges. One was ranging from 0 to 30, and ranged...
How much is excel worth to you?
I'm writing a paper for a class and I need some rough data on how much people would pay for Excel , Word, etc. I'd really appreciate it if some of you could fill out my survey - it's really really short: http://www.surveymonkey.com/s.aspx?sm=LazlQdqCsvw… Thanks a bunch!
Excel Question - "upkeep" column?
I keep a bunch of data on every single time I go running, including date, pace, temperature, distance, etc. One of the pieces of data I keep track of is called "upkeep" and it is the sum of my distances ran over the past 30 days. Since I do not go running every single day I can't just use a simple...
Excel AutoSave with New File Name
I thought this topic was addressed on WSO before - but didn't see it. Any of you excel gurus know where an addin that would do this can be found? I want something that will save a file (not just autorecover info) with a new file name (ie change version #... v12 to v13) every x minutes. There's got...
Dealmaven FastTrack Macros
I don't know if these are widely used, but when I was in banking I loved them. They allowed you to track all cell precedents and dependants, format, etc and I loved them. Upon my move to Private equity a few years back I was able to obtain a version of them from Dealmaven which they provided an...
excel test
My interviewer wants me to take a 2 hour long excel test. I've done financial modeling training before, but I don't know what to expect. What test is going to take me two hours? do they expect me to make a model on the spot? Has anyone taken one this long before?
Selecting Part of Cell in Excel
If I have a cell "ABC-123" and I want to create a formula to only return me the first 3 char i.e. "ABC" - how do I do that.. thanks much What is a Cell in Excel? In excel, each unit on the workbook is called a "cell." Example - the first block in excel is labled "A1" - this is a cell. How to Select...
Excel Question - Best way to create sub table?
Lets say I have a table with data. I want to create a sub table that picks rows from the source table depending upon criteria. What is the best way to create the sub table (so that it does not have empty lines in between, if we were to follow a brute force method of creating) thanks
Decimal Excel Shortcut
I've tried searching elsewhere, creating macros, etc., so don't flame me for this question. Does anyone know of a shortcut that will move the decimal in or out by one place? This is driving me fcking nuts! Thanks 15% Off Wall St. Prep Financial Modeling Training Click Here
Excel Spreadsheets (LBO, DCF, etc.)
http://www.exinfm.com/free_spreadsheets.html saw this on doostang, good stuff. 15% Off Wall St. Prep Financial Modeling Training Click Here
or Want to Sign up with your social account?