Excel Pivot Table Archives

How to Show Zero Values in Excel Pivot Table: 2 Pro Tips

Dec 28, 2021 Excel Pivot Table

If you have blank cells in your dataset, they will also be represented as blank in your pivot table. To show zero in lieu of blank values in the ...

How to Hide Zero Values in Excel Pivot Table (3 Easy Methods)

Dec 26, 2021 Excel Basics

Pivot table is one of the essential tools of Microsoft Excel. If you have worked with that, you might know that. It gives us a detailed view and ...

Convert Range to Table in Excel (5 Easy Methods)

Jan 7, 2022 Excel Basics

In Excel worksheets, we have to organize, maintain, and analyze data every now and then. In this article, we describe the methods to convert any data ...

How to Count Unique Values in Excel Using Pivot Table

Nov 9, 2021 Excel Formulas

In Excel, we need to perform various count operations, i.g. count text cells, count unique, counting duplicates, and many more. Today we are going to ...

How to Remove External Links in Excel

Dec 19, 2021 Advanced Excel

While working with big projects in Excel, we often have to enter links from external sources to various points in our workbook. To reduce complexity, ...

Excel Top 10 List with Duplicates (2 Ways)

Dec 9, 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)

Dec 23, 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 SUMIF by Month in Excel (With Alternative Options)

Nov 4, 2021 Excel Formulas 1

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 Count Date Occurrences in Excel

Jan 9, 2022 Excel Formulas

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

How to Find Unique Values from Multiple Columns in Excel

Nov 4, 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 ...

How to Calculate Cumulative Percentage in Excel (6 Easy Methods)

Nov 4, 2021 Excel Basics

Microsoft Excel provides numerous methods & functions to calculate the cumulative percentage. Instead of determining these cumulative percentages ...

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

Oct 3, 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 ...