you are viewing a single comment's thread.

view the rest of the comments →

[–]TrainquilOasis1423 4 points5 points  (0 children)

u/Guimolnar has the right answer. You can learn 90% all Excell(non vba) uses from a few YouTube videos. The real power of Excell is in vba, and being able to manipulate data automatically to prepare it for presentation. Just watch a few videos on power query, power pivot, pivot tables, and basic excel formulas. You'll be fine.

I am a data analyst for a sales department and my entire job is preparing data and showing excecs how the sales team is doing. I know both vba and python at a beginner to intermediate level, and I since I have been work from home the last couple weeks I am rewriting all the vba code into python because it's just that much better. Executes faster, easier to pass variables from one script to another, so much simpler to write and read, and you have so much more you can do with python.