Excel File Recovery

How to Highlight the Top or Bottom N Items by Conditional Formatting in Excel

Finding the top and bottom items in an Excel worksheet is  very ordinary in your work. And in this article, we will use the conditional formatting to quickly achieve this task. In your Excel worksheet, you will sometimes need to find the top n items or bottom n items. If those cells are not in a column or in a row, you cannot sort values. Hence, it is very difficult for you to find out all those cells manually. But in Excel, you can use the conditional formatting to finish this task. Now...

Read more »

How to Analyze Data by Using Slicer in Pivot Table in Your Excel Worksheet

Pivot table has provided many useful features for you to analyze data and information. In this article, we will talk about the usage of slicer feature in pivot table. In Excel, the pivot table is very efficient in analyzing data and information. You can also demonstrate data in the way that you need by this feature. The image below shows the sales volume in a worksheet. In order to analyze this range, we have created two pivot tables in another worksheet. In the first table, we will show...

Read more »

3 Effective Methods to Calculate Values Based on Cell Colors in Your Excel Worksheet

Different cell colors can help you identify the values in cells. When you need to calculate values based on cell colors, you can use the 3 methods in this article. In an Excel worksheet, you will certainly mark different colors for different cells. Most of the time, the same color will be in different cells in a range. The image below shows a worksheet with different cell colors. When you need to calculate the values by the cell color, you will find that it will be hard to select those...

Read more »