this post was submitted on 29 Aug 2024
295 points (93.0% liked)

Memes

45746 readers
1266 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
295
I hate excel so much (lemmy.dbzer0.com)
submitted 2 months ago* (last edited 2 months ago) by SandbagTiara2816@lemmy.dbzer0.com to c/memes@lemmy.ml
 
you are viewing a single comment's thread
view the rest of the comments
[–] jubilationtcornpone@sh.itjust.works 76 points 2 months ago* (last edited 2 months ago) (7 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.

[–] Droggelbecher@lemmy.world 40 points 2 months ago (1 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.

[–] GrammarPolice@lemmy.world 8 points 2 months ago (1 children)

Stop making me feel like my Excel knowledge is useless😔

Excel is definitely not useless! Learning a little Python (especially the pandas package) can go a long way in making data analysis easier though

[–] SandbagTiara2816@lemmy.dbzer0.com 13 points 2 months ago* (last edited 2 months ago) (3 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.

[–] jubilationtcornpone@sh.itjust.works 14 points 2 months ago (1 children)

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.

Capability is a double edged sword. Any tool that is capable of doing something is going to be used by someone to do that thing, regardless of whether it should be. Excel gets abused and used for things that it shouldn't be frequently in corporate environments because of its capabilities. I can understand being frustrated by that.

I use Excel for reporting and analytics because it makes manipulating and visualizing data very easy. Especially if you know what you're doing. No need to write a UI or worry about portability between workstations, etc. At the end of the day it's a tool. A very capable one. Like any tool, it's not the right one for every job.

[–] Zorsith@lemmy.blahaj.zone 3 points 2 months ago* (last edited 2 months ago)

I use excel because its stupidly easy to output a shitload of objects with properties (computers/hosts in my case) to a CSV via powershell and sort through the data.

[–] MissJinx@lemmy.world 3 points 2 months ago

ohh I see you can also use some ACL type of application. Excel is amazing but can't handle databasis, it has a very small limit

[–] raspberriesareyummy@lemmy.world 10 points 2 months ago (2 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.

[–] jubilationtcornpone@sh.itjust.works 10 points 2 months ago (3 children)

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

[–] ArtVandelay@lemmy.world 14 points 2 months ago* (last edited 2 months ago) (1 children)

cracks knuckles

import pandas as pd

Now you’re speaking my language!

[–] GissaMittJobb@lemmy.ml 6 points 2 months ago

Not saying there's any reason to switch, but I believe you can load CSV's into sqlite.

Datasette would be something that I would try for CSV's as well, that seems like an interesting piece of technology I haven't had reason to use yet.

Finally there's always Jupiter Notebook and any respectable DataFrame-solution.

Not to knock spreadsheet-solutions too much - I certainly see their value and use them frequently - but if I had to do something that warranted writing VBA, I'd probably reach for a tool I could combine with some form of VCS like Git at least.

[–] raspberriesareyummy@lemmy.world 3 points 2 months ago

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

[–] ArtVandelay@lemmy.world 5 points 2 months ago

Jupyter gang, any other data scientists here?

[–] Imgonnatrythis@sh.itjust.works 3 points 2 months ago (1 children)

Curious what you get out of value from the subscription that you wouldn't get from a slightly older non subscription version of excel?

[–] sheridan@lemmy.world 5 points 2 months ago (1 children)

Has XLOOKUP made its way into the non-subscription version? I've found it a lot easier and flexible to use than VLOOKUP.

[–] _wizard@lemmy.world 12 points 2 months ago

Index/match crew checking in.

[–] AlexWIWA@lemmy.ml 2 points 2 months ago (1 children)

Excel is probably the most powerful application ever created. Especially now that it can be connected to SQL and python natively

[–] raspberriesareyummy@lemmy.world 3 points 2 months ago

There's a tool for a given job. And for some, Excel may be decent. But for many, MS Access used to be far superior to Excel. Not sure if it is still maintained well, as I no longer use MicroShit

[–] KinglyWeevil@lemmy.dbzer0.com 1 points 2 months ago

I also love word, publisher, and visio.

I grudgingly accept outlook.

I despise PowerPoint