All resources related to PIVOT TABLE for Excel and Google Sheets.

How to Create a Pivot Table with VBA in Excel

We can use VBA to create a pivot table in less time by applying macro codes. In this guide, we will learn how to automate our pivot table using VBA. Figure 1- How to create a Pivot table with VBA Convert data to a table We will convert our data...

These Pivot Table Basics will Get You Started

What is a Pivot Table? A Pivot Table is a table that we can use to analyze, summarize, and calculate data that enables us to visualize trends, comparisons, and patterns in our data in a condensed manner. We can use a Pivot Table to organize a large amount of data...

How to Calculate a Subtotal in an Excel Pivot Table

We can insert subtotal amounts to a data in a PivotTable. This enables us to analyze, summarize, calculate, and visualize trends, comparisons, and patterns in our data. The steps below will walk through the process. Figure 1: How to Calculate a Subtotal in an Excel Pivot Table Setting up the...

Learn How to Create a Dynamic Pivot Table in Excel

We can create a dynamic Pivot Table in Excel by copying and pasting a new set of data directly below the data table. Afterward, we will refresh the Pivot Table to include the new data. This is better than the OFFSET function used in earlier Excel versions. The steps below...

Here is How You Can Edit a Pivot Table in Excel

We can edit a PivotTable by removing or adding columns, row, or modify the data when there are new entries. The steps below will walk through the process. Figure 1- How to Edit a Pivot Table in Excel Setting up the Data We will use the Pivot Table in figure...

How to Add Formatting to Your Pivot Table

We can format Pivot Tables in several ways like refreshing the table when we have new data, doing number formatting, and designing the Pivot Table. The steps below will walk through the process. Figure 1: Refreshed Pivot Table with New Data Setting up the data We will use the Pivot...

Learn How to Filter Large Amounts of Data in a Pivot Table

We can use the filters in our PivotTable to retrieve values that we are interested in. For instance, we can retrieve values between a certain number and another. The steps below will walk through the process. Figure 1- How to Filter Large Amounts of Data in a Pivot Table Setting...

How to Add Data to a Pivot Table in Excel

We can Add data to a PivotTable in excel with the Change data source option. “Change data source” is located in “Options” or “Analyze” depending on our version of Excel. The steps below will walk through the process of Adding Data to a Pivot Table in Excel. Figure 1- How...

Learn How to Copy a Pivot Table in Excel.

We can copy and paste a PivotTable in excel with a shortcut like CRTL+ALT+V. With this shortcut, we can prevent our source data from divulging sensitive information. The steps below will walk through the process. Figure 1- How to Copy a Pivot Table in Excel Setting up the Data We...

How to Group Pivot Table Data in Excel

We can use a PivotTable to GROUP A SET OF DATA like dates, months, years, quarters, etc. This enables us to analyze, summarize, calculate, and visualize trends, comparisons, and patterns in our data. The steps below will walk through the process of Grouping Pivot Table Data. Figure 1- How to...