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

Convert Formula to a Static Value

    From the starting days of my job, I have learned one thing hard way that before sending a report to someone we must convert all the formulas into values.I have faced this problem so many times that after sending a file to someone, he/she made a change (mistakenly) into it and then they say, “there […]

    Check it out now

    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

              Create a Step Chart in Excel

                how to create a step chart in excel

                A step chart is perfect to use when you want to show the changes happened on irregular intervals. It can help you to present the trend as well as the actual time of a change. In real, a step chart is an extended version of a line chart. Unlike line chart, it doesn’t connect data […]

                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

                  Excel’s AUTO FORMAT Option

                    how to use excel auto format option for quick formatting

                    Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone. But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]

                    Check it out now

                    Dynamic Drop Down List

                      quickly create a dynamic drop down list in excel featured image

                      Drop down list is a powerful tool. It can help you to make your data entry simple and quick. You can use a drop down list with your dashboards, charts or even with normal data. While using it, one thing always gave me nuts that you need to update it’s data source whenever you add a […]

                      Check it out now
                      1 2 3 12