Hands up all those who don't like tips and tricks !! Hmmmm...I don't see any ! Here are 20 of the best....,
1 Comment
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: |
Navigate the blog easily with the Category menu below
Choose a Category
All
Archives
July 2019
|