Gotta learn Excel.
At the risk of feeling stupid, I would like to ask everyone. I need to learn excel as part of my job, while I'm ok at doing the basic data spreadsheeting, I needed to start doing more serious work on excel (risk management, etc). My background is mostly Unix/Java/Script. Is there a book or place I can start learning this stuff?
If you have some exposure to Functional Programming, Hard Core Excel should not too difficult to pick-up. You will have to get to speed on VBA if you want to expose any of the data outside the sheets.
Thanks, yes, I don't plan on writing numeric processing part in VB, most of them are done on unix server. I don't think I'll have a problem learning the language. I found VBA and Excel is easy yet very bad programming style. There are several books on amazon, but none of them seems to help you with programming VBA and link up with other modules (C or C++).
Compile the C code into DLLs and call them from VBA.
On rewriting functions for binomial distributions: that's actually not a bad idea, as Excel doesn't necessarily do it correctly!
You can automate Excel from any programming language that can call COM objects. You can also get Visual Studio Tools for Office, which lets you automate Excel from .Net and tie the underlying dll to the spreadsheet, making it a "smart" spreadsheet.
This is a real handy MSDN page that shows how to automate a lot of common tasks in Excel:
yet another anon
You can automate Excel directly from Python using PythonCom
Heres the course of action I would recommend as a quick start:
And of course, don't forget to consider OpenOffice.org as an alternative to Excel.
Here are some good weblinks for learning Excel/VBA.
Fog Creek Home