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

➲ Continue Reading

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

➲ Continue Reading

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

➲ Continue Reading

MAX IF Formula

Ever tried to look up for the maximum value from a range using a specific condition? Which formula do you think you can use?You might be wondering:Well, in excel, we can’t simply use default max function in excel with a condition (unless you are using office 365).But, you can combine MAX and IF to create a […]

➲ Continue Reading

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

➲ Continue Reading