Excel Pivot Table Archives

Excel Top 10 List with Duplicates

Sep 20, 2021 Excel Formulas

For different purposes, you may need to find the top n number of values in Excel, n can be 5 or 10 and many more. Today we are going to show you how ...

How to Find Minimum value in Excel (Formula and Pivot Table)

Sep 20, 2021 Excel Formulas

For different circumstances, you may need to find the minimum value in Excel, you can do that easily. Today we are going to show you how to find the ...

How to Sum by Month Using SUMIF in Excel

Sep 19, 2021 Excel Formulas

Today I will be showing how you can sum data by month using SUMIF() and SUMIFS() functions in Microsoft Excel. Download Practice Workbook How to ...

How to Count the Number of Occurrences in a Date Range in Excel

Sep 19, 2021 Excel Formulas

Today I will show how you can count the number occurrences of a particular day in a range of dates and also the total number of days in a particular ...

How to Find Unique Values from Multiple Columns in Excel

Sep 19, 2021 Excel Formulas

Today I will be showing how you can extract unique values from multiple columns in Microsoft Excel. Download Practice Workbook How to Find Unique ...

Excel formula to calculate percentage of grand total (4 Easy Ways)

Sep 7, 2021 Excel Basics

In this tutorial, you will learn several methods of using Excel formula to calculate percentage of grand total. Download Excel File It will be ...

Sort Pivot Table by Values (4 Smart Ways)

Sep 8, 2021 Excel Pivot Table 3

Sometimes after making a Pivot table in Excel, the data can be seen placed in the wrong order. To sort it out, Excel has many different sorting ...

Create a report that displays the quarterly sales by territory

Sep 7, 2021 Advanced Excel 10

In this article, I will create a report that displays the quarterly sales by territory. You can call it also a dynamic and interactive Excel ...

How to Remove Pivot Table but Keep Data (Step-by-Step Guide)

Sep 7, 2021 Excel Pivot Table 5

In this article, I will show you how to remove the pivot table but keep the pivot table data. The pivot table is very important when we want to ...

How to Use Pivot Table Data in Excel Formulas

Apr 25, 2021 Excel Pivot Table

In this article, I will show you how you can use Pivot Table data in Excel formulas. No data analyst can think a day without using Pivot Table in ...

How to Create Pivot Tables for Meaningful Data Analysis!

Sep 12, 2021 Data Analysis with Excel

Pivot Tables allow you to summarize and organize data quickly and efficiently, in order to identify patterns, trends, and other key insights. One can ...

Excel Pivot Table Calculated Field (How to Insert & Edit)

Sep 12, 2021 Excel Pivot Table

When you are using Pivot Tables, you can use calculated fields as a way of making your own custom calculations. In this article, we shall learn ...

How to Import Data into PowerPivot & Create Pivot Table/Pivot Chart

Apr 7, 2021 Data Analysis with Excel

Pivot table is useful when we want to analyze or slice data to gain important insights. It is the main way to analyze data. But it also has ...

Reverse Pivot Tables – Unpivot Summary Data

Sep 9, 2021 Excel Pivot Table

Excel pivot tables are beautiful! Then why do you need to reverse your pivot tables or pivoted data? Because data generated by businesses are ...

Excel Pivot Table Tutorials for Dummies Step by Step | Download PDF

Sep 9, 2021 Excel Pivot Table 33

Excel Pivot Table! The most important feature added to the toolbox of Microsoft Excel, ever! A serious data analyst cannot think of passing a ...