How to Calculate Compound Interest in Excel

Compound interest is one of the most important financial calculations which most of us often do in our work.And, it’s must to learn to calculate it in Excel.But, before you do that you need to understand what actually compound interest is.Investopedia says:Compound interest is interest calculated on the initial principal and also on the accumulated […]

➲ Continue Reading

Dynamic Chart Range in Excel

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 is […]

➲ Continue Reading

How to Use Wildcard Characters in Excel

Sometimes working with data is not that easy, sometimes we face complex problems.Let say, you want to search for the text “Delhi” from the data. But, in that data, you have word “New Delhi” not of “Delhi”.Now, in this situation, you can’t match or search.Here, you need a way which allows you to use only […]

➲ Continue Reading

In Cell Bar Chart With REPT Function

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 decent bar chart with REPT […]

➲ Continue Reading

How Combine IF and AND Functions in Excel

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 […]

➲ Continue Reading