> I find with excel it takes just as much time to set up a spreadsheet to do what I want as it takes for me to do the same in R, usually a lot more time with Excel.

I mean, this is I reach for Pandas over Excel, but most people would be infinitely more comfortable with spreadsheets than specialized tools. Spreadsheets also happen to be useful enough for almost everybody.