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.
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.
Why excel for super complex computations? At some point, just code your solution instead… It’s easier than troubleshooting Excel
I am having vague nightmares of the Momte Carlo and Black Scholes sheets we would have to compile for financial engineering classes in college…
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