PIVOT TABLE Articles: Excel and Google Sheets

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...

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...

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:...

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...

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...

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)....

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...

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...

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...

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...