47. Videotutorial – Deal with Pivot Tables 7 – Filters, Slicers, Timelines

Another episode of tutorials Deal with Pivot Tables continues with the topic Filters, Slicers and Timelines. You will see how to filter simple conditions, find top values and especially use Slicers and Timelines to find what you are looking for. You can even filter in multiple Pivot Tables at once. If this guide has helped you, become a fan […]

Camera Tool

Do you need in Excel at some point to see what is in another table? To have a live picture of the data from another area, you can use the Camera tool which can achieve this. Check the instructions to set up this simple helper. If this guide has helped you, become a fan on Facebook and […]

Format time over 24 hours

In tables working with time values is sometimes necessary to calculate a period longer than 24 hours. If the result is not format correctly, you will not get the desired value, because by default, Excel does not calculate the time exceeding 24 hours. But just change the custom cell format and the correct number appears. See […]