• Uninvited Guest@lemmy.ca
    link
    fedilink
    English
    arrow-up
    2
    ·
    3 hours ago

    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
      link
      fedilink
      English
      arrow-up
      1
      ·
      3 hours ago

      I am having vague nightmares of the Momte Carlo and Black Scholes sheets we would have to compile for financial engineering classes in college…

    • MrSulu@lemmy.ml
      link
      fedilink
      English
      arrow-up
      1
      ·
      3 hours 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