- All Tutorials
- Video Tutorials
- Quick Tutorials
13 Search results
How to quickly update the table of contents01: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....
Use VLOOKUP function to create dynamic charts03:44
Use VLOOKUP function to create dynamic charts
In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....
Insert Table of Figures and refer to the List of Captioned Objects01:20
Insert Table of Figures and refer to the List of Captioned Objects
When there are too many pictures or tables inserted into a document, we can make a table of figures. It can generate a list of captioned objects and their page numbers for quick location. So how do we insert the table of figures? In this document, for example, we have inserted 6 images with captions.Click the location where we need to insert the table of figures, and click the Insert Table of Figures button on the References tab to get a dialog. On the left side of the dialog, we can ....
Look up data quickly with LOOKUP function04:23
Look up data quickly with LOOKUP function
Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....
How can we insert endnotes for Documents01:26
How can we insert endnotes for Documents
Endnotes usually appear at the end of the text and are mostly used to cite sources. When writing a paper, we often need to add endnotes to supplement the specific text. Then how can we insert an endnote for documents? · Step 1Place the mouse cursor where you want to insert the endnote. Click the References tab first, then click Settings, and finally click Footnote/(and)Endnote. · Step 2In the Footnote/(and)Endnote dialog box, we can set the Location according to our needs. As for this ....
How can we add footnotes to a Document01:22
How can we add footnotes to a Document
Footnotes usually appear at the bottom of the page. These are comments on certain content. When editing text, we often need to use footnotes to supplement the specific text. For all, easy our work with WPS Office Writer. So how can we insert a footnote to the document? · Step 1Place the mouse cursor where you want to insert the footnote. Click the References tab, then click Settings. And finally click footnote/ (and)endnote. · Step 2Set the Location according to our needs in the Footno....
Use the Mail Merge function to input tabular data quickly01:49
Use the Mail Merge function to input tabular data quickly
WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....
How to Add Caption01:41
How to Add Caption
We can use the caption feature to number and annotate images, charts and other contents referenced in a document. So how do we use this feature? We take the image in this document as an example. Select the image, click References, and then click Caption to get a pop-up dialog.Click the Label pull-down to select the label you want. If none is available, you can click New Label to customize a label such as a Picture.Then select the Position of the caption. Click the Numbering button, you....