4 ms·
Tell me you don't scratch the surface of what Excel is capable of without saying it directly. Use PowerQuery and PowerPivot for a few months and then try to go
by cykros 3y ago
Tell me you don't scratch the surface of what Excel is capable of without saying it directly.
Use PowerQuery and PowerPivot for a few months and then try to go to Google Sheets, LibreOffice, Gnumeric, or any of the other supposed replacements.
It's like comparing the Gimp to Photoshop, except that I might be being unfair to the Gimp in this situation.
- macshaggy 3y agoAgreed. I'm a Data Analyst and as much as I use numpy/pandas/matplotlib for a lot of my work. When it comes to sharing the data that my work is based on I usually need to export it to Excel with the calculations. There is just a need to use the more complex features to do things and that can also show how changing a variable affects the overall analysis. I can't give people a python script or jupyter notebook and tell them to do x or y or z. I can recreate all my calculations in excel, using python, with the same graphs and visuals, and give them instructions on what cells relate to what variables that affect the analysis so they can experiment for themselves. With Google sheets, LibreOffice, etc., I haven't seen that kind of functionality.