Advanced Find & Replace Tips
Everyone know that we can find and replace a text with find and replace option. But very few people know that you can use this option to an advance level. Do you? If not, then after reading this post you’ll love this tool. In this post, you will learn some useful examples to use find […]
How to use MAX IF Formula in Excel + [Multiple Criteria]
In Excel, we can’t simply use default MAX function with a condition (unless you are using Microsoft Office 365). If you ever try to get maximum value from a range using a specific condition you must need a MAX IF formula. Well, you can combine MAX and IF to create a formula which can help you to […]
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 […]
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 […]
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 […]
