Microsoft Excel allows for reporting and presenting of different kinds of company information easily and hassle free.

For example, management would like us to generate a report detailing the top 10 sales periods, or we need to know which are the 10 most populous states in the United States.

We can do simply by following a few simple steps:

Step 1:

Select the information to be included

Step 2:

From Styles we select the option Conditional Formatting

Paso 3:

From Drop down menu, click on the option Top/Bottom Rules and then click on Top 10 items

Step 4:

From the Top 10 Items window that comes up, we can choose the format with which we wish to highlight the values on out top 10 list.

Having finalized these steps, the top 10 items will be formatted according to the chosen format.

0 Comments