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

                    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
                      1 2 3 12