One of the most useful features in Excel is a "dashboard"
By changing data in a file, you can have many elements such as charts updated at the one time.
This is particularly handy for analysis, trends etc. and with the use of "slicers", it is a simple matter to filter information so you can see just what you need to see.
The dashboard would normally be the first sheet in the Excel file.
A full explanation and demonstration can be found on our YouTube channel. Click the graphic below to be taken to the lesson: