this post was submitted on 15 Jul 2025
1 points (100.0% liked)
Science Memes
15836 readers
175 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
- Don't throw mud. Behave like an intellectual and remember the human.
- Keep it rooted (on topic).
- No spam.
- 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
- !abiogenesis@mander.xyz
- !animal-behavior@mander.xyz
- !anthropology@mander.xyz
- !arachnology@mander.xyz
- !balconygardening@slrpnk.net
- !biodiversity@mander.xyz
- !biology@mander.xyz
- !biophysics@mander.xyz
- !botany@mander.xyz
- !ecology@mander.xyz
- !entomology@mander.xyz
- !fermentation@mander.xyz
- !herpetology@mander.xyz
- !houseplants@mander.xyz
- !medicine@mander.xyz
- !microscopy@mander.xyz
- !mycology@mander.xyz
- !nudibranchs@mander.xyz
- !nutrition@mander.xyz
- !palaeoecology@mander.xyz
- !palaeontology@mander.xyz
- !photosynthesis@mander.xyz
- !plantid@mander.xyz
- !plants@mander.xyz
- !reptiles and amphibians@mander.xyz
Physical Sciences
- !astronomy@mander.xyz
- !chemistry@mander.xyz
- !earthscience@mander.xyz
- !geography@mander.xyz
- !geospatial@mander.xyz
- !nuclear@mander.xyz
- !physics@mander.xyz
- !quantum-computing@mander.xyz
- !spectroscopy@mander.xyz
Humanities and Social Sciences
Practical and Applied Sciences
- !exercise-and sports-science@mander.xyz
- !gardening@mander.xyz
- !self sufficiency@mander.xyz
- !soilscience@slrpnk.net
- !terrariums@mander.xyz
- !timelapse@mander.xyz
Memes
Miscellaneous
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.
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).
FOSS is always available. R is always available. Your points remain but you're never in a situation where Excel is the only thing you can use.
R, the language where dependency resolution is built upon thoughts and prayers.
Say what you want about Excel, but compatibility is kinda decent (ignoring locales and DNA sequences). Meanwhile, good luck replicating your R installation on another machine.
You heard about conda/containers/pixi/whatever?
PS: Excel will often fail if your system has a different default language. Like in many European countries one and a half is 1,5, not 1.5. Excel can't take it.
This is more of an argument for LibreOffice (and in line with the post you're replying to) than it's an argument for using a programming language, let alone a specific one.
Current version of Excel stripped out a macro I made to make a specific task easier. It didn’t just block it from running. It refused to let me even see it anymore.
LibreOffice allowed me to see it again so I could re-implement it temporarily. I love how often Microsoft’s own tools can’t do what FOSS can with Microsoft files.
Where I worked, many of the contacts specifically said we could not use open source software, so no, it is not always available.
Why did the contracts specify that?
A lot of government stuff requires that they have complete provenance of all code in the system. When you have people contributing to it from different places - potentially different countries - they get nervous about it.
You'd think they'd also be worried about most proprietary software being a black box when it comes to their code. But it could be only a secondary concern
We were restricted even on some proprietary software (especially if it was from a foreign owned company), but you'd be surprised how much scrutiny some of the major packages have had.
You are if company policy dictates that's all you can use.
Lemmy Silver™🥈 incoming !
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.
"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.