Yep, even the most basic knowledge such as knowing how to do math on a few cells can be useful to build things. It's really good for one off internal tools to do comparisons.

For the first 5 years of selling courses I handled affiliate payouts by sorting and summing rows in a spreadsheet. It only took 5 minutes once a month. I eventually automated what I used to do manually with a script that reads the CSV file because I like coding and it was fun to me, plus I wanted to remove one point of human error.