Genuinely what do you need in excel you can’t do anywhere else? For me sheets are just glorified visual data storage. If I need to do complex stuff I can probably do it faster in polars or pandas than I can in excel
It’s massive in business environments. It is the lingua franca of business analysis (both back of the napkin analysis, proof of concept and more complicated/involved projects).
It is most definitely not used merely as “glorified visual data storage”.
There are probably a lot of programms that do aspects of Excel better. But the combined might you weild if you know how to use Excel is very powerful.
I tried LibreOffice and OnlyOffice and the spreadsheet part of those office suites is the roughest one until today.
But my comment was more about how much of our economy probably runs on Excel. And I experienced how badly Excel and for example LibreOffice Calc plays together, it makes switching very hard.
A complex .xlsx is far from being rendered and calculated correctly in LibreOffice.
Yeah that’s fair. Many many many of my coworkers heavily rely on excel so I can understand this. I just really don’t like using it personally. It’s like vscode too much stuff thrown at me at once when I don’t need like 99%. Just let me write a script
Genuinely what do you need in excel you can’t do anywhere else? For me sheets are just glorified visual data storage. If I need to do complex stuff I can probably do it faster in polars or pandas than I can in excel
It’s massive in business environments. It is the lingua franca of business analysis (both back of the napkin analysis, proof of concept and more complicated/involved projects).
It is most definitely not used merely as “glorified visual data storage”.
Power Query
I raise you a quick SQL query. Admittedly I’m a data engineer but I hate graphical tools that abstract code away from me.
There are probably a lot of programms that do aspects of Excel better. But the combined might you weild if you know how to use Excel is very powerful. I tried LibreOffice and OnlyOffice and the spreadsheet part of those office suites is the roughest one until today.
But my comment was more about how much of our economy probably runs on Excel. And I experienced how badly Excel and for example LibreOffice Calc plays together, it makes switching very hard. A complex .xlsx is far from being rendered and calculated correctly in LibreOffice.
Yeah that’s fair. Many many many of my coworkers heavily rely on excel so I can understand this. I just really don’t like using it personally. It’s like vscode too much stuff thrown at me at once when I don’t need like 99%. Just let me write a script