Tag Archive: Pivot table

Articles sur le thème : Pivot table

Pivot Table – Generate multi-worksheets

Pivot Table is a great tool to split a file into multiple worksheets with a simple action. Presentation of the tutorial If you are reading this article it’s because you have a huge table and your have to split the contain in many worksheets. Methodology To make this work, we must create a pivot table. To see the method, …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/generate-multi-worksheets/

Relationship between tables


Permanent link to this article: https://www.excel-exercise.com/relation-between-tables/

Pivot Table – Presentation

A Pivot Table is a powerful tool which calculates or aggregates data very easily. For many people, a pivot table is a complex tool for advanced users. But not at all. It’s really simple and all the calculations are made by the tool itself. You just have to drag an drop your data. 😎😃😍 Before creating …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/pivot-table-presentation/