After we have created a structured table it would be nice to take some time to change its appearance. Excel has a large number of predefined styles, which allow us to change the way this table is displayed, and there are many other options that can be used to format individual parts of a structured table. Before we start to fill in the data table, let’s make it a better looking!
Once we have created a Pivot table we can change the way it looks. Depending on the settings, the Pivot tables can be distinguished, although all those formatting properties that apply to the traditional Excel tables apply to them. By changing the style and displaying individual table elements (totals, subtotals, headers of rows and columns), we can change the look of the Pivot table in accordance with the reporting needs.
When making extensive reports, there is often a need to calculate subtotals by reporting categories. Subtotals are, most of the time, sums and they might also be an average, a minimum, a maximum, a product, or a count of articles within a report. Subtotals can be made manually and in this „recipe“ it will be about how to use Excel for automatically adding subtotals.