this post was submitted on 29 Aug 2024
305 points (93.4% liked)

Memes

47098 readers
1205 users here now

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 5 years ago
MODERATORS
305
I hate excel so much (lemmy.dbzer0.com)
submitted 5 months ago* (last edited 5 months ago) by [email protected] to c/[email protected]
 
(page 2) 3 comments
sorted by: hot top controversial new old
[–] [email protected] 74 points 5 months ago* (last edited 5 months ago) (16 children)

You're entitled to your opinion but I would say Excel is one of the best, if not THE best spreadsheet application ever produced. It's one thing that Microsoft actually got mostly right and one of the only reasons I still pay for an Office 365 subscription.

If you're just creating simple spreadsheets, there's plenty of other options out there.

But, if you're a power user doing a lot of complex data analytics, Excel is still the king.

My main gripe is that I still have to use VBA for a lot of stuff behind the scenes. Yuck.

[–] [email protected] 39 points 5 months ago (2 children)

If you're going to do complex data analysis, isn't it a pain to use ANY spreadsheet software, no matter how good? I do mine as a Jupyter notebook. The spreadsheet is just for looking at the numbers, maybe sorting some things.

load more comments (2 replies)
[–] [email protected] 14 points 5 months ago* (last edited 5 months ago) (6 children)

I’m not a power user, so I’m often frustrated by Excel trying to do things I don’t want it to and by its abundance of features that I’ll never use.

And at least at my workplace, a lot of work processes use poorly-designed Excel spreadsheets for critical tasks, because it’s such a simple way to manipulate data.

I also find that when I need to do more complicated data analysis, Excel starts to become limited, and I find Python to be a more powerful and flexible tool.

load more comments (6 replies)
load more comments (14 replies)
load more comments
view more: ‹ prev next ›