Hands up all those who don't like tips and tricks !!
Hmmmm...I don't see any !
Here are 20 of the best....,
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: