Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

10000+ Copies Already Downloaded

All posts by Puneet

How To Group Dates in a Pivot Table in Excel

group dates with in pivot table in excel

When it comes to summarizing data, pivot table is everyone’s first choice. It doesn’t matter how big your data is, it has no problem to handle it. You can instantly create insightful and ready to present reports with a pivot table. And the best is, it is dynamic, flexible and powerful. Grouping dates is one […]

Check it out now

COUNTIFS and COUNTIF With OR Logic

how to use or logic with countif and countifs

Two days back I wrote about how you can use OR logic in SUMIFS and SUMIF. And today, I want to show, that you can also use the same OR logic and multiple conditions in COUNIFS and COUNIF. Even you can create dynamic criteria for OR logic in COUNIFS and COUNIF. Have you ever faced a […]

Check it out now

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

Ranks in a Pivot Table

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 other.The […]

Check it out now
1 4 5 6 7 8 25