## Applications of UNIQUE Function in Excel

In the previous blog, we used the UNIQUE Function of Excel to understand the basic functionality of the UNIQUE Function. In this blog, we will… Read Article

## UNIQUE Function in Excel – Usage with Examples

UNIQUE Function in Excel is a quite easy-to-use function and is one of the useful Dynamic Array Functions. The usage of the UNIQUE Function is… Read Article

## SORT Function in Excel – Usage with Examples

There can be a number of ways to sort the data in excel. We can do it either by using Excel sorting features or we… Read Article

## Dynamic Array Formulas in Excel – Usage, Example, #SPILL

Dynamic Array Formulas are real game changers when one knows how to use them! They are compatible with Microsoft Excel 365 and Excel 2022 versions.… Read Article

## Making Calculated Field in Pivot Table in Excel

In the earlier blogs, we did the usage of Pivot Tables in Excel. In pivot Tables, we can add the pivot fields ( Columns )… Read Article

## Text and Number Filter in Pivot Table in Excel

There are a number of ways to filter the data in a pivot table. In the previous blog, we learned how to filter the pivot… Read Article

## Link Multiple Pivot Tables to One Slicer in Excel

In the previous blogs, we have learned to create pivot tables and how we can add single and multiple slicers to one pivot table. Slicers… Read Article

## Slicers with Pivot Table – Multiple Slicers

There are several ways to filter our data in the pivot table. Since pivot tables use the simplest drag and drop field method, slicers are… Read Article

## How to Sort Pivot Table Manually?

In the previous blog, we learned how to sort the pivot table data in ascending order, descending order, and alphabetically. This blog will learn how… Read Article

## Sort Data in Pivot Table – Fields, Rows, and Sub Totals

Sorting our data plays a very important role in easily getting the correct order of things, maximum and minimum results and we can even sort… Read Article

## Group Data in Pivot Table – Dates, Numbers, Text

Grouping the Data items in the pivot table help us quickly reach conclusions without going into a deep study. We can define ranges for numbers,… Read Article

## Making Pivot Table from Scratch – Blank Pivot Table

In the previous blog, we learned the Fundamentals of Pivot tables and how to make recommended pivot tables as per our data set. In this… Read Article