this post was submitted on 29 Aug 2024
307 points (93.5% liked)

Memes

45581 readers
2691 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
307
I hate excel so much (lemmy.dbzer0.com)
submitted 2 months ago* (last edited 2 months ago) by [email protected] to c/[email protected]
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 76 points 2 months ago* (last edited 2 months ago) (24 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] 10 points 2 months ago (6 children)

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

Only if you refuse to learn SQL and do everything in a fraction of the time with way more functionality.

[–] [email protected] 10 points 2 months ago (4 children)

That works when you have access to a SQL database instead of a bunch of massive CSV files.

[–] [email protected] 3 points 2 months ago

Importing CSV into SQL is trivial and gives you far more control than Excel can.

load more comments (3 replies)
load more comments (4 replies)
load more comments (21 replies)