I've been tasked with finding a solution for my work's huge data management problem. Currently, we use Excel for everything, including making summary reports from huge amounts of data (bordering on 1 million rows). For context, Excel shut down on me at least 50 times today, it got old really fast!
Does anyone have any recommendations for software that I should look into purchasing? Preferably something user-friendly, that can perform calculations for lots of data and present them clearly? We also use Access for some of the larger client databases, but many of the formulas we use in Excel are too complicated for queries.
Any pointers in the right direction would be appreciated! Thanks!