this post was submitted on 15 Jul 2025
496 points (97.3% liked)

Science Memes

15822 readers
2055 users here now

Welcome to c/science_memes @ Mander.xyz!

A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.



Rules

  1. Don't throw mud. Behave like an intellectual and remember the human.
  2. Keep it rooted (on topic).
  3. No spam.
  4. Infographics welcome, get schooled.

This is a science community. We use the Dawkins definition of meme.



Research Committee

Other Mander Communities

Science and Research

Biology and Life Sciences

Physical Sciences

Humanities and Social Sciences

Practical and Applied Sciences

Memes

Miscellaneous

founded 2 years ago
MODERATORS
 
top 50 comments
sorted by: hot top controversial new old
[–] badlilbean@sh.itjust.works 1 points 43 minutes ago

So what is everyone using instead of excel or libreoffice calc?

[–] callouscomic@lemmy.zip 124 points 3 days ago* (last edited 3 days ago) (19 children)

I learned how to do a fucking LOT of statistical shit in my degree. I also learned to get REALLY good at all kinds of shit in Excel.

Guess which helped my career on an actual practical way the most? Guess which made people seek me out at work for help with things?

Sometimes Excel is what's available. Sometimes it's just faster to do it that way rather than code up some ridiculously overdone solution in some programming language. Having both skills is best, but don't shit on opening an excel and just fucking getting it done, whatever it is.

If used right, it can also be a great equalizer with those less technically skilled in your workplace. You can quickly format and tune things and even layer a little bit of vba to make their lives easier without having to get into the complexity of an entire bespoke coded solution.


Also, a reminder for those in the back. For most of us, we aren't in college to learn a specific skill so much as we are there to learn how to be taught. To prove we are capable of taking instructions and producing results as requested.

If you never understand this, then you'll never understand later why you fail to land a high quality job.

[–] rockstarmode@lemmy.world 19 points 2 days ago

we aren't in college to learn a specific skill so much as we are there to learn how to be taught.

I really like this idea, but prefer one small change: I think it's best to learn how to learn.

Learning how to be taught is part of that, and a large part. Understanding when to absorb information, rely on experts, and apply yourself until you improve is fundamental. You won't get any arguments from me there.

But being taught is only one facet of learning. Sometimes experts aren't really experts, or don't have the learner's best interests at heart, or omit things to protect their own interests or ideology.

Learning how to learn involves fostering fundamental curiosity, not being afraid to fail, asking all the questions even dumb ones or those with seemingly obvious answers. Finding out "why" something works instead of just "how". Fundamentally curious people who learn as a habit tend to also develop a scientific method-like approach to evaluating incoming information: "Ok, this is the information I'm presented with, let's assume the opposite, can I prove the null hypothesis?" This acts as a pretty good bullshit detector, or at the very least trains learners to be skeptical, to trust but verify, which is enormously important in the age of misinformation.

Being taught generally tapers off as someone gets older, or becomes an expert. Learning never needs to taper off, so long as your brain still works.

[–] expr@programming.dev 2 points 1 day ago

https://www.visidata.org/

Blows Excel out of the water, and it's not even close. And it's free, open source, and completely extensible (with Python, not some godforsaken excuse for a programming language).

[–] TomMasz@piefed.social 25 points 2 days ago (1 children)

"Sometimes Excel is what's available."

I worked for a Big Company that was cutting back and dropped their Oracle contracts, forcing all the DBAs to work in Access. Then they fired all the DBAs, forcing everyone to either try to figure out Access or switch to Excel. Guess which way they went.

In my last job at that company, my department had built an Excel spreadsheet (database) so large and full of calculations they had to request money to update our machines to 64-bit Windows and 16GB RAM just to run it.

[–] Adalast@lemmy.world 1 points 1 day ago

Learning to learn is what the 12 years of babysitting we all go through is supposed to be doing. The fact you overlook that is why we have a >50% illiteracy rate in the USA. Post secondary education is 100% about learning advanced skills and developing the techniques needed for a career. Saying otherwise is why companies are looking for doctoral degrees for entry level positions and they can all burn in hell.

