Excel Solutions

3 Effective Methods to Get the Path of the Current Excel Workbook

When you are working on an Excel workbook, you may need to refer to the path of this file. In this article, we will show you 3 methods to get the path. Getting the path of the current workbook seems to be very easy. However, if you close the folder and couldn’t remember the exact location, you will find it hard to get the path especially, especially when there are many files in your computer. You can certainly use the search feature in your computer. But if there are many files in your...

Read more »

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 »