I’m not one of the dual booters mentioned, but the desktop version of Excel specifically has several important features that the online version flat out doesn’t support. Primarily I’m talking about creating and running data queries, which is useful for analyzing data and generating reports from remote data sources including external files like CSV and online databases. You can do all this without Excel of course, but this shows the online versions are definitely limited.
'Twas ever so. Years ago (2012) when i was still working in an office we had web MS office to use for work…i ended up bringing in my laptop with full blown office just to get the fckn data manipulation we needed out of excel
That’s fair. I’ve dealt with that before, and in my case I had to rebuild the damn thing for compatibility with the web version. When I did, I was able to use alternatives like Power Query M instead of VBA. This worked in my case, but I’m sure you’re right that some features just aren’t there in any capacity.
The external CSV thing is a PITA but you can (at least there) overcome it via adding a “landing sheet” for raw data. Nobody is going to want to deal with any of this, though.
I’m not one of the dual booters mentioned, but the desktop version of Excel specifically has several important features that the online version flat out doesn’t support. Primarily I’m talking about creating and running data queries, which is useful for analyzing data and generating reports from remote data sources including external files like CSV and online databases. You can do all this without Excel of course, but this shows the online versions are definitely limited.
'Twas ever so. Years ago (2012) when i was still working in an office we had web MS office to use for work…i ended up bringing in my laptop with full blown office just to get the fckn data manipulation we needed out of excel
That’s fair. I’ve dealt with that before, and in my case I had to rebuild the damn thing for compatibility with the web version. When I did, I was able to use alternatives like Power Query M instead of VBA. This worked in my case, but I’m sure you’re right that some features just aren’t there in any capacity.
The external CSV thing is a PITA but you can (at least there) overcome it via adding a “landing sheet” for raw data. Nobody is going to want to deal with any of this, though.