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
    • kingsoft wps office 2

    860 results for kingsoft wps office 2

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF
    Hyperlink in WPS Office Spreadsheet

    Hyperlink in WPS Office Spreadsheet

    02:22

    Hyperlink in WPS Office Spreadsheet

    When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

    Spreadsheet 4.7K views
    Set the page printing area in WPS Office Spreadsheet

    Set the page printing area in WPS Office Spreadsheet

    00:47

    Set the page printing area in WPS Office Spreadsheet

    What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

    Spreadsheet 1,703 views
    Basic settings on footer and header

    Basic settings on footer and header

    01:44

    Basic settings on footer and header

    When we are editing documents, we sometimes need to add additional information such as company name, logo, date, etc. in the header and footer. The additional information ensures the integrity of the document. This video of Basic settings on footer and header could be also used in Microsoft Office Word and Openoffice. Steps:Take this document as an example. 1. Click the Insert tab, and then the Header and Footer button in turn. 2. Click the header text box, and enter “Kingsoft Office”....

    Writer 1.6K views
    Get to know the WPS Spreadsheet

    Get to know the WPS Spreadsheet

    02:04

    Get to know the WPS Spreadsheet

    WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....

    Spreadsheet 5 views

    How to start page numbers on page 2 in WPS Writer

    1. Open the document in WPS Writer.2. Click the Insert tab → and then click the Page Number button.3. In the popup drop-down menu, select Insert Page Number. Then the Insert Page Number dialog box will pop up.4. Here, check Start at Page numbering area.5. Adjust the start number as 0.6. Now click OK. We can now see that the page number of this document is started on page 2. This skill could also be used in Microsoft Office Word and OpenOffice.

    Writer 132 views

    How to compress PDF quickly in WPS Office

    Sometimes the files are too large to upload or send to other people, so we need to compress the file. PDF is a commonly used format at work. In this free tutorial, you will learn how to compress PDF files within only several steps. Without further ado, let’s begin. · Steps to compress PDF quickly in WPS Office.1. Open the PDF file you need to compress in WPS Office.2. Head to the Tools tab, and click Compress to pop up a dialog. In the Kingsoft PDF Compression dialog:3. Check the PDF f....

    PDF 209 views

    How to add password to PDF in WPS Office

    In many cases, we need to prevent the contents in a PDF file from casual alteration or view. Thus, we need the free and easy-to-use PDF editor provided by WPS Office. As the supporting platform of WPS Office, WPS Academy offers this free tutorial to share the trick of adding password to PDF in WPS Office. Continue to read and master quickly!lSteps to add a password to PDF in WPS Office.1. Open the PDF file in WPS Office.2. Navigate to the Protect tab, and click the Encrypt button. 3. I....

    PDF 211 views

    How to make ppt presentation on laptop in WPS Office

    Making an attractive ppt is the essential skill at both workplace and campus. A presentation enables your ideas to become more convincing and outstanding. In today's tutorial, WPS Academy will introduce you to the must-have skills on how to make ppt presentation in WPS Office on laptop. l Tricks on how to make ppt presentation on laptop in WPS OfficeNote: Please click the following links to watch the video tutorials in detail.Ø Shortcuts in making slidesFirst of all, here is a coll....

    Presentation 348 views
    Prev 123456...107108 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