Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy

WPS Academy Free office suite tutorials

  • Home
  • Video Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Data Visualization Page Layout Review and Security More Functions and Formulas
    WPS Writer Text Writing Insert and Edit Page Layout Review and Security References More
    WPS Presentation View Insert and Edit Animation and Slide Show More Review and Security
    PDF Multiple Editing Tools Insert More Add Comments Page Management File Format Conversion Print
  • Graphic Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Functions and Formulas Page Layout Review and Security More
    WPS Writer Text Writing Insert and Edit References Page Layout Review and Comments Security More
    WPS Presentation Insert and Edit Animation and Slide Show Premium Benefits More
    PDF Edit View Review and Comments Security Premium Benefits More
    WPS Basics Home Page Settings and Account Premium Benefits More
    Beginner Tutorial Preferences Settings Get Started Common Uses
  • Download
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
Top Searches
    Login/Sign up
    • Home
    • Popular
    • update windows 10

    209 results for update windows 10

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF
    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 1,004 views

    How to update the table of contents

    When using WPS Writer to process word documents, how can we update the table of contents that is automatically created? 1. Open the Word document with WPS Writer. 2. Select the contents in the interface → the Reference tab → click Update TOC. No matter you are a student, teacher, or business professionals can create and edit documents efficiently by WPS Writer as text editors. Easy to use as Microsoft Word.

    Writer 1,606 views

    How to update only the page number in a table of contents

    1. Open the document we want to edit in WPS Writer.2. Click on the table of contents.3. Click References tab → and then click the Update TOC button.4. Now a Update Table of Contents small dialog box will pop up. Check Update page numbers only.5. Finally, click OK. This skill could also be used in Microsoft Office Word and OpenOffice.

    Writer 669 views
    Insert date and time in the header or footer

    Insert date and time in the header or footer

    00:55

    Insert date and time in the header or footer

    WPS Writer allows users to add various styles of header and footer, including text, pictures, and date and time. So how can we realize inserting date and time? A footer has been added to this document. So here we take the header as an example to show how to insert date and time. Get into the Header/Footer tab and click Date and Time to pop up the dialog. On the left-hand side of the dialog, we can choose from different formats to present the date and time. Check the Update automaticall....

    Writer 523 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 302 views
    Create a countdown calendar & Insert current time and date

    Create a countdown calendar & Insert current time and date

    02:14

    Create a countdown calendar & Insert current time and date

    WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....

    Spreadsheet 284 views

    How to calculate top 10 in WPS Office Excel

    In this article, you will know how to calculate top 10 in excel with simple steps as following: Here we take a scholarship table as an example. Suppose we want to calculate the top 10 scholarships. · Find out the top 10 values in WPS SpreadsheetHere are two methods to find out the top 10 values in WPS Spreadsheet.o Method 1: We can use the Conditional Formatting function to highlight the top 10 values.1. Select the cell range, click the Conditional Formatting drop-down button in the H....

    Spreadsheet 421 views
    Make a countdown calendar in WPS Spreadsheet

    Make a countdown calendar in WPS Spreadsheet

    01:37

    Make a countdown calendar in WPS Spreadsheet

    It would be helpful to insert a countdown calendar into a project schedule so that we can view the deadline every time we open it. So today we are going to learn how to make a countdown calendar. Take this table as an example. 1. On the right of "Current date," input the formula "=TODAY()" and press the Enter key on the keyboard to return the current day.The Today function can synchronize the date set on the current computer so that the current date will update automatically every time....

    Spreadsheet 14 views
    Prev 123456...2627 Next
    WPS Academy
    Products
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches
    Partners
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches