Funny thing about “AI skills” that I’ve noticed so far is that they are actually just skills in the thing you’re trying to get AI to help with. If you’re good at that, you can often (though not always) get an effective result. Mostly because you can talk about it at a deeper level and catch mistakes the AI makes.
If you have no idea about the thing, it might look competent to you, but you just won’t be catching the mistakes.
In that context, I would call them thought amplifiers and pretty effective at the whole “talking about something can help debug the problem, even if the other person doesn’t contribute anything of value because you have to look at the problem differently to explain it and that different perspective might make the solution more visible”, while also being able to contribute some valueable pieces.
JensSpahnpasta@feddit.org 3 weeks ago
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.
aesthelete@lemmy.world 3 weeks 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 3 weeks 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 3 weeks ago
I remember in college we would use it to run Monte Carlo simulations, which I thought was cool.
aesthelete@lemmy.world 3 weeks 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.
JTode@lemmy.world 2 weeks ago
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.
JensSpahnpasta@feddit.org 2 weeks 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