• BarqsHasBite@lemmy.world
    link
    fedilink
    English
    arrow-up
    5
    arrow-down
    1
    ·
    edit-2
    4 hours ago

    Um excel certainly has its places, but accounting? Don’t they have actual dedicated software for accounting? HR? Like payroll? Again don’t they have actual software for that?

    And I was thinking personal use, whose costs were posted. $100 a year, fuck that.

    • UnderpantsWeevil@lemmy.world
      link
      fedilink
      English
      arrow-up
      5
      ·
      5 hours ago

      It’s hard to believe, but I work at a Fortune 100 company that’s still heavily reliant on Excel.

      Sure, we have specific software as System of Record (Oracle suite, mainly). But for all the day to day estimating and calculating and reporting and other noodling, people routinely export to Excel and play with numbers from there.

      • BarqsHasBite@lemmy.world
        link
        fedilink
        English
        arrow-up
        3
        ·
        edit-2
        5 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
          ·
          1 hour 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
            ·
            35 minutes 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.