• stoy@lemmy.zip
    link
    fedilink
    arrow-up
    5
    arrow-down
    1
    ·
    1 year ago

    IT guy here, Excel is a data analytics tool, not a database, not a word processor, not a sales system, not a photo album, not a notepad, not a paint program.

    If at anytime you are treating Excel as a database, you are doing it wrong, and you deserve me mocking you when asking for help recovering it when it breaks, I won’t as I am not a dick, but if I did, you would deserve it.

    If you want a database, build an SQL database, or have someone build it for you, not me.

    • Samsy@lemmy.ml
      link
      fedilink
      arrow-up
      0
      ·
      edit-2
      1 year ago

      The problem is, people dig to deep into excel functions, some of them could easily build a database or do some programming (if/else), but they know nothing outside of their ms-office -ecosystem.

      Just a hint for ms-office devs, why not a low-code-builder with SQL backend. Just call it squirrel or powersql or something.

      • ElderWendigo@sh.itjust.works
        link
        fedilink
        arrow-up
        2
        ·
        1 year ago

        It’s more than just knowing things outside the ms office ecosystem. People use the tools they have. So when IT locks down the whole system and it takes an act of God to get anything else installed, you find ways to hammer that nail with whatever blunt object you have in hand.

    • Socsa@sh.itjust.works
      link
      fedilink
      arrow-up
      0
      arrow-down
      2
      ·
      1 year ago

      It’s not even a good analytics tool. If you submit an academic paper with excel plots in it, I’ll reject that shit without reading it and type “lmaoooooooo…” To the review character limit.

      My 12 year old child knows how to use matplotlib and he thinks Santa can fit down a chimney.