Showing results:
Displaying 201 - 250 of 380
Is there anyway to do this in Excel?
Using Excel on both monitors and you're in two separate files, but you want each file to recognize each other. Example: You have a number on one file in left monitor and another number in another file on your right number. How do you multiply (or do anything really) the number in file X (left...
What are the best Excel practices?
From Quora, the OP asked the following question: What are the best practices when modelling in Excel ? I have purposefully left the question open but feel free to leave advice for specific types of modelling Arnav Guleria, Trader Gone Rogue, had this top voted answer: I draw from Excel experience in...
Most Important Excel Skills for Consulting
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...
My CFA® Study Tracking Sheet
I managed to pass Level II with a good breakdown (> 70% in 7 sections including all the big ones, 3 between 50-70) in exactly three months. I attribute my success mainly to discipline and desire to pass (Unlike 90% of people taking the test, I've been wanting to take the test since sophomore year,...
Microsoft's Slide To Oblivion
Microsoft has been a behemoth among computing for the past 30 years. Most of us probably grew up with Windows 95 / 98 (Hover! anyone?) and have had Windows as the main part of our computing education. In the last 5 or so though they have become less and less relevant as the computing industry shifts...
Best Excel Crash Course ???
Can anyone recommend a good Microsoft Excel crash course that I could finish in a day or so? It does not have to have any advanced modeling instruction or anything like that, just a refresher course for someone who hasn't really used it since college haha... Thanks guys..
Using IsError instead of Circ switch
Does anyone use the =If(IsError(A1),0.01,A1) function instead of the usual circ switch on the interest expense/income lines in the Income Statement when building a model? How does actually work because with a circularity, there may not be an error....
Showing Excel Skills to Interviewer
I just had a phone interview with a multistrategy real estate fund manager for an analyst position. I'm a current undergrad and got the interview despite the job looking for 2-3 years of exp in IB / PE . The interviewer and I hit it off, but he told me that he was unsure of my Excel skills just due...
What does an "Advanced user of Excel" know?
If I claimed that I am an advanced level user of MS Excel , what are some of the critical things that I must know? Thank you.
Excel question, please help
Hi monkeys, I am trying to construct an IF formula. I have a set of data of precedent transactions , their value in one column and their industry in another. I need to find the total value of transactions per industry group, so how should I structure this formula as to reference to calculate the...
How complex are actual models?
There are seemingly huge differences in the complexities of the models provided with Rosenbaum and Pearl and from Macabacus.com. For example the lbo model from Rosenbaum is a few hundred rows spread over several worksheets but the LBO from Macabacus is 1623 rows. Which model is more inline with what...
PDF to Excel converter that works?
Does anyone know of a good PDF to Excel converter that you can get for free online?
How Much Do FT Analysts Know Before Start (GS,MS,BX)?
A friend of mine (and yes, in this situation it actually is a friend) is starting at a GS TMT /MS M&A / BX type ibanking job (won't say which to remain anonymous). He is quite nervous because he did an internship at a different firm and not in banking, and got really lucky with getting the job. He...
Brackets Shortcut in Excel?
Already tried googling. So I know there's a shortcut to anchor a part of cell using F4 when you're in your formula bar. But, if I want to put brackets around some parts in my formula bar, is there a shortcut? E.g. I'm trying to type =(A5+B3)*5 I have =A5+B3 typed in the formula bar, is there any...
Which certifications are worth getting while studying MSF
I will be enrolled in WUSTL's MSF quant track for the next year and half, and I am thinking about getting as many certifications as possible while at school. Considering the limited time I can allocate toward studying for the exams, I am just carious as to which of the following certifications are...
How to Build F'ing Amazing Decks for a BSD
I gotta say, my life has improved dramatically since I got to the point where I could control much of the messaging my team produces. Before I go any further, huge caveat: this is completely culture-specific and audience-specific. There are some groups out there that would hand me my walking papers...
Are there any free sources that can check an entire list of emails to see if they bounce or are bad?
I have an excel sheet with over 2000 names and emails. I know there are sites I can individually check emails, but are there any sites or free programs where I can import an excel list and do this?
3 Statement Model - Having Some Problems
I am working on my modeling skills and while I have learned a lot from Macabacus and the two Josh’s ibanking book and some guides, I am still struggling with constructing a fully integrated 3-statement model. My main sources of confusion stem from three areas. 1) The first is in constructing the...
Bell Curve % Distribution for Costs
I've been unsuccessful trying to find a resource that gives me a formula for how to find bell curve distribution % in excel (using normdist formula or others that are more applicable) to spread costs. I am trying to make it dynamic based on whatever assumptions we use for the construction period....
Project Management Tool
Project management is not easy. Keeping track of deadlines, status, risks, issues, and competing priorities is not piece of cake. There are hundreds of articles and management gurus out there with tips and advice on effective project management. However, few (that I have seen) provide tools to put...
Model Template
Hey Monkeys, I was hoping someone could send me a template they use to keep track of the models they’ve been taking out on dates? I know people sometimes post DCF and lbo models , so I figured this would be a good place to ask. I stumbled across a copy of David Merkur’s spreadsheet, but I found...
Fastest way to learn excel material like VLOOKUP, pivot tables, etc.
I have the excel bible (2007) is that the ideal source to use? If anyone has a fast method of learning functions like these I'd love to hear it!
Excel Mistakes
So apparently a couple of economists, Kenneth Rogoff and Carmen Reinhart, made a colossal fuck-up on excel that led to a faulty conclusion for their paper. Now, not referencing all the relevant cells is some real first year amateur hour shit, but this reminds me of the time I used an improper...
Quick Excel Help
If I have a formula in one sheet (say it's a sum formula), is there a way to highlight the cells its pulling from if those cells are in a different sheet? Basically is there a way to get the F2 function to work across sheets. Thanks
Excel 2010 - F5
As you know, the F5 key in Windows does several functions: in browsers it refreshes the page, and in excel it brings up the Go To menu. Lately every time I press F5 - in a browser, in Excel - the "Windows Help & Support" window pops up (this is different from the Excel Help F1). Any ideas on how to...
PWM spreadsheets
I know PWM does not model like other analysts positions, but does anyone have any idea where I might be able to find some resemblance of what a BB PWM might use in terms of spreadsheets. I am just trying to become as familiar with the tools of the trade as I possibly can. Thanks
Analyst, Funds Administration...what's in it for me?
Hello, The title is: Analyst, Funds Administration... for a big insurance company. Its back office stuff. I was wondering 1- What to expect from the job in terms of learning experience that can be transferrable in the future. 2- How will that experience be valued for from of a FO /consulting/...
Excel Formatting Question
Does anyone know how to have Excel automatically format cells depending on the contents being values, formulas, off-worksheet references (i.e. blue / black / green) without using a paid plug-in? I am trying to get this to work with conditional formatting but am having no luck. Thanks.
Am I an expert in Excel?
Functionality mastered: - Spreading financial statements - Numerous functions - Graphs - Formatting - V / H LOOK UP - Pivot tables - External web data import - Logic (If Statements) - VBA / Macros On the sample resume I am looking at it says expert in Excel and I wondered if that was something I...
Financial modeling course for fundamental long term investing
I'm looking for a financial modeling course to do at home in the evenings, and I have noticed that most of what's available out there tends to lay on the lbo /merger side of things. So wondering if anyone knows a good one to prepare for roles in fundamental long term investing (value-style). Many...
Excel Macro files
Can we have the ability to attach an Excel Macro (.xlsm) file to messages and posts? Thanks.
Need To Become Excel Expert In One Week
What would you suggest?
Excel 2010 Help!- My cells don't update
I have my excel model on manual and have been hitting F9 repeatedly but still my cells don't update. A short term fix I discovered is to select all my cells in the worksheet and replace = with = to "wake-up" excel. However, I need a long term fix or I have to rebuild this model from scratch. What do...
Running a Macro
I wrote the code for an Excel VBA macro and can"t figure out to run in excel 2010. Does anyone have a tutorial that will show me how to run my code?
Bond trading
Hi all, long time reader, first time poster. I've used the search function on WSO and haven't seen very much content on trading bonds using a virtual account. On that point, I have two questions: First, does anyone know of any good virtual platforms one can use to trade government bonds online?...
Model unbalanced by decimal places
I have a model I developed that is of medium complexity, and I have an interesting problem that I am not sure how to resolve, thought I'd hit you guys up to see if anyone has dealt with this before.
Excel Question - Generate all combination?
1) How do I get excel to generate all combinations 1x10 vector with only 0s and 1s. Ex: 1010100111, 0001000110, etc... 2) my spreadsheet takes the arrays above as an input and then computes a number. Using all of the combinations generated above, how do I get excel to calculate the result for each...
model calibration
guys, i was hoping you could give me a few insights on calibrating my financial model , whats the best way to go about it? How do you guys on the street go about it?
Excel model help
So I have a question regarding modeling in excel. I can't figure out what function to use and it's probably really easy but I've never had any training, just what I've taught myself thus far. I have my loan amort schedule for 60 months. I have one cell that's an input where I put in the month where...
Excel interpolation
All, Looking for some help in excel. Trying to do an interpolation model on returns based off of volume. Pretend I'm selling 3 widgets with a return of 4.402% and when I sell 4 widgets I get a return of 26.626%. How can I interpolate the data in excel to give me 3.25, 3.875, etc. I've tried scouring...
What to be familiar with in Excel, PP, etc
Hi All, I'll be starting my first year with a firm in a few months and would appreciate any insight as to what specific uses within Microsoft Office (Excel, PP) are expected of your average first year. I have the opportunity to brush up on my Excel skills through the firm I currently work with and...
Excel Question - Creating charts from data
Hi-I am creating charts from data that is over time (over the past 25 years). I would like to have my chart show vertical shaded bars where there were recessions over that period (i.e. 91-92). Is there a way to do this automatically without manually and sloppily trying to draw it in myself? Thanks!
I love this GIF Story-telling
This should happen more often. I found it in when in finance http://www.businessinsider.com/bernanke-vs-woodfo…
How would you model this scenario?
Guys, I have a quick modeling problem. I'm using a standard bulge ( Citi ) model and we have a client that is trying to raise debt capital to build a new facility. The catch is, they want to draw down on the $120mm debt in different months to minimize interest. Here are the conditions: -$120 debt...
Pershing Square's "Open Source Model"
Just finished reading Confidence Game by Christine Richard. Over the course of the book she mentions a CDO valuation spreadsheet called the "Open Source Model" that was released to the public. It has over 600 tabs and was used to value MBIA's CDOs. Google reveals that the link Pershing Square posted...
Excel Question - Sorting the last column of a table?
How do I sort the last column of a table by the value of the sum of the formula from smallest to largest when the table is only formulas? I think this is a stupid question but I really can't find the answer anywhere
Excel Help - Working on a project in Excel
Hey guys I am working on a project in Excel at the moment and I need a function that will delete all text to the right of the second period of a string of text for an entire column of data. For example: I like cars. Cars are cool. Cars are fast. I need a function that will delete everything after...
Microsoft Office Proficiency
Mergers & Inquisitions as many of you know has a resume template that they have designed and make available to the public. They also give out resume tips. One of them being that you should NOT list microsoft office skill proficiencies (excel, powerpoint, etc...) on your resume. However, I hardly...
Trace Precedents Function
Fellow Excel Monkeys, I have a quick question regarding the tracing precedents shortcut. For example, let's say we have two sheets called '2010' and '2009' and I currently have a formula on '2010' that is A1+'2009'B1. When I use the trace precedent function, it will show me the A1 on '2010'. Is...
Strange Ctrl+v problem
I'm using Excel 2010 and running into this strange issue: when doing Ctrl+c then Ctrl+v, it starts to automatically paste as value instead of keeping the formula. It started randomly acting up like this and don't know how to switch it back to normal... Help pls?? P.S. also Ctrl+c and then Enter...
or Want to Sign up with your social account?