4 ms·
Besides Dabble (which can kinda cut it for certain non-tech companies, but is primarily used by tech companies) Excel is the only real option and is probably Mi
by 3pt14159 18y ago
Besides Dabble (which can kinda cut it for certain non-tech companies, but is primarily used by tech companies) Excel is the only real option and is probably Microsoft's best product.
Sure it may have a few strange date bugs. Its column/row order shortcomings in vlookup() and hlookup() may be annoying. But you can really, really, really DO stuff with excel.
The learn curve for the software is basically Y = x^.7 (0<x<1) so getting started is as easy as you can get for a tool that can do all of the below:
Math functions (I could have individually listed them, but they are many, including correlations for many statistical distributions)
Financial functions (Mortgages, Black-Scholes, Variance)
Multi-Dimensional Linear Optimization - seriously, this can (with a bit of tweaking) also give you all non-inferior solution sets.
VBA - I hate programming Microsoft languages, but VBA was designed to be easy, and with excel it is SO easy. Relative cell references.
Stunningly beautiful graphs - Next time you are at excel and you need to show data really dig into how much you can change. You can make these things look extremely pretty if you take some time to learn how.
The nice part about all that stuff above is that the new/uninformed users don't every really have to worry about it. I've met tons of young people who got into programming because they started with macros (and later VBA) for Excel.
- avibryant 18y agoDabble is "primarily used by tech companies"? Where did you get that idea?