• Newsteinleo@midwest.social
    link
    fedilink
    English
    arrow-up
    64
    ·
    2 months ago

    I got bad news for this guy, his employer is only going to pay for excel and his coworker only knows how to use excel so he better learn to use excel. Also people do a lot of things in excel that have no business being done in excel.

      • Gustephan@lemmy.world
        link
        fedilink
        English
        arrow-up
        13
        ·
        2 months ago

        I used to maintain an excel database along with an ecosystem of internal engineering tools in excel/vba. I worked in a vault, and one day I asked my isso if I could get python on some of the machines in my lab. A full 1.5 years later they got back to me that some security office was finally ready to consider my request and sent me a bunch of paperwork to fill out to justify why I needed python. And separate copies for each individual library I wanted to come with it. Needless to say I went on continuing to maintain my excel database and toolkit

    • Droggelbecher@lemmy.world
      link
      fedilink
      English
      arrow-up
      17
      ·
      2 months ago

      My high school IT teacher said this outright. He was a FOSS guy, but he said employers will expect MS Office, so we’re going to be learning that.

      Funnily enough proprietary software is frowned upon in my professional domain. Im not mad though, the excel commands and whatnot still work in libre office spreadsheets.

      Unrelatedly, doing statistics in a spreadsheet program sounds like absolute hell.

    • merari42@lemmy.world
      link
      fedilink
      English
      arrow-up
      5
      ·
      2 months ago

      I have coded VBA-based shadow-IT back in the day, but I seriously think this is something that needs to disappear in most firms that still have it. It is typically unmaintable automation of tasks at the department level that is super dependent on who is around and is still often in use after the programmers are long gone. I have seen a few old VBA tools in use that should be done with standard python/R or god forbid even JS Code in a decent documented repo.

  • shalafi@lemmy.world
    link
    fedilink
    English
    arrow-up
    14
    arrow-down
    6
    ·
    edit-2
    2 months ago

    Excel dominates the world of number crunching. Want to change that? You can’t.

    Imagine proposing an alternative for your organization that has been using Excel for two decades. Will every single sheet and workbook translate perfectly? If not, not good enough for dealing with numbers. This is why MS never fucks around with Excel. The risk/reward calculation (heh) is not a fit for open source spreadsheets.

  • Gustephan@lemmy.world
    link
    fedilink
    English
    arrow-up
    8
    ·
    2 months ago

    Old people and technology man. My advisor during my masters was an absolutely brilliant woman; she’s one of the people who has been basically defining the field of data science since the early 90s. The first time I ever published with her, I sent my first draft and her response was “can you convert this to docx? I don’t know how to work with tex.” I still think she’s one of the most brilliant people I’ve ever known but damn did it hurt to work on Microsoft word documents with her

    • Taalnazi@lemmy.world
      link
      fedilink
      English
      arrow-up
      5
      ·
      2 months ago

      Have you got recommendations for learning how to use tex, R, or Python for those that haven’t learnt how to programme?

      • Log in | Sign up@lemmy.world
        link
        fedilink
        English
        arrow-up
        5
        arrow-down
        1
        ·
        edit-2
        2 months ago

        I think there are free editors for LaTeX that show you the code and the end result next to each other, and let you edit either.

        You need to learn the ability to resist the urge to tweak layout. You’re using a professional document preparation tool that well make your document look professional. Playing with trendy fonts and margins and placement is how regular people make documents in a word processor that look less professional than LaTeX.

        LaTeX gives you the respectability of the corporate style of the professional science researcher, but if you want free-form do-it-how-you-like, you really really really don’t want LaTeX.

      • sunstoned@lemmus.org
        link
        fedilink
        English
        arrow-up
        1
        ·
        edit-2
        2 months ago

        Unironically – use markdown. It’s far more intuitive for most people, comes with similar git tracking benefits, and has simpler compilation / tooling steps.

      • Gustephan@lemmy.world
        link
        fedilink
        English
        arrow-up
        1
        ·
        2 months ago

        YouTube. Straight up. When I learned to code my yt search history was a million different versions of “how to <do thing> in python” for months. I also really liked the “Computational methods for physics” textbook (you can find the pdf for free on cambridge website), but that book is written for an audience that knows near graduate math but starts praying if their advisor asks them to write a program

      • Diplomjodler@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        arrow-down
        2
        ·
        2 months ago

        Start out with Python. It’s easy to learn and there are tons of courses and tutorials out there. Unless you want to be a professional programmer, it’s all you’ll ever need. Learning tex in this day and age is a waste of time, if you ask me.

    • icelimit@lemmy.ml
      link
      fedilink
      English
      arrow-up
      4
      arrow-down
      1
      ·
      edit-2
      2 months ago

      It’s the tool that she’s learned to get the job done, the virtue of the tool does not matter to a master craftsmanperson, only their proficiency.

      • Gustephan@lemmy.world
        link
        fedilink
        English
        arrow-up
        6
        ·
        2 months ago

        That might be the stupidest thought terminating cliché ive ever heard. The virtue of the tool absolutely does matter. I’m not out here trying to metaphorically mine iron with a pickaxe when we have metaphorical excavators available, and no amount of expertise will allow somebody to be more efficient with the pickaxe than any random novice with an excavator.

  • melsaskca@lemmy.ca
    link
    fedilink
    English
    arrow-up
    4
    ·
    2 months ago

    If the math underneath is valid then I don’t really care what calculator I use.

  • radix@lemmy.world
    link
    fedilink
    English
    arrow-up
    3
    ·
    2 months ago

    They were living in 2025 when they posted that in 2023. I don’t think the stats software is the biggest story here.

  • kadu@lemmy.world
    link
    fedilink
    English
    arrow-up
    3
    ·
    2 months ago

    Excel I agree with.

    But sometimes there is value in teaching the old tools/frameworks for doing something. For instance, in bioinformatics, I prefer students that can explain what the FASTA format is versus just boinking the pretty GUI button on the proprietary format used by their sequencer.

    • sfjvvssss@lemmy.world
      link
      fedilink
      English
      arrow-up
      5
      ·
      2 months ago

      Not sure if the post is about GUI vs non-GUI. I read it as use R or pandas instead if SPSS.