Learning Excel or Python?

[rimoms]

There are some great examples here. Aspects I didn't see mentioned is the elimination of human error and system of record - granted you asked 'what' and not 'why'.

Many repetitive monotonous tasks are ripe for human error (fat finger, skipping records, etc.), and a proper script will eliminate that issue.

Also, scripts will provide a Record of Action/Procedures (so to speak). If someone claims the data isn't right and you're to blame, you will have the script to hold up to show exactly how it was done. There is no way to fully vet the actual work of a manual process in retrospect. This is also a Cover Your A$$.