Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

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

          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

                Generate Random Letters in Excel

                  how to generate random letters in excel featured image

                  Ever faced a situation where you need to generate random letters? Yes, sometimes we need to generate random letters. We have functions like RAND and RANBETWEEN to generate random numbers but we don’t have any particular function to generate letters. But today, I will share with you an amazing formula trick to generate random letters in […]

                  Check it out now

                  Conditional Ranking In Excel Using Sumproduct Function

                    how use sumproduct in excel to create a rank if for conditional ranking

                    First of all, just do this for me, open your Excel workbook and try to type RANKIF. You will be wondered that there is no function in Excel for conditional ranking. Yes, there is no one. Now, just think this way, have you ever faced a situation where you have to rank values by using […]

                    Check it out now

                    How to Calculate Weighted Average With Sumproduct

                      how to calculate weighted average with sumproduct

                      The weighted mean is similar to an ordinary arithmetic mean (the most common type of average), except that instead of each of the data points contributing equally to the final average, some data points contribute more than others.

                      Check it out now