• Uninvited Guest@lemmy.ca
    link
    fedilink
    English
    arrow-up
    3
    ·
    9 days 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.

    • MrSulu@lemmy.ml
      link
      fedilink
      English
      arrow-up
      2
      ·
      9 days 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
      link
      fedilink
      English
      arrow-up
      2
      arrow-down
      1
      ·
      9 days ago

      Why excel for super complex computations? At some point, just code your solution instead… It’s easier than troubleshooting Excel