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

Create Interactive Charts In Excel

A chart is a perfect tool to present data in an understandable way.But sometimes it sucks because we overload it with data.I believe that when it comes to charting it should be neat and clean. The best solution to this problem is using interactive charts.By using interactive charts in Excel, you can present more data […]

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