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 […]
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 […]
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 […]
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 […]
The video series Deal with Pivot Tables continues with episode Design tab. In this tutorial you will learn how to change the design, report layout and subtotals visibility in Pivot Table. 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 […]
The video series Deal with Pivot Tables continues with episode Calculation options. In this tutorial you will learn how to change the aggregate function in calculations, how to set up percentage totals and how to display more summaries at once. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can […]
The video series Deal with Pivot Tables starts with a tutorial Basic model. You will learn how to create a simple Pivot table in Excel. 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 tutorial is presented in czech […]
