|
AJzer posted:Hey! Programmers over in the Cavern of COBOL have no idea what I'm talking about when I discuss deep excel financial models! Go figure... What version of excel are you using?
|
# ¿ Aug 20, 2011 03:35 |
|
|
# ¿ May 14, 2024 18:53 |
|
f2a posted:Looked at MATLAB? Failing that, Python with Numpy+SciPy is a very good (and free alternative). Both have more of a learning curve than Excel, but you get a lot more power and flexibility. The alternative is VBA, since you can shove it behind excel and integrate with your existing work. It's probably less of a step than resorting to numpy or the like. Matlab is great, though. Matlab.
|
# ¿ Aug 20, 2011 16:35 |
|
tolerabletariff posted:Work/life balance, yo I thought that term had no place in this thread.
|
# ¿ Oct 23, 2011 01:57 |
|
Thoogsby posted:M&I released their preview a week or so ago. http://www.mergersandinquisitions.com/2012-investment-banking-bonus-predictions/ Holy crap I had no clue you guys worked on what is basically a 50% total package bonus system. Does everyone get some form of bonus regardless (hence the bands of $$), or are these M&I figures quoted only given to select top performers within a firm?
|
# ¿ May 30, 2012 16:25 |
|
I really wish I could see actual examples of what you kids do in Excel. I want to know what sort of complexity your stuff gets to and how much you have to do.
|
# ¿ Jun 28, 2012 09:28 |
|
Its Miller Time posted:Who has a personal email that isn't firstlast@gmail I do because it's my high-school era account but I also have a first.last@ISP which I use for anything semi-professional.
|
# ¿ Dec 1, 2012 11:01 |
|
I hope you don't use the mouse in Excel whatsoever. Anything else would shatter my dreams.
|
# ¿ May 28, 2013 11:26 |
|
bam thwok posted:SumIf. I avoid pivots whenever possible, since you'll get occasionally bullshit around source data changes, refreshes, missed check-boxes when recreating views, etc. sumproduct((range1=criteria1)*(range2=criteria2)*etcetcetc) if you need to sumif across multiple columns pivots feel like cheating, really :excellyfe: e: and if you use vlookup rather than index/match you are literally subhuman
|
# ¿ Sep 10, 2013 12:59 |
|
bam thwok posted:I live on the wild side. I don't even use ",false" in my vlookups. You're the reason the GFC happened.
|
# ¿ Sep 11, 2013 01:46 |
|
FunOne posted:Why not just use SUMIFS? Because most of my company still has office 2003. Also, SUMIFS works on a boolean AND function between all of the criteria whereas you can use SUMPRODUCT to do AND and OR boolean functions between the operators. It's more flexible because it's an arbitary mathematical function rather than assumed to be a summation of a bunch of criteria being true or false. take for example, SUMPRODUCT(volume)*((shape="Cube")+(shape="Cylinder"))*(height>100)) That'll sum the volumes of all objects with a height of over 100 that are either Cubes or Cylinders. It distills each criteria down to a 0 or 1, so you're able to chain them together in boolean maths in any way you like.
|
# ¿ Sep 11, 2013 09:24 |
|
if it doesn't have spaces in the list of data, indirect("A"&count(A:A)) will do that. Modify the A's to B's if it's column B, etc.
|
# ¿ Sep 12, 2013 11:07 |
|
|
# ¿ May 14, 2024 18:53 |
|
More excelchat because this blew my mind as I'd never seen it, despite basically living in the program: =SUM(Sheet1:Sheet5!A1) works as you'd expect. We need a PYF excel tricks thread. E: it doesn't even need sequential numbering in it. It treats the sheet order in the bottom-left as a sequential dimension. So you can do London:Moscow!A1:B5 and select across A1-B5 in all sheets between London and Moscow, as per the sheet order. Nam Taf fucked around with this message at 08:31 on Sep 25, 2013 |
# ¿ Sep 25, 2013 08:14 |