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

## 43. Videotutorial – Deal with Pivot Tables 3 – Design tab

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

## 42. Videotutorial – Deal with Pivot Tables 2 – Calculation options

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

## 41. Videotutorial – Deal with Pivot Tables 1 – Basic model

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

## Table transpose

Do you have wrong direction of a table and you do not want to rewrite the cells from a column in a row? Use a simple trick and Excel will do all that is necessary. Read in this manual, what… Read more

## 15 tricks with doubleclick in Excel

How many tasks in Excel can be performed with double click? You may be surprised to learn that there are 15! Check out this guide and use tricks in practice. If this guide has helped you, become a fan on Facebook… Read more

## Functions for rounding

For calculations in Excel can be often assumed difference between the format of the result and the real value rounded. In this tutorial you will learn how solve this problem and learn practical function to correct round. If this guide has helped you,… Read more