It is odd that you should use Excel for gathering data and sorting as Access beats it hands down for both and for filtering and long term analysis like year over year etc.
It can reproduce Excel maths, but it takes quite a bit of effort for more complicated stuff.
Access Graphs are not easy.
I used both when I worked, Access to gather, sort & filter and Excel for display purposes like graphs, especially as Excel links well with Queries.
Excel is good for input when there is less data and is much quicker to set up for it.
Do you use Forms in Excel?