I have more than fifteen years of experience organizing, developing , and publishing briefings, proposals, and other documentation. These have included military operations, network design, project tracking, and decision briefs. While completing my Master's degree in Telecommunications and Network Management I authored several papers that included security plans, project proposals, and business analysis. This included advanced work with Excel utilizing pivot tables, linked formulas, and pull down lists.
For these kinds of Excel project I build a presentation file that pulls data from other files to create all of the desired charts and graphs. I include basic instructions so that you can update your data on demand after pulling it from most common data formats.
This assumes you will provide copies of the data files you are using. If you need to alter the data to protect sensitive information I can work with that.