49. Videotutorial – Deal with Pivot Tables 9 – Multiple consolidation ranges

Another episode of tutorials Deal with Pivot Tables continues with the topic how to consolidate multiple source table into one Pivot. It can be achieved using PivotTable and PivotChart wizard, which remained in Excel from older versions. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for […]

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 […]