I am having vague nightmares of the Momte Carlo and Black Scholes sheets we would have to compile for financial engineering classes in college…
What about tables, pivot tables, power query, grouping of rows and columns , and how is formula/function parity (xlookup, index, match, sumproduct, etc)?
I’ve made some truly Frankenstein sheets that I’m not sure could be stitched together elsewhere.
Corkyskog@sh.itjust.works 6 months ago
MrSulu@lemmy.ml 6 months ago
I don’t have any issues. It’s free to download to any operating system. So give it a try. See if it can open your existing Excel spreadsheets
LordCrom@lemmy.world 6 months ago
Why excel for super complex computations? At some point, just code your solution instead… It’s easier than troubleshooting Excel