4 Quick Methods for Deleting Spaces in Excel

how to delete extra spaces in excel

A clean data is our birthright. But sometimes, we are not able to access it. Sometimes, we are not able to use our data as the way we want to use it. And, the one biggest reason which makes our data unable to use is unwanted spaces in a cell. So, if you want to […]

Check it out now

SUMIFS and SUMIF with an OR Logic

how to use or logic in sumifs sumif in excel

Today, you will learn a simple trick to increase the power of SUMIF and SUMIFS. In SUMIFS, you can use more than one criteria to get a sum and in SUMIF you can only use one criterion. Let’s say, in SUMIFS, if you specify two different criteria, it will sum only those cells which meet […]

Check it out now

How To Add Ranks in a Pivot Table in Excel

how to add ranks in a pivot table in excel featured image

By using a pivot table, you can summarize your data in an understandable manner. And, that summary can help you to analyze data on category wise, product wise, month wise, etc. One of the common practices for analyzing data is by ranking them. Ranking categories and products can help you to compare them with each […]

Check it out now

How To Calculate Ratio in Excel

how to calculate ratio in excel

Ratio calculation is one of the common methods to compare two values with each other. It can help you to compare variation between those two values. Even in our daily life, we use this word RATIO to define the comparison between two different things. Now, when you come to Excel, you don’t have any specific […]

Check it out now

7+1 Amazing Things You Can Do with Excel Filters

amazing things you can do with excel filters

Using a filter in excel is not a #rocketscience. Everyone out there knows that they can do a lot of things with filter option. But, the bad news is they are not actually using it to the best or maybe they forget to make a habit to use it. And, the good news is you […]

Check it out now