Can Excel be used as a database reporting tool?
I've got a bunch of tables, some of which need to connect to each other when I make a report.
However, I don't know how to do it in Excel.
Is Access a better and recommended approach?
I know there are pivot tables, but I need to make complicated filters and sums first. Is there a way to do this in Excel?