• BarqsHasBite@lemmy.world
    link
    fedilink
    English
    arrow-up
    3
    ·
    edit-2
    11 hours ago

    The point is you can use google docs or Libreoffice for day to day mundane things.

    It’s only the huge power features that you need Excel for, maybe in engineering. For accounting when you get to that power feature point I’m surprised there isn’t dedicated software.

    • toddestan@lemmy.world
      link
      fedilink
      English
      arrow-up
      2
      ·
      7 hours ago

      Excel is a spreadsheet, and spreadsheets like Excel are first and foremost aimed at accounting sort of tasks. Whether they actually need Excel versus something like Google Docs or Libreoffice is another thing. The big thing with Excel is that it gets used (and abused) to do things that it’s not really intended for doing such as those spreadsheets that are full of macros trying to be an application, or those spreadsheets that are trying to be a database, and so forth.

      From an engineering perspective, I find Excel to be annoying because it’s clearly first and foremost an accounting tool, and some of its behaviors like the way it rounds numbers and tries to turn everything into a date is downright obnoxious. I still use it from time to time for quick and dirty things like whipping up a couple of plots quickly (and this doesn’t really need Excel… but at work all the computers have Excel), but otherwise for anything more complicated I’d probably switch to something else.

      • BarqsHasBite@lemmy.world
        link
        fedilink
        English
        arrow-up
        1
        ·
        7 hours ago

        Like it’s a fun number cruncher, but for serious accounting that’s tied into point of sale, accounts receivable, accounts payable, etc you really should be running something dedicated. That’s why there are all these software companies making bank when from the outside you can’t quite figure out what they do.

        Protip on excel, when you start a new sheet ctrl+a, ctrl+1, change to number.