Python's pandas makes working with large numbers of Excel / LibreOfficeCalc files a lot easier. Excel is very convenient for the non-programming user of course, for example making graphic visualization is far easier. With pandas you need to interface programmatically with matplotlib or similar.

If you want to up your skills in this area, Wes McKinney's "Python for Data Analysis" is pretty great.