Technology

Not if microslop can do anything about it, you thought regular excel was bad, now checkout the new "AI enhanced" excel

I know, but capturing business logic in spreadsheets is a different error I didn't want to get into here... You do what you can.

It's one of the friendliest programming languages around. If you have written something in VBA then you'll do fine with Python, except for all the bad/outdated nonsense you'll have picked up from that language. And there's interactive interpreters you can just mess around in.

If this doesn't scare you then give it a look:

things = [4, 8, 15, 16, 23, 42]
for number in things:
    print(number * 16)

64
128
240
256
368
672

it was partly made for mathematicians who did not know how to develop software, but also for education. so I guess it's a good starter language. but it allows doing way too much things that will be very confusing when overused

If you are running multiple databases you are already a "tech people"

Sharepoint is not a "database". Many people have made that mistake and it eventually comes back to bite you.

I would recommend learning SQL. It is made to be human readable, and we've been perfecting it since the 1960's.

Python let you run SQL on any file, and standard DB technology with a very small number of lines of code. Recommend reading about Pandas

None of those positions are expected to know VBA script either.

No, but for these OnlyOffice is a viable alternative. @surgarsweat was referring to way advanced features, not something secretaries or HR or accounting will need. I have use OnlyOffice for 6 years now, and have yet to find an Excel need it could not fulfill.

Exactly, spreadsheets themselves are the bottleneck, they worked back in the day but data and analytics have moved well beyond that, but companies refuse to migrate to a modern architecture because the dinosaurs in charge are afraid of change.

The issue is that a lot of processes need to be understood by people who have no IT background. Your basic office drones need to be able to use it, enter data, and make changes. Every applicant in an office job will be relatively proficient in Excel.
If you move your process to another solution, the majority of your employees will have to be re-trained.

As a data consultant, I would say those companies already do question the process, and have done for decades.

Yes there are countless situations where a dedicated system or database could and should replace Excel, but there are just as many scenarios where Excel is ideal, and swapping out a spreadsheet for what would be potentially tens of separate applications across the business, or one absurdly expensive behemoth, to perform tasks that could be done rapidly and clearly in Excel is neither practical nor economically viable for most companies. A spreadsheet is perfect for plenty of situations.

My job is literally to help these companies move to appropriate database solutions, often transitioning away from Excel. But there’s no getting around that a spreadsheet solves (often simple) problems that are impractical with other tools. You can move a company to a supplier’s sector-specific solution and solve huge numbers of issues, but unless that solution exactly meets every aspect of the business requirements, there’s always going to be a fallback and it’s often Excel, for better or worse.

I'm confused. Excel is a spreadsheet, that's always in the form of a table.

I like to think of libreoffice calc as a spreadsheet program, it's for running calculations on cells, that's it.

Excel was, but is no longer, just a spreadsheet program. Many things have been smashed into it that could have been better implemented separately, but when you're trying to tie down all office work to your single office suite, a hammer's gotta hammer. So they hammered a lot of those uses into excel to keep office workers tied to it. Admittedly, that does make it easier for office work since you don't need to train employees in multiple programs, you give them excel and teach them functions as they need them.