How To Calculate Compound Interest In Excel

    how to calculate compound interest in excel featured image

    Today, I will show you how to calculate compound interest in excel. Compound interest is one of the most important financial calculations. And, you can calculate it on a yearly, quarterly, monthly, and daily basis. In this post, you will learn all these methods. End of this post, you can download a simple template to calculate […]

    Check it out now

    How To Create a Dynamic Chart Range in Excel

      how to create a dynamic chart range in excel featured image

      I have a strong reason for you to use a dynamic chart range. It happens sometimes that you create a chart and at the time when you update it, you have to change its range manually. Even when you delete some data, you have to change its range. Maybe it looks like that changing a chart range […]

      Check it out now

      How To Use Wildcard Characters in Excel [Ultimate Guide]

        how to use wildcard character in excel featured image

        Do you use wildcard characters in excel? They are life savers. Wildcard characters are all about searching a text with a partial match. Let’s say you have a list of names & you want to search for the names who are starting with “T” and ending with “I”. You can use a question mark (?) to […]

        Check it out now

        How To Create In Cell Bar Chart With REPT Function

          how to create an bar chart with rept function featured image

          In-cell charts are awesome. And today, I’ll show you how to create an in-cell bar chart with rept function. But, do they really worth your time? Yes. Here is the single important reason. They are easy to create and simple to use. Ahead, in this post, I’ll show a step by step process to create a […]

          Check it out now

          How Combine IF and AND Functions in Excel

            how to combine if and and functions featured image

            As I told you, by combining IF with other functions you can increase its powers. AND function is one of the most useful functions to combine with IF function. Like you combine IF and OR functions to test multiple conditions. In the same way, you can combine IF and AND functions. There is a slight difference in using […]

            Check it out now

            How To Create Dynamic Chart Title In Excel

              Dynamic Chart Title In Excel

              Dynamic charts are awesome. But, do you know what is the most important part of a dynamic chart? “Dynamic Chart Title”. Yes, dynamic chart title. Creating dynamic chart title in excel is one of the best ways to make your charts interactive. It will help you to show what actually your chart is about. Ahead in […]

              Check it out now

              How To Combine IF and OR Functions in Excel

                how to combine if and or functions featured image

                IF Function is one of the most powerful functions in excel. And, the best part is, you can combine other functions with IF to increase its power. Combining IF and OR functions is one the most useful formula combination in excel. In this post, I’ll show you why we need to combine IF and OR functions. And, […]

                Check it out now

                How To Use R1C1 Reference Style In Excel [Proper Guide]

                  Do you know R1C1 Reference Style in excel is one of the unused features? Most of the excel users don’t even know about the existence of R1C1 reference style. But, some super users love to use it. They found it more convenient than a1 reference style. This post will help you to master R1C1 reference style. And, also […]

                  Check it out now

                  How To Quickly Create a Bullet Chart In Excel

                    how to create a bullet chart in excel step by step guide featured image

                    If you are struggling while selecting a chart for a single data point, you can use a bullet chart. Or, if you don’t like using gauge chart, you can replace it will a bullet chart. So today, I’ll show you a step by step process to create a bullet chart in excel. Along with that, I’ll […]

                    Check it out now

                    10 Excel Charting Tips You Are Still Not Using

                      10 charting tips in excel you are not using featured image

                      The moment you are reading this post you still have to explore a lot of things about excel charts unless you are “Jon Peltier“. Here in this post, I’ll show you 10 charting tips which you can instantly use while creating your next chart. I’m pretty sure that these charting tips will help you to […]

                      Check it out now
                      1 3 4 5 6 7 12