Excel - sample pipeline report showing total/weighted pipeline

I want to test some sample reporting using Excel. I have a sample file with 320 rows of data that I'd like to show total and weighted pipeline, sales, stage, expected close date by quarter and a chart to represent pipeline growth and close dates.

I imagine a first sheet showing an exec summary, a second sheet showing more detail and a 3rd sheet showing the graph(s).

I'm aware this should be a simple project for someone with Excel skills, but it's beyond my own skillset.