How to Create a Step Chart in Excel
A step chart is a perfect chart……if you want to show the changes…happened at irregular intervals.And that’s why it’s a part our advanced charts list.It can help you to present
Puneet
How to Get Month from a Date in Excel
Dates are an important part of data. There are few times when we need to use only a part from a date. Take an example of the month. Sometimes you only need
How to use OR Logic in COUNTIF/COUNIFS in Excel
How to use OR Logic in COUNTIF/COUNIFS in Excel A few days back I wrote about how we can use SUMIF OR. And today, I want to show that by
How to Remove 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. And one of
How to use SUMIF / SUMIFS with an OR Logic in Excel
Sometimes we need to make small amendments in formulas to make them effective. Just like that, SUMIF OR. It’s an advanced formula which helps you to increase the flexibility of SUMIF.Yes, you
How to Add Ranks in Pivot Tables in Excel
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