Access works better than Excel when needing to match data from multiple sources or looking for duplicate fields.
On #9 and #10 - I will frequently atomize all of the data and load up on all of the formulas, etc. in the first sheet and then create a second sheet nicely formatted and more for display or reporting with links to the first sheet for just the columns / rows I want to show.