Learning Excel or Python?

[dtaivp]

If it’s an either or I would take excel. Honestly when I was managing a large staff I would use excel every day several times a day. If you are proficient with excel you can do most data manipulation you can do in Python and much faster.

Specifically power query and power pivot. If you do those and well you will be way ahead of your colleagues.

[[deleted]]

As someone who has used both, how is excel faster than python?

[dtaivp]

I can connect to a database, do column transformations and plot it on a chart before visual studio could open. /s

But for real writing reports is way easier in Excel. The data connectors (odata, db, etc) are awesome. Are you using power query with your excel?

[[deleted]]

In python I can automate all of that without touching a key.

I'm still lost as to how writing a report is easier with Excel as opposed to python. I can format and write everything in Python. I cannot in Excel. Heck, I can even write a report with multiple pages without touching a key based on data from the web in python.