this post was submitted on 27 Jan 2024
15 points (100.0% liked)

Science Memes

10818 readers
2698 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.


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
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 0 points 9 months ago (6 children)

I will always appreciate a true Excel power user. I've seen some black magic shit.

[–] [email protected] 0 points 9 months ago

Used for the right purposes, Excel is an extremely versatile and powerful piece of software. Is use it all the time for analyzing complex financial data and turning pivot tables into really nice looking reports. I can use VBA behind the scenes to change report scenarios while preserving the formatting. Excel is great for things like that.

It's easy to get Into trouble though because eventually someone decides to keep a bunch of auxiliary -- yet somehow very important -- data in a spreadsheet. Before you know it, multiple people are being asked to maintain said data and then POOF! You now have a spreadsheet functioning as a database. It's all downhill from there.

[–] [email protected] 0 points 9 months ago

Yeah, but it's the kind of black magic where you accidentally summon Cthulhu and only notice it, after he destroyed half of the city.

[–] [email protected] 1 points 9 months ago

This is one of my favorites to share. It's a 3D engine with raytracing with no VBA scripting - all of the calculations are done internally with spreadsheet math.

[–] [email protected] 0 points 9 months ago (1 children)

Good Excel users think themselves better than a beginner. Great Excel users think themselves somewhere between Intermediate and Advanced. Excel Masters, and I know one who placed in that Excel data modeling competition, know they’re somewhere in the Intermediate to Advanced range.

[–] [email protected] 0 points 9 months ago

Excel masters wish the downloaded an ide a just coded all those tools the have to support now.

[–] [email protected] 0 points 9 months ago* (last edited 9 months ago) (1 children)

When you know Excel really well, it's like Legos for data. If you've got the imagination, intuition, and patience, you can make some incredible stuff.

[–] [email protected] 0 points 9 months ago (3 children)

And between knowing Excel like you've described and knowing only the basics exists an uncanny valley of being able to create some truly revolting abominations. Additionally when all you know is Excel, every problem becomes a spreadsheet, for better or for worse (usually the latter).

[–] [email protected] 0 points 9 months ago

This user:

"Don't worry I'm learning Power BI so I won't have to use Excel for everything soon."

[–] [email protected] 0 points 9 months ago

Yeah, I appreciate that, and it's really annoying. But it is still remarkable how Excel can pull off all of those abominations while having such a comparatively low skill floor.

Like Legos. Accessible, simple, capable of building a lot of things, but you'd obviously be better served making a house out of actual building materials.

[–] [email protected] 0 points 9 months ago

Program management system for the entire division? Excel. "Agile" task tracker? Excel. Requirements manager? Oh no no, that one's written in a word document with no version control. I have trauma. Use tools made for the thing you want to do, please.