top of page

PIVOT TABLE

The Pivot Table is an excellent feature in Excel that facilitates data summarization and analysis. It allows us to conveniently perform calculations on our data using specific criteria. Examples include calculating Sales per Store, Sales per Year, Average Discount per Region, and various other possibilities.

Here are several benefits of utilizing Pivot Tables:

  1. Eliminates the need for using formulas to conduct calculations.

  2. Enables us to perform complex calculations swiftly and effortlessly.

  3. The summarized data remains dynamic, allowing easy application to different data sets.

CREATE A PIVOT TABLE

To generate a fresh Pivot Table, we follow these steps:

  1. Choose the data range we want to analyze and select one of its cells.

  2. Navigate to the Insert tab and click on the Pivot Table option.

  3. Verify that the chosen range is correct.

  4. Finally, select either "New Worksheet" to create the Pivot Table on a new worksheet or "Existing Worksheet" to position it within an already existing worksheet.

Screen Shot 2023-07-11 at 12.59.34 PM.png
Screen Shot 2023-07-11 at 12.59.49 PM.png
Screen Shot 2023-07-11 at 1.00.01 PM.png

After creating our Pivot Table, we can employ the following steps for arranging the fields:

  1. Rows - Select the field/s that will determine the rows in our Pivot Table.

  2. Columns - Choose the field/s that will define the columns in our Pivot Table.

  3. Filters - Select the field/s that will be used to filter the data within the Pivot Table. For example, we can choose "Year" to filter the data based on a specific year.

  4. Values - Choose the field that Excel will calculate and specify the desired calculation to be performed.

Screen Shot 2023-07-11 at 1.04.37 PM.png

Now let's see how to create a Pivot Table with the following exercise:
Generate a Pivot Table using the provided data and utilize the internal filters to examine the average prices of holidays categorized by a Travel Method of Plane and a Resort Name starting with the letter S.
To validate the total count of holidays, employ the drill-down functionality, confirming that there are three holidays in total.

bottom of page