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 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 just a tool to aggregate your data. It’s really simple and all the calculation are made by the tool. You, you just have …

Continue reading

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