WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        1254 results for how to change date format in pivot table

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

        1254 results for how to change date format in pivot table

        How to change the table format

        How to change the table format

        00:51

        How to change the table format

        When using WPS Spreadsheets, we can use the Fill Color tool to change the cell color. Are there any other methods to change the table style quickly? WPS Spreadsheets can realize it with its Format as Table function. 1. Select a cell range to be set. Get into the Home tab and click Format as Table to show its dropdown menu, where we can choose one from the default formats. 2. Left-click on any of the formats. Then, we can see the Format as Table dropdown menu. 3. Check the option titled....

        Spreadsheet 22.5K views
        How to set the calculated field of the pivot table

        How to set the calculated field of the pivot table

        01:49

        How to set the calculated field of the pivot table

        We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....

        Spreadsheet 41.2K views
        How to insert a table in WPS Presentation

        How to insert a table in WPS Presentation

        01:47

        How to insert a table in WPS Presentation

        When creating a presentation in WPS Office, sometimes we need to insert a table for data demonstration. How can we realize it? Take this PowerPoint as an example. Get into the Insert tab and click the Table dropdown menu. Then drag the cursor to decide the table size. This method allows us to create a table with 10 columns and 10 rows at maximum. If we want to insert a bigger table, choose Insert Table. In the Insert Table dialog, we can decide the numbers of columns and rows. Enter t....

        Presentation 10.2K 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 5.4K views
        How to apply accounting number format in WPS Spreadsheet

        How to apply accounting number format in WPS Spreadsheet

        00:56

        How to apply accounting number format in WPS Spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

        Spreadsheet 24.5K views
        How to set the table properties in WPS Writer

        How to set the table properties in WPS Writer

        02:19

        How to set the table properties in WPS Writer

        After we insert the table in the document, we may want to set the table. So how are we going to do that? Take the table in this document as an example. The width of the table is too long. If we need to adjust it, just click the cross cursor in the upper left corner of the table. Select the entire table, click the Table Tools tab, and click the Table Properties button. Now we can see a dialogue box has popped up. In the Table tab, we can enter an appropriate value in Size to adjust the....

        Writer 30.2K views
        How to delete blank rows of table in batches

        How to delete blank rows of table in batches

        00:51

        How to delete blank rows of table in batches

        When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once? We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, ....

        Spreadsheet 15.9K views
        How to insert a table of contents in word

        How to insert a table of contents in word

        02:00

        How to insert a table of contents in word

        A table of contents, also called TOC, is a significant part of an article. It can help readers to get the outline quickly and locate the target part. In WPS, we can insert a table of contents in a convenient way. Click the blank page inserted at the beginning of the article. Get into the Reference tab, and click Table of Contents. In the dropdown menu, we can choose from three styles of the table of contents, which presents in different layouts. Since we have "Heading 1", "Heading 2", ....

        Writer 24.2K views
        Prev 1 2 3 ... 156 157 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube