Workers should learn AI skills and companies should use it because it’s a “cognitive amplifier,” claims Satya Nadella.
in other words please help us, use our AI
Workers should learn AI skills and companies should use it because it’s a “cognitive amplifier,” claims Satya Nadella.
in other words please help us, use our AI
Has anyone in the last 15 years willingly learned excel? It seems like one of those things you have to learn on the job as your boomer managers insist on using it.
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.
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.
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
It’s just a generic table / matrix 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.
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.
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.
Hence why I mentioned Excel or it’s alternatives. I was responding to you referring to spreadsheet software as a simple table/matrix.
I wasn’t saying that’s all it is. I was and am saying that that’s why and how a large portion of people use it.
There is a lot of usefulness in simple data structures with a GUI over top. That’s why the data structures were invented in the first place. People–especially in software product management–are insistent that the complicated features are what keep people using software, even when it’s obviously untrue.
I remember in college we would use it to run Monte Carlo simulations, which I thought was cool.
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.
Holy crap, I think you’ve cracked it.
LLM AI is the trillion collar costing, terawatt consuming rubber ducky for the new millennium!
You forgot water stealing and methane spewing
I willingly learned excel in the past 15 years!
I have since moved on to open source replacements.
how else are you going to perform, document, and communicate engineering calculations in a format that is simple, intuitive, flexible, and easy to iterate upon?
I’ve willingly learned Calc (LibreOffice’s open-source spreadsheet tool) because I’ve made spreadsheets for my own needs. But to “become employable”? No way.
Yeah, very good analogy actually…
I remember back in the day people putting stuff like ‘Microsoft Word’ under ‘skills’. Instead of thinking ‘oh good, they will be able to use Word competently’, the impression was ‘my god, they think Word is a skill worth bragging about, I’m inclined to believe they have no useful skills’.
‘Excel skills’ on a resume is just so vague, people put it down when they just figured out they can click and put things into a table, some people will be able to quickly roll some complicated formula, which is at least more of a skill (I’d rather program a normal way than try to wrangle some of the abominations I’ve seen in excel sheets).
Using an LLM is not a skill with a significant acquisition cost. To the extent that it does or does not work, it doesn’t really need learning. If anything people who overthink the ‘skill’ of writing a prompt just end up with stupid superstitions that don’t work, and when they first find out that it doesn’t work, they just grow new prompt superstitions to add to it to ‘fix’ the problem.
Skill in Excel is wholly different than skills in other Office products. But if Excel is on your resume, your better expand and show what real use you’ve made of it. Otherwise it comes off just as you said.
That’s the way I also think about learning fancy spreadsheet stuff. Spreadsheets are good for putting data into a graph. They’re good for basic numeric stuff where there’s a simple pattern that repeats. But, pretty soon you’re in a situation where you should either have a real database or a real program. If you’re doing a lot of manipulation of data, you should have a program with loops, conditionals, errors, exceptions, etc. and most importantly with comments. If you’re storing a lot of data, you should be using a real database, not hundreds of lines in a spreadsheet.
If, at the end, you do want something visual, and don’t feel like dealing with a graphics library, you can always export the data to a CSV and import that into a spreadsheet.
Way back in the day a bunch of people endorsed me on linkedin for a bunch of nonsense like that and I manually hid all of it lol
I do. Got a free license from my last job and Excel blows the doors off Calc, or anything else. For business, Excel is moat of the reason they’re so tied into Office.
I did take a few courses on excel over the last 25 years. I don’t use excel that much but most features will never be used by most people.