I hate excel so much : memes

[–] 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😔

[–] SandbagTiara2816@lemmy.dbzer0.com 5 points 2 months ago

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) (5 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

load more comments (3 replies)

[–] 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

[–] SandbagTiara2816@lemmy.dbzer0.com 5 points 2 months ago

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

load more comments (1 replies)

[–] Track_Shovel 27 points 2 months ago

This whole thread could have been an access database

[–] wuphysics87@lemmy.ml 22 points 2 months ago

Excel can be it's own kind of awful, but using it with other people makes me want to jump off a bridge onto a rusty bed of nails. They move cells around, change the labels on columns, color cells with no benefit, change half a sheet to comic sans, they fucking send you back "bullshit-v1.0-good.xlsx” then ”garbage name v0.3_gooder.csv". Jesus fuck. The shitty thing has built in version control you ignorant fuck!

[–] lolola@lemmy.blahaj.zone 20 points 2 months ago (2 children)

This thread surprises me. Excel is fine, but I've seen people do so many silly things with it that it makes me dread having to use it. It's like they treat every cell as its own special little canvas... Oh, you wanna randomly change the date format from mm/dd/yyyy to dd-Mmm-yy mid-column? With Excel, anything is possible.

Maybe I just don't work well with others.

[–] Midnitte@beehaw.org 6 points 2 months ago

It doesn't help that Excel tries to be "smart"

Oh, putting in a lot#? Let's make that a date.

Most people don't set up an excel for what they want, they start using excel with what they have

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

The best way I've heard it explained is that excel is too good at doing too many, but it isn't the correct tool for many of those things. Since it's good and accessible, people make it work and then you get this jumbled mess of stuff after time passes.

[–] frezik@midwest.social 18 points 2 months ago

Spreadsheets generally are a useful tool, no matter if it's Excel, LibreOffice, or Google Sheets. There's a sweet spot where the data isn't so complicated that it justifies a full database and programming language.

There is a point, though, where you need to admit the dataset and your manipulations of it have gotten too big. If you were wondering who was excited about the Excel row limit going from 16k to 1M back in 2010, the answer is professors of Economics. This should tell you a lot.

[–] Paradachshund@lemmy.today 13 points 2 months ago (1 children)

I thought I hated excel, but then I tried Google sheets. Somehow it's even worse.

[–] Dymonika@beehaw.org 3 points 2 months ago

How? I live off of GS!

[–] ThePJN@sopuli.xyz 13 points 2 months ago (1 children)

Excel is okay as long as it stays in its lane.

It is not okay if you’ve ever worked in a printshop or do graphic design and people send in newsletters or brochures or some shit done within Excel.

Excel is many things; it is not fit to layout documents. Blegh.

[–] helpImTrappedOnline@lemmy.world 12 points 2 months ago* (last edited 2 months ago) (2 children)

To be fair word isn't good at it either.

I've found setting a PowerPoint slide to standard paper size is the best for quick page layout and "graphic design" for things like a poster or sign.

[–] ThePJN@sopuli.xyz 5 points 2 months ago (2 children)

Word being a word processor also sucks at document layout. Most software that isn't made for laying out documents suck at it, but people all try. My god do they try...

[–] helpImTrappedOnline@lemmy.world 2 points 2 months ago

Add one small image to word and the whole page goes nuts:

[🖼️] h

E L

L

O

[–] Tlaloc_Temporal@lemmy.ca 2 points 2 months ago (2 children)

What software is good for document layout anyway? Something with PDFs?

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

There's so-called desktop publishing software.

In the open-source world, I typically see Scribus recommended.

[–] Tlaloc_Temporal@lemmy.ca 2 points 2 months ago (2 children)

I'm probably dead wrong somehow, but I don't see why these aren't the standard text document software. Is there some part of just a solid wall of text that can't be done with DPS? Is the limitations of word processors somehow good for office use to the exclusion of slightly interesting formatting?

[–] Windows2000Srv@lemmy.ca 2 points 2 months ago

Automatic formatting. Try to have an automatic table of content with and automatic index of tables in draw, it's not available. When I write a lab report, I don't want to check every page to make sure the title 3 is still on page 4.

Formatting software are good at manual formatting. Word processors are good at convenience. Once you know your way around, you can be fairly good at formatting with them, and you get the advantages of having some automatic features.

[–] Ephera@lemmy.ml 2 points 2 months ago

Yeah, I find the similarity most striking with LibreOffice Draw vs. LibreOffice Writer. It very much feels like Draw is just a superset of the features of Writer.

There is certainly some differences, though, e.g. text doesn't automatically overflow onto new pages, text boxes don't automatically increase in size, things like that.
Everything is a lot more static, which is great for layout, and less great, if you just need to type out some text.

[–] ThePJN@sopuli.xyz 2 points 2 months ago

Adobe sucks but InDesign is still pretty much the standard; it begrudgingly does a pretty good job.

Affinity Publisher is coming along nicely though. And yeah Scribus is not too bad either.

[–] Rediphile@lemmy.ca 2 points 2 months ago

*Cries in vector

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

ohhh nonono You hate it because you either don't know how to use/don't use it enough, or you just don't like your job. Excel is amazing, I could cry talking about it hahaha I had to work with google sheets once and almost had a heart attack, if I had no excel my job would be unberable

[–] Railison@aussie.zone 3 points 2 months ago (2 children)

I’d agree with this. When I first started using Excel in school and university, I’d follow the instructions and not really know why I was doing what I was doing.

But then, having to work with Excel at work and make it do new shit, the penny dropped in my head and I understood how spreadsheets worked.

I use spreadsheets for heaps of things now, even if I don’t need to use formulas. Excel has some weird idiosyncrasies but it’s a good product overall. It’s not as bad as Word, which most people use incorrectly.

load more comments (2 replies)

[–] attempt@lemmy.world 9 points 2 months ago (1 children)

As a CPA I can attest Excel is really useful for financial data analysis and problem solving. It takes time to learn, and there are limitations to manage, but when you know what you’re doing it really gets out of your way so you can focus your attention on the work product instead of the tool.

On how I got efficient, when I started my career I tried to optimize any task I had to perform repetitively, and after 3 years everything was pretty fast. After that I tried to optimize one process every month, and now I have a pool of ideas to pull from when problem solving.

[–] AliSaket@mander.xyz 3 points 2 months ago

As an engineer I can attest that it is also useful for quick calculations and illustrations, especially at the concept stage. We also ran process "simulations" in it for fun, but of course something like SciLab would be better suited for it. The possibility to simultaneously work in the same spreadsheet was also a godsend during lock-downs.

[–] Kyoyeou 7 points 2 months ago (1 children)

God is Excel good, and I feel like I've barely touched the VBA part making buttons for my colleagues to get to certain parts of the Excel instantly. It runs well, and gets so much information out in a unique way, Speinkled with functions that run well . And it runs quite fast for something that can do so much

I'd say it's the task you do on it you dislike, not the program

[–] Ephera@lemmy.ml 1 points 2 months ago

Nah, I dislike all the other people using Excel. I once saw it used for providing a deployment configuration, which then got parsed from that Excel and pushed into a repo. Like, goddamn, just let me edit the repo directly.

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

But there's libreoffice calc tho

Memes

Rules: