# PIVOT TABLE Articles: Excel and Google Sheets

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

### PIVOT TABLE

Learn How to Use a Pivot Table to Find Unique Values in Excel
Excel allows us to find unique values in a Pivot table using the Distinct count option. This step by step tutorial will assist all levels of Excel users in finding unique values in a Pivot table. Figure 1. Final result Setting up Our Data for Finding Unique Values in a...
How to Sort Data in a Pivot Table
Excel allows us to sort data in a Pivot table in several ways. This step by step tutorial will assist all levels of Excel users in sorting data in a Pivot Table using standard Excel sort or Pivot sort option. Figure 1. Final result Setting up Our Data for Sorting...
How to Format the Values of Numbers in a Pivot Table
Excel uses the default format “General” for values in a cell.  This could lead to poor presentation of data especially in a pivot table where we usually deal with massive amount of data in different formats.   Below is an example of a pivot table showing three different number formats:...
Here is Why Your Next Pivot Table Should Have a Dynamic Range
We usually use pivot tables to help analyze and simplify massive amount of data.  However, it gets tricky when we add or remove values in our source table, and the pivot table doesn’t automatically update.  A dynamic range solves this problem. This step by step tutorial will walk through how...
Correcting the Source Reference not Valid Error in a Pivot Table
When working with pivot tables, we sometimes encounter the error “Data source reference is not valid”.   Figure 1.  “Data source reference is not valid” error message in Excel Most probably, the reason for the error is one or more of the following:   Excel file name contains the characters...
Working with a Calculated Field in an Excel Pivot Table
In Excel, Pivot table Calculated Fields can be added as new fields in a Pivot table. These contain values based on calculations performed on data from Pivot table field(s). Calculated Fields do not contain any data themselves, but these fields derive data based on formula calculations on Pivot table field(s)....
How to Create a Pivot Table in Excel
Pivot tables in Excel are a tool used to analyze big data sets. This tool summarizes big data sets in a user-friendly, easy to understand and meaningful report. In this article, you will learn how to create a Pivot table in Excel. A pivot table allows you to look at your...
How to Update a Pivot Table in Excel
In Excel, when we add data or make changes in the source data set, the Pivot Table does not pick up these changes automatically in the data set. We need to refresh the Pivot table manually as standard functionality in Excel to update the Pivot table results with these changes...
How to Create a Pivot Table in Google Sheets
The Google Sheets Pivot Table is an excellent feature to summarize a large set of information into a concise and meaningful report. It is a powerful tool to analyze a big dataset and display final result quickly and flexible with just a few clicks. Creating a Pivot Table in Google...
Find the Summation Over a Distinct Category in an Excel Pivot Table
Pivot tables in Excel are an excellent tool for analyzing data. They help you to aggregate, summarize, finding insights and presenting a large amount of data in just a few clicks. It is very flexible and can be changed without much effort. You can create and modify pivot tables very...
1 2 4 5 6