What is one of the most important tool of Excel for you? I personally think that Pivot Tables should be the one… Is a great reporting tool for your needs and easy to use. Take the advantage of this to optimize your reports only with a few steps. You can summarize your data as you want… Sum, count, sort, average… The results are displayed in seconds.
Lose a little time to learn more about Pivot Tables and you see that you will not regret.