WPS Tabular Data Application Example

The powerful WPS2012 finally came, I downloaded the first time to grab a fresh version and a trial. Really tough ah, finally understand the original meaning of WPS is "I fear who" ah, hehe!

1, the smooth installation after the jump into the eye is familiar with the interface.

Compared with Excel, wps a fairly good improvement is to move the file tag to the toolbar, very user-friendly. Avoids the problem of too many open tables causing the taskbar to not fit. There is the online material library support, very simple and easy to use, can save a lot of time. The "shareholder roster application example. xls", for example, explains her powerful table-handling function.

2, the general listed company's shareholders in more than million. Now we want to analyze the shareholding of its institutional investors; if it's a few funds from a fund company, we'd also like to know the number of shares per fund company. What should we do?

The table above is a list of 20 of the information, we together to use WPS analysis, deal with it!

3, first of all the natural person holdings of information deleted. We note that, relative to institutional investors, the names of natural persons are relatively short, including hyphenated and no more than 4 full-width characters. Then we'll have a way out!

In the last column, add the character length field and use the WPS table's own function to calculate its character length:

Then select data-Filter-AutoFilter.

Remember that when the target cell is placed in any cell in this worksheet range, do not check several cells, or you cannot filter the table. Other digital processing functions such as sorting, subtotals, and so on.

Click on the "character length" of the small black triangle, select (custom)

The Customize AutoFilter dialog box pops up, and the character length is selected to be less than or equal to 4, OK.

The table displays only records with a "shareholder name" character length less than or equal to 4, deleted.

Triple Recommendation: Click to download the WPS 2012 Office software "" To see more computer tutorials

Then select the character Length filter icon dialog box (all) to see that the natural person data has been deleted.

4, then the institutional investors to deal with to get the data we want. We know that the name of the shareholder "-" before the name of the bank is the name of the custodian Bank of the institutional investor, followed by the name of the institutional investor. Then we must separate them first. First insert a blank column after the "Shareholder name" field, and then click "Data-Breakdown".

The Text Column Wizard dialog box appears, selecting the default value separator symbol, and then next.

Check "Other" in the separator, followed by the separator "-" in the Shareholder name field, and next.

Change the options according to the actual situation. Not at this time, done.

Get a list of new cells named "Institutional Investor name" and delete the original "shareholder name" field.

Sort the institutional investors: Select data-Sort.

The Sort dialog box pops up, the main keyword is "Institutional investor name" field, ascending, OK.

This results in a sort of a general understanding of the stock ownership of each fund.