Excel is not perfect but it is best in class. I've built and maintained a time-series statistics research database for one of the largest trade associations in the world for over 10 years which heavily integrates with Excel. In so doing I've become intimately familiar with its quarks and shortcomings but ultimately it always provides a path to accomplish your goals, including high-performance automation https://msdn.microsoft.com/EN-US/library/office/bb687829.asp...