load more comments (15 replies)
[–] Newsteinleo@midwest.social 132 points 3 days ago (4 children)

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.

[–] funkyfarmington@lemmy.world 44 points 3 days ago (1 children)

I heard its good for databases...

[–] Gustephan@lemmy.world 31 points 3 days ago (1 children)

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

[–] mEEGal@lemmy.world 24 points 3 days ago (1 children)

some businesses just deserve to die, and are actively working towards it

[–] HobbitFoot@thelemmy.club 6 points 2 days ago (1 children)

A lot of companies are like this.

load more comments (1 replies)
[–] Droggelbecher@lemmy.world 29 points 3 days ago (1 children)

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.

load more comments (1 replies)
[–] Safeguard@beehaw.org 17 points 3 days ago (2 children)

The point is that learning institutions should not prefer one commercial companies solutions vs another.

In fact, they should not use or be dependent on commercial companies at all.

Learning stuff and implementing what you learned should be available for all. Not just people with the money.

Companies know this so they give away their stuff for free to these schools knowing they will contain these people for life.

We need to break out of that extreme vendor lock-in.

load more comments (2 replies)
load more comments (1 replies)
[–] KTJ_microbes@mander.xyz 24 points 2 days ago (2 children)
[–] captainlezbian@lemmy.world 4 points 2 days ago

R is great. Your boss will give you excel.

[–] austinfloyd@ttrpg.network 5 points 2 days ago

Hell, R was being used in colleges in 2000. Unfortunately, whether it was SPSS for the soft sciences or forcing stats work in Matlab for the engineers, professors always seemed bad at promoting the right tool for the job.

[–] rudyharrelson@lemmy.radio 61 points 3 days ago* (last edited 3 days ago) (4 children)

I'm no academic, but it seems wrong to me that any field would require the use of a particular proprietary software in order to do one's homework assignments.

May Excel or SPSS be the best tool for the job? In many cases, sure! But students should be allowed to use whatever other software can also get the job done, as long as the software exports the assignment in a data format that the professor can reasonably ingest (e.g.: turning in a CSV file, which can be understood by many different kinds of software, not just Excel).

I understand professors have limited time to check homework and thus don't want to spend time learning how to do anything but open a single, specific filetype, but that's besides the point.

[–] blarghly@lemmy.world 41 points 3 days ago (3 children)

It is extremely common for classes to require students to learn to use proprietary software. It's a tool of the trade. If they graduate you without teaching you how to use it, they'd be fucking you over and ruining their own reputation. Like, imagine an accounting student graduating not knowing excel, because they did all their assignments using MatLab because they liked it better. It would be absolutely unthinkable for any potential employer to hire such a student. Excel is the software they use in that field. If a student wants to learn a different option in their free time, that's fine and dandy.

[–] rudyharrelson@lemmy.radio 22 points 3 days ago* (last edited 3 days ago)

It is extremely common for classes to require students to learn to use proprietary software. It’s a tool of the trade.

I understand that; my position is more ideological than practical. In an ideal scenario, AutoDesk, Adobe, Microsoft, etc wouldn't be so deeply entrenched in their respective fields such that they are the de-facto tools of the trade for every business which must be learned in order to be hired. I know a given student has to learn certain proprietary tools in the current academic and professional environment. My comment was saying I would prefer this not to be the case. I am fully aware that proprietary software domination in the academic and professional spaces is not going away any time soon.

In my ideal scenario, an interviewer at a company would ask, "Can you perform the following edits to a given graphic?" instead of "Can you use Photoshop?" since the former allows for candidates who can use alternatives like GIMP. I understand company pipelines aren't set up for this, either, because company pipelines are also deeply entrenched in proprietary software.

The OP's photo is specifically about professors allowing other software to be used. Which would be a good starting point for making these kinds of changes.

[–] feinstruktur@lemmy.ml 8 points 3 days ago

What does not knowing excel even mean? If you're in STEM and would be tought the fundamentals of statistics independently of any software tool, you would gain the knowledge to apply these skills to any tool. And sorry to say, but after that Excel is just learning syntax.

load more comments (1 replies)
[–] icelimit@lemmy.ml 24 points 3 days ago (2 children)

I can never say this enough: the best tool is the tool that gets the job done

[–] Goodeye8@piefed.social 19 points 3 days ago (1 children)

Found the guy who would use a flathead screwdriver to regulate a demon core.

Not only did it get the job done, it got the spectators well done.

load more comments (1 replies)
[–] fmstrat@lemmy.nowsci.com 10 points 3 days ago (1 children)

Hmm. What about CAD? The professor going to teach FreeCAD, OpenSCAD, F360, OnShape, etc?

I think requiring one tool is OK. You're there to learn the process in a way that you can migrate to what you want later. Teachers aren't paid enough as it is, so it should be made as easy as possible for them to manage the flow of work.

[–] BuboScandiacus@mander.xyz 7 points 3 days ago

Yeah, FreeCAD is open source and great (I use it at home)

But you're not landing a job requiring it, you'll use SolidWorks like everybody else

And if you find yourself in the 10% of companies which use some other CAD program, you will have to learn on the job

load more comments (1 replies)
[–] Chrobin@discuss.tchncs.de 21 points 3 days ago (1 children)

That reminds me of a story my bachelor's supervisor in astrophysics told me: One of his best PhDs applied at an insurance company. They got an Excel sheet with data that they had 1 week to analyze. All the other applicants took the whole week. He just put it in Python, solved it in a few hours, and got the job.

[–] AnarchistArtificer@slrpnk.net 2 points 2 days ago (1 children)

This is only tangentially related to your story, but you reminded me of an old maths teacher who had a PhD in maths and once upon a time, had applied to work at an accounting firm. As part of the interview, he was told that he would have to sit a numeracy assessment. He responded "you do know I have a PhD in maths, right?". They sympathised with his point but told him that everyone had to sit the test, as a matter of course.

So my maths teacher goes and sits their silly test, and he scores so well that they accuse him of cheating! I can only assume that this debacle broke him in some way, because it wasn't long after this that he started teaching. It's a particular kind of weirdo who has a PhD in a subject and decides to teach teenagers. He was probably one of the best teachers I ever had (I wonder if I can find contact information for him to tell him that)

load more comments (1 replies)
[–] Gustephan@lemmy.world 15 points 3 days ago (10 children)

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

load more comments (10 replies)
[–] kadup@lemmy.world 8 points 2 days ago (2 children)

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 10 points 2 days ago

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

[–] AnarchistArtificer@slrpnk.net 4 points 2 days ago

I agree. I learned a lot of bioinformatics stuff from the ground up, because I was learning python at the time, and found it super useful as practice. Years later, I discovered https://rosalind.info/ and cursed the fact that I hadn't had access to that when I was learning.

[–] melsaskca@lemmy.ca 9 points 2 days ago

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

[–] ComradeRachel@lemmy.blahaj.zone 14 points 3 days ago (1 children)
load more comments (1 replies)
[–] shalafi@lemmy.world 12 points 3 days ago* (last edited 3 days ago) (8 children)

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.

[–] ryedaft@sh.itjust.works 10 points 3 days ago (1 children)

Haha, Microsoft absolutely changes shit all the time. Millions of organisations around the world have an octogenarian computer standing somewhere in a corner because they need it running the old software.

[–] shalafi@lemmy.world 5 points 2 days ago* (last edited 2 days ago)

Not Excel they don't, not ever. Been working in the office for almost 30 years. Excel does not change except to add tidbits and it's fully backwards compatible. You don't have any experience in this, do you?

load more comments (7 replies)
[–] steal_your_face@lemmy.ml 9 points 3 days ago

LinkedIn ass title

[–] burntbacon@discuss.tchncs.de 10 points 3 days ago

Heh. I actually was using SPSS in 2010 for statistics. Weird memory resurfacing there.

load more comments
view more: next ›