• nerdschleife@lemm.ee
    link
    fedilink
    English
    arrow-up
    68
    arrow-down
    1
    ·
    edit-2
    1 year ago

    2013-2016 excel is GOATed tbh. Usable and without the cloud bullshit Microsoft tried to push in the coming years

    (Yes, I still wish this wasn’t the industry standard office suite)

    • MissJinx@lemmy.world
      link
      fedilink
      arrow-up
      7
      ·
      1 year ago

      I’ve worked for a company that used google instead of microsoft, man… that was hard. It’s not standard for nothing, it’s a lot better.

      • ManosTheHandsOfFate@lemmy.world
        link
        fedilink
        arrow-up
        5
        ·
        1 year ago

        My company used Google for a few years. Higher level Excel users hated Sheets and didn’t give up Excel. But for the rest of us riffraff Sheets was great. The collaboration features work really well, better than Office 360.

        • xpinchx@lemmy.world
          link
          fedilink
          arrow-up
          2
          arrow-down
          1
          ·
          1 year ago

          I’m one of the Excel guys, I live by tables, PowerQuery, VBA/UDFs, and loading data from APIs and SQL databases. If any of that functionality lives in Sheets I’ve never been able to figure it out productively.

          My last contract used Sheets and I felt like a toddler, it’s too different for my tastes.

      • rambos@lemm.ee
        link
        fedilink
        arrow-up
        7
        ·
        1 year ago

        Same here. Usually office 2007 + saveaspdf plugin + local language pack is my way to go, but recently started using only office and Im amazed how compatible it is, at least for my usage.

    • Shard@lemmy.world
      link
      fedilink
      arrow-up
      4
      ·
      1 year ago

      I work in Data centers. A few years back I saw a banking customer with a mainframe computer in their hall while we were upgrading the buildings cooling systems.

    • Hyggyldy@sffa.community
      link
      fedilink
      arrow-up
      1
      ·
      edit-2
      1 year ago

      It seems to be solid for making calculators. I’ve used a number of build optimizers for various games that are made in Excel.

      Edit: Actually I guess they’re Google Sheets. Idk how the feature sets compare.

    • PerogiBoi@lemmy.ca
      link
      fedilink
      English
      arrow-up
      24
      ·
      1 year ago

      You would be honestly very uncomfortable if you knew how much sensitive information is stored on the desktop of someone as an excel spreadsheet.

      • manny_stillwagon@mander.xyz
        link
        fedilink
        arrow-up
        12
        ·
        1 year ago

        I used to work for municipal government in a major American city. The database for the entire city downloaded query results to your desktop formatted as Excel 95. Still does.

        At one point I had to install special R packages because someone retired and I was tasked with taking over the worksheet they had been maintaining forever and the usual R packages to read data from Excel can’t parse Excel 5.0.

        There was also someone in the office who still used a typewriter on the regular.

        • PerogiBoi@lemmy.ca
          link
          fedilink
          English
          arrow-up
          4
          ·
          1 year ago

          You and I live similar lives in different places.

          There are people in my office that print out their emails to read at their desk, right in front of their computer.

          Collaborative document editing has been around for over a decade, and yet we’re still emailing each other different versions of docs.

          • manny_stillwagon@mander.xyz
            link
            fedilink
            arrow-up
            4
            ·
            1 year ago

            Yup, I had someone print off Excel sheets, manually highlight and write in corrections, and them bring the pages over to my desk to have me fix them in the file.

            I also once had the city reject a report I submitted because the width of the columns in the Excel file were different from the previous year and they wanted to print it all off on one page.

            • thebuoyancyofcitrus@beehaw.org
              link
              fedilink
              arrow-up
              4
              ·
              1 year ago

              Some number of years ago, I was an intern within a department of state government. I was tasked with helping to enrich their databases. So they sent over an Excel file. I did my thing and added new columns, then I had to send it back over to someone within each division so they could do the data entry. To my horror, when I went to visit one of the division heads, I saw their admin sitting at a computer with a printout of my changes sitting on a document holder next to the screen…manually typing geographic coordinates into a data entry form.

      • xpinchx@lemmy.world
        link
        fedilink
        arrow-up
        1
        ·
        1 year ago

        True, I work in ecomm and we definitely have database exports being passed around relatively freely. No passwords obviously, but segmentation data, emails, addresses, phone numbers, etc.

        We have good IT security but it still doesn’t feel great.

  • driving_crooner@lemmy.eco.br
    link
    fedilink
    arrow-up
    19
    ·
    1 year ago

    I’m trying to move away and doing all I can with python (pandas, numpy and friends). Everything starts with a pd.read_excel() and finish with a df.to_excel().

  • gbuttersnaps@programming.dev
    link
    fedilink
    arrow-up
    10
    ·
    1 year ago

    Having worked for a state government which maintained data for federal submissions in 15 different versions of the same giant excel file on 15 different computers, it’s scary how accurate this is.

    • Kresten@feddit.dk
      link
      fedilink
      arrow-up
      12
      ·
      1 year ago

      I think the joke is twofold. First of all, Microsoft pretty much has a monopoly on financial software with their excel, which shows that the entire global finances are in the hands of that crab.

      The second joke, must be that they never bother updating the suite to the latest, and solely depend on 2013🤷

      • ryathal@sh.itjust.works
        link
        fedilink
        arrow-up
        3
        ·
        1 year ago

        Not just financial documentation, but everything. Planning staff levels, work assignments, quarterly reports, bonus calculations, pto administration, and more. There’s likely people retiring that wrote an excel macro 20 years ago that still part of a critical business process.

      • peto (he/him)@lemm.ee
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

        For so much financial logic. Anywhere that a non-technical person is sat in front of a computer and given data you will find Excel.

        It is amazing what knots they will tie in it to avoid learning an actully useful tool.