Excel Productivity Guide

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

Category Archives for Formulas

Get First and Last Word

    get first and last word from a text string

    Often we face a situation where we need to get first and last word from a cell in excel. For example, if you want to extract the first name from a cell where you have both first and last names or if you want to extract product name from the product description cell. But in […]

    Check it out now

    Use Wildcards with VLOOKUP

      how to use wildcards with vlookup in excel

      Using wildcards with VLOOKUP can be super useful for you. It can help you to look up for a value using a partial match. Let’s say you have data like below table where you have students full name in one column and their marks in another column. Now from this data, you want to lookup […]

      Check it out now

      Count Unique Values in Excel

        Let’s say you have a list of values where each value is entered more than once. And now, you want to count unique values from that list so that you can get the actual numbers of values which are there in the list. For this, you need to use a method which will count a […]

        Check it out now

        Sum Values Between Two Dates

          how to sum values between two dates in excel

          Let’s say, you are working in a trading company and your boss tells you to get the total sales amount for last 15 days. In this case, you need to sum sales amount from the current date to 15 days prior. Here, you have a range of dates which actually includes total 15 dates and […]

          Check it out now

          Get Last Day of a Month

            how to get last day of a month

            Sometimes you need to use the last day of a month in a calculation as a completion date, due date, or as a target date. You can easily add a month’s last date manually but there are some formulas which can help you calculate it. And, the best way to calculate it by using EOMONTH […]

            Check it out now

            Get Month from a Date

              how to get month from a date in excel

              Dates are an important part of data. It can help you to capture your data in a better way and it’s easy to use dates in further analysis. And, the best part is you can also modify dates as well and use them in your own way. Normal dates, when you are working in excel […]

              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 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