| Included within most high end Private Equity Directory | | | | the PE firms within the resource by location this |
| resources, are thousands of details included about | | | | would be impossible without this function. However, it |
| the firms and key personnel. While these directories | | | | only takes four easy clicks to rearrange the 20,000 |
| are invaluable, navigating within in them can be | | | | cells within the resource. |
| difficult when trying to research within the resource. | | | | Begin by clicking the column you would like sort; in |
| This article seeks to alleviate some of these | | | | this example we are using the location. With the |
| problems and offer potential solutions and time saving | | | | location highlighted, next click the data tab. In the |
| techniques. | | | | middle of the data tab is an icon which shows AZ or |
| For this article, I will describe some problem solving | | | | ZA with corresponding arrows. By clicking on either |
| and time saving techniques to employ within a | | | | one of these options, you are able to sort the |
| Microsoft Excel based PE firm listing resource. | | | | locations in alphabetical order or in reverse order. |
| Research: Within most excel based resources are | | | | Important: Make absolutely sure that you choose the |
| over 15,000 to 20,000 individual cells of data. | | | | option "expand to entire selection" when prompted. |
| Researching within each of these directories is often | | | | If you do not choose this option the excel program |
| overwhelming unless you have specific search criteria | | | | will then only sort the data in that column only |
| in mind. | | | | instead of sorting the entire information for each of |
| Sorting: This is a very valuable and helpful tool within | | | | the PE firm listings. |
| the Microsoft Excel program which will allow you to | | | | In conclusion, the importance of this technique is that |
| rearrange the information which is contained within | | | | it can be used in a variety of different ways to allow |
| the directory. For example, if you wanted to arrange | | | | you to get the most out of the directory resource. |