office

At times you would need to analyze a set of numbers and find values that are greater than a given value (or a threshold), There is a simple procedure for doing the same.

A Sparkline is a small chart inside the cell of a worksheet used to provide an approximate visual representation of the data .

Sparklines are an easy way to do a quick analysis when you have huge data .

It is also very useful during presentations to show a trend of the captured data.

There are many instances where you need to highlight duplicate entries in an Excel sheet .If you have a few entries you can check manually and highlight them one by one , but if you have thousands of entries in a column (or Row) then manual checking is not a practical way of doing it .


This tip will show you an easy way to highlight duplicates in an Excel sheet .

There are many instances where you need to remove duplicate entries in an Excel sheet .If you have a few entries you can check manually one by one , but if you have thousands of entries in a column (or Row) then manual checking is not a practical way of doing it .

This tip will show you an easy way to remove duplicates in an Excel sheet .

Subscribe to office