WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to edit pivot table

    1630 results for how to edit pivot table

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

    1630 results for how to edit pivot table

    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 8.7K views
    How to print a table

    How to print a table

    12:23

    How to print a table

    This lesson summarizes the printing problems commonly encountered in the workplace1. How to make the printer obedient, forms are printed on a sheet of paper2. How to select the designated printing area3. When the form file is very long, how to set each page has a title line4. how to set the header and footer, so that your document more professional

    Spreadsheet 1.6K views
    How to quickly update the table of contents

    How to quickly update the table of contents

    01:10

    How to quickly update the table of contents

    How can we quickly update the table of contents when we need to modify the title content, location, and page number after setting up the table of contents? Take this document as an example. We found that the current page number is incorrect, so we modified the page number. At this time, the page numbers in the table of contents are not updated. And now we click the table of contents, and click the Update TOC button of the References tab. In the pop-up dialog, we choose Update page numb....

    Writer 4.4K views
    How to use the draw table tool

    How to use the draw table tool

    01:29

    How to use the draw table tool

    WPS Writer's draw table feature allows us to use the mouse to draw custom tables directly in the document. So, how can we do it? Click this table in the document. Click the Table Tools and the Draw Table button, and then the mouse cursor will become a brush, then we can draw tables in the document as needed. If we now want to draw a 3X4 table, hold down the left button on the mouse. At this point, the table dotted lines will appear on the page, and a floating window will appear in ....

    Writer 3.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 2.1K 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 921 views
    How to crop the picture in a table

    How to crop the picture in a table

    01:30

    How to crop the picture in a table

    Sometimes we need to crop the picture into the shape we want after inserting it. So how can we do that? Take this table as an example. We have inserted a picture of the clothes on the table, but the picture is a little large. We need to crop it into the right shape and size. Click on the picture to jump to the Picture Tools tab. Click the Crop drop-down button, and we can see two options. Here we select Crop by Scale to adjust its scale. We select the 1:1 scale to crop the picture. No....

    Spreadsheet 14.7K views
    How to add watermarks to a table

    How to add watermarks to a table

    02:19

    How to add watermarks to a table

    Watermarking a document can prevent it from being misused by others; the good news is that watermarks can be added to an excel table.We'll look at two different ways to add watermarks to your table today.The first approach is merely adding a single watermark, which can be utilized for a single-page table.Click Insert, and then click WordArt. Select a style to be inserted, and input the watermark content.The font style can be changed further by clicking Setting in Text Tools. You ca....

    Spreadsheet 2.3K views
    Prev 1 2 3 ... 203 204 Next
    WPS Academy
    Products
    Partners