## 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… Read more

## 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… Read more

## 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… Read more

## 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… Read more

## Hidden function DATEDIF

You may know that Excel can subtract from each other not only numbers, but also dates. The fundamental difference between the two dates will be the number of days between them. But if we want to determine the precise number… Read more

## 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… Read more

## 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… Read more