How To Highlight Top-Bottom N Values In Excel

The best way to highlight top bottom values is by using conditional formatting. It’s quick, simple and all you need a few clicks. But, the best part is, you don’t even have to write a formula for this. I have been using this since I have got my first job. Whenever my boss called me with […]

How To Perform Two Way Lookup In Excel

 It happens sometimes when we need to lookup for a value from a table according to the row heading and column heading.Let say, if you need to get the values from above table for a particular month and zone.  Here in this situation you can use a two way lookup. Performing a two-way lookup is all about […]

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