Remove Duplicates from the Pivot Table
When we talk about Pivot Tables in Excel, we usually discuss all of the good things that they bring to our lives. So…
Category: examples
Extract Unique Values From Multiple Columns In Excel
There are so many ways in which we can manipulate our data in Excel. One of the things that could be troublesome for…
Create Pivot and Chart Slicers in Excel
Pivot Tables are great to manipulate large amounts of data and creating reports for various stakeholders. They filter our data. We can all…
Create a Title in Excel
Just like in Word, Excel has several options to make the title. Of course, Excel is not meant to be representative of these…
Create Pivot Chart from the Pivot Table
Once you know how to create and manipulate the data in the Excel Pivot Table, it is quite easy and self-exploratory to create…
Combine Multiple Excel Worksheets into One
Many Excel users have found themselves wondering how could they possibly combine multiple sheets into one without going into too much trouble. The…
Format Cell Based on a Different Cell in Excel
In Excel, there are limitless opportunities to format our data. One of the cool things that it is possible to do is to…
Show Text in Pivot Values Area in Excel
Although you probably never taught about it, there is an option to show the text in the Pivot Values area. Read on to…
Remove Time from Date and Time in Excel
When using Excel, we will often find ourselves in a situation where we have to manipulate data. More often than not, these data…
Conditional Formatting in Excel
We already explained where the Conditional Formatting is located in Excel, and that it can be used to highlight cells or a range…