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

44. Videotutorial – Deal with Pivot Tables 4 – Page field

Another episode of tutorials Deal with Pivot Tables continues with the topic Page field. It serves not only for filtering, this can produce several detailed Pivot tables according to the selected criteria. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too. Please note […]