Tag: pivot table

50. Videotutorial – Deal with Pivot Tables 10 – More tweaks

50. Videotutorial – Deal with Pivot Tables 10 – More tweaks

The last part of tutorials Deal with Pivot Tables represents tweaks that do not fit into previous episodes and it is worth to know them. Learn eg. how to fill the empty cells with zero value, to generate the detailed in-depth analysis and how to update and expand the source table. If this guide has helped you, become […]

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

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

48. Videotutorial – Deal with Pivot Tables 8 – Pivot chart

48. Videotutorial – Deal with Pivot Tables 8 – Pivot chart

Another episode of tutorials Deal with Pivot Tables continues with the creation and capabilities of PivotChart. You’ll learn a few handy tricks and you will see a pie chart of pie.  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 that this […]

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

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

46. Videotutorial – Deal with Pivot Tables 6 – Calculated field

46. Videotutorial – Deal with Pivot Tables 6 – Calculated field

Another episode of tutorials Deal with Pivot Tables continues with the topic Calculated field. Without changing the source table we will create a new column with a formula. You will learn how a field is added to the table, or to influence the source data and then update the PivotTable. If this guide has helped you, become a fan […]

45. Videotutorial – Deal with Pivot Tables 5 – Grouping

45. Videotutorial – Deal with Pivot Tables 5 – Grouping

Another episode of tutorials Deal with Pivot Tables continues with the topic Grouping of dates of intervals. You can simply view the summary according to time of year, for example total for each month or quarter. Also you can see the value in increments of thousands or in other units. If this guide has helped you, become a […]

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

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

Scroll to Top