Creating a pivot table with Excel - here's how

A pivot table contains the most important values that you really care about. The original table can have several thousand rows and columns, and is combined into a pivot table at the end. A pivot table can also be created in Microsoft Excel.

How to create a pivot table with Excel

To create a pivot table in Excel, you first need a base table that labels each column with a meaningful heading.

1. Select the table and click "Format as Table" at the top of the bar. This option is located in the "Home" tab. Choose a design that appeals to you.
2. If you have set headings for your columns, you can simply click "OK" in the window that opens. Otherwise, you need to uncheck "Table has headings".
3. Next, select a cell outside the table and click "Pivot Table" in the "Insert" tab at the top.
4. In the configuration window, specify your table under "Table/Range". To do this, simply select it. Thus, you have already created an empty pivot table.
5. In the next settings, you need to select the base value. To do this, simply select the appropriate label.
6. Now you still specify which values are dependent on the base value and which values depend on the values that are dependent on the base value.
7. With the filter settings, you can keep various rows hidden. To do this, select the appropriate row and right-click on it. Now select "Filter" and "Hide selected elements".

If you want to calculate more values, the Excel formula collection can help you.