Structured tables

All the tables we make have some structure. However, in order to connect with external data sources, Excel requires the structure of the table to be strictly formal. The structured table (Table) represents the named range with a clearly defined header and an applied autofilter. In addition to facilitating connection with other data sources, structured tables allow easy addition of new columns and formulas based on their names …

Calculating subtotals

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.