Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.

This is the demonstration file to accompany the article, How to display multiple grand total rows in a Microsoft Excel PivotTable by Susan Harkins.

How to create a Pivot Table in Excel First of all, you would need a set of data arranged across rows and columns. Eg. The lists of marks scored by students in various subjects.

Excel allows you to rename columns, adjust design elements like colors and banded rows, and manage grand totals to fit your specific needs.

In conclusion, creating a consolidated PivotTable in Excel using data from multiple sources is a powerful way to analyze and visualize complex datasets.