Hi, occasional spreadsheet user here who cannot tell the difference between Excel and, say, LibreOffice Calc (which is what I use, disclosed). Why is Excel specifically better? No troll.
I did and it’s awesome. People like to shit on Excel, but there is a reason why every business on earth runs on Excel. It’s a great tool and if you really learn it, you can do great things with it.
JTode@lemmy.world 11 hours ago
JensSpahnpasta@feddit.org 4 hours ago
Just to give you two examples of stuff I used today:
Excel has PowerQuery, which is a really fancy and nice way of importing data into your spreadsheet. You can import data from another spreadsheet, from an CSV, a database or from websites and update them with one click. You can also transform that data during import. So if you want to just use two columns of that spreadsheet from accounting, you can import them in the format you need. And if accounting updates their spreadsheet, you can update yours with one click. LibreOffice doesn’t have this as far as I know with that power.
The other one is simply plugins for nearly every other business system in the world. I have this nice BI plugin which gives me a pivot table of our sales data. So if I want to know how my revenue was yesterday, I can update my spreadsheet with one click. I can also jack into our CRM and get f.e. visit data from our sales reps.
So in this case I can take some data that is sitting somewhere on the company drive, import & transform it and then mash it up with sales data from BI and CRM. So building a quick report like “which accounts were created last year and have no sales and have no visit from sales reps” is quite easy. And if I want I can also set this up to create this with PowerQuery & Co so that I can do this report monthly/weekly without having to copy & paste data every time. That’s not really possible with LibreOffice right now.
There will be comments that this is not a job for Excel and that you should use Python/SQL queries/whatever for that task, but Excel is what most companies have. I could do it with Python, but it is not installed on my business computer and people are used to Excel and are not trained in Python. There is a reason why businesses are using Excel for everything and that is because it is easy, quick and gets shit done
aesthelete@lemmy.world 1 day ago
It’s just a generic table thing mostly. Turns out tables are a good way to lay out a bunch of different information.
Somehow nobody has made a similar generic application to allow you to work with nested list, outline, or tree style structures, which I think are equally if not more useful structures to lay out certain types of information.
pycorax@sh.itjust.works 23 hours ago
Tables isn’t what make Excel or it’s alternatives excel at tasks. If that’s all it were, it’d be easily replaced. The formulas and all the other features that help you format, arrange and represent that data is what really makes it good.
Corkyskog@sh.itjust.works 22 hours ago
I remember in college we would use it to run Monte Carlo simulations, which I thought was cool.
aesthelete@lemmy.world 19 hours ago
It’s not 100% of it, but it’s a large portion.
Excel isn’t replaced because your company already bought it. There are many alternatives to Excel and most of them are acceptable to the overwhelming majority of people who use Excel (people using it for tables and basic graphs) and none of them have displaced Excel.
I mean look at Word. It absolutely sucks and yet it’s standard anyway. Same with Outlook.
pycorax@sh.itjust.works 18 hours ago
Hence why I mentioned Excel or it’s alternatives. I was responding to you referring to spreadsheet software as a simple matrix.