WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to add a title to a pivot table

    2774 results for how to add a title to a pivot table

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

    2774 results for how to add a title to a pivot table

    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 3.9K 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 3.2K 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 2.3K 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 11.2K views
    How to add a watermark

    How to add a watermark

    02:14

    How to add a watermark

    WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

    Writer 4.3K 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 8.3K views
    How to add a stamp in a PDF file

    How to add a stamp in a PDF file

    01:42

    How to add a stamp in a PDF file

    We use powerful PDF in our daily life nearly every day.In our daily work and study, we can insert a stamp in the PDF file to indicate that the file has already been reviewed.Now we are going to introduce the Stamp WPS Premium feature.Click the Comment tab and then click Stamp. Here, WPS has provided us with a large variety of presets. We can click the needed stamp style and place it in the appropriate area of the page. We can also customize the stamp. Click Click to Add, then the Add S....

    PDF 2.4K views
    How to input data into a table efficiently

    How to input data into a table efficiently

    12:21

    How to input data into a table efficiently

    1. The basic rules of inputting data.2. Commonly-used fill functions (Fill handle, Series, and Flash Fill).3. Create simple drop-down lists for higher efficiency.4. Use the OCR function for quick input.

    Spreadsheet 2.6K views
    Prev 1 2 3 ... 346 347 Next
    WPS Academy
    Products
    Partners