PIVOT TABLE Articles: Excel and Google Sheets

We can use the Pivot Table Wizard to create a Pivot Table. The Pivot Table helps us to analyze, summarize and calculate data that enables us to visualize trends, comparisons, and patterns in our data. The steps below will walk through the process of using the Pivot Table Wizard. Figure...

We can use a variety of ways to Sort our data in a PivotTable. This helps us to analyze, summarize and calculate data based on priority. It also enables us to visualize trends, comparisons, and patterns in our data. The steps below will walk through the process. Figure 1- How...

We can create different charts from a Pivot Table by using the Charts feature in excel. We can also format these charts by clicking on the created charts and use the formatting handles beside it. This enables us to visualize trends and make comparisons in our data. The steps below...

We can count values in a PivotTable by using the value field settings. This enables us to have a valid representation of what we have in our data. For instance, in the example below, there is a count of 16 for clients when distinctly, they are only 4. The steps...

What is a Pivot Table? A Pivot Table is a table that we can use for analyzing, summarizing, and calculating data that enables us to visualize trends, comparisons, and patterns in our data in a condensed manner. A Pivot Table is useful for organizing a large amount of data in...

We can use a PivotTable to analyze, summarize and calculate data that enables us to visualize trends, comparisons, and patterns in our data. The steps below will walk through the process of Inserting a Pivot Table in Excel. Figure 1- How to Insert a Pivot Table in Excel Setting up...

After creating a Pivot Table, we can change the range of the Pivot table Source data (the origin of the data). We can also select the range and expand the source data to include more rows or reduce the rows. The steps below will walk through the process. Figure 1:...

When we consistently deal with the same Pivot Table format, we can use Macros to record that exact format so that we can create and edit our Pivot Tables in a lesser time. In simple illustrative steps, we will work through the ways a macro can be helpful in creating...

We can customize our pivot table dates to be displayed in different ways. In simple steps, we will explore how to sort, filter, group and format our pivot table dates easily. Figure 1 – Example of how to deal with pivot dates Setting up the Data We will set up our...

We may have blank cells in our Pivot table from time to time. In this tutorial, we will explore how we will deal with pivot table blanks. Figure 1 – Showing zero in pivot blank cells Setting up the Data First, we will create our sample worksheet Next, Column A,...