WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • 3 digit zip code list by state excel

    644 results for 3 digit zip code list by state excel

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    644 results for 3 digit zip code list by state excel

    Set input conditions and drop-down menus

    Set input conditions and drop-down menus

    01:54

    Set input conditions and drop-down menus

    The Data Validation feature of the WPS Spreadsheet can help us quickly complete the setting of input conditions and drop-down menus, thereby improving the accuracy of our input data.Take this form as an example. Now we need to enter a 9-digit US passport number in column C. We can use Data Validation to improve the accuracy of our input data.1. Select the cell range, then click the Data tab. 2. Click the Validation drop-down button.3. Now select the Validation option in the drop-down m....

    Spreadsheet 2.1K views
    Quickly filter classified data

    Quickly filter classified data

    01:41

    Quickly filter classified data

    How to quickly extract data of a certain category from a large amount of data? The filtering feature of WPS Office can help us to do it quickly. Take this table as an example. How are we going to filter out the data of New York? 1. Select any cell in the list.2. Click the Home tab.3. Click the AutoFilter drop-down button or use the shortcut key CTRL+Shift+L to set. Then the data list will enter the filtering state. 4. Click the gray inverted triangle arrow in the header cell of Branch,....

    Spreadsheet 11.9K views
    How to make conference table cards in batches

    How to make conference table cards in batches

    02:58

    How to make conference table cards in batches

    Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....

    Writer 1.3K views
    More features in AutoFilter

    More features in AutoFilter

    02:39

    More features in AutoFilter

    When dealing with large amounts of table data, we often need to temporarily hide some of them with AutoFilter to focus on those we need. Here we will compare the AutoFilter function of WPS Spreadsheets and Microsoft Excel. In general, both of them support filtering data according to numbers, text, color and so on.WPS Spreadsheets has three special advantages. Let's go through them one by one.First, Click the Home tab, and click the AutoFilter drop-down button to turn on the AutoFil....

    Spreadsheet 2.0K views

    Top 10 Property Management Excel Templates

    Top 10 Property Management Excel Templates - WPS Office Keeping accurate records is crucial for landlords and property managers not only for staying organized but also for protecting their legal interests. You can improve the flow of your business operations by using accurate property management excel templates that meet your state and local requirements. Positive customer experiences are also based on efficiency and security. The following list contains free property management excel ....

    xls Spreadsheet 994 views
    How can we create a drop-down list

    How can we create a drop-down list

    01:33

    How can we create a drop-down list

    How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....

    Spreadsheet 10.2K views
    Learn pivot table from the beginning

    Learn pivot table from the beginning

    04:27

    Learn pivot table from the beginning

    A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....

    Spreadsheet 17.6K views
    Use pivot chart to create a dynamic chart

    Use pivot chart to create a dynamic chart

    04:49

    Use pivot chart to create a dynamic chart

    A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data. Suppose we now want to create a pivot chart of the total sales of each branch in the fourth quarter. How can we do that? Take this table as an example. Select any cell in the data area, click the Insert tab, then the PivotChart button. Now select New Worksheet in the popup dialog box, and click OK. After that, we can create an empty PivotTable and an empty PivotChart.In W....

    Spreadsheet 4.0K views
    Prev 1 2 3 ... 80 81 Next
    WPS Academy
    Products
    Partners