How To Highlight Top-Bottom N Values In Excel

how to highlight top bottom n values in excel featured chart

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

Check it out now

How To Perform Two Way Lookup In Excel

how to perform two way lookup in excel featured image

Performing a two way lookup is all about getting a value from a two-dimensional table. That means you can get a value from any cell of a table. And for this, you need to combine match function with vlookup. As you know, normal vlookup is only able to return a value by looking into a single […]

Check it out now

An Advance Guide To Use Find and Replace In Excel

how to use find and replace in excel advance option featured image

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

Check it out now

How To Create Interactive Charts In Excel

how to create an interactive chart in excel featured image

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 & clean. The best solution to this problem is using interactive charts in excel. By using interactive charts in excel […]

Check it out now

How To Calculate Compound Interest In Excel

how to calculate compound interest in excel featured image

Today, I will show you how to calculate compound interest in excel. Compound interest is one of the most important financial calculations. And, you can calculate it on a yearly, quarterly, monthly, and daily basis. In this post, you will learn all these methods. End of this post, you can download a simple template to calculate […]

Check it out now
1 7 8 9 10 11 24