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
    • apps like wps office

    696 results for apps like wps office

    • 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

    Free Word templates specially for you in WPS Office

    The use of Word document is not limited to pure writing. Posts, resumes, schedules and the like can also be designed and created in a word document. To make a word page with a sense of design, you can download free Word templates in WPS Office. · Steps to download free Word templates in WPS Office.1. Open WPS Office.2. Head to the homepage > Apps > Templates to enter the template library. 3. Click Document on the left to view the templates for word.4. Click the theme on the top to view....

    Writer 527 views

    How to create a revenue model in WPS Office Excel

    You are visiting WPS Academy for free tutorials. In this article, you will know how to create a revenue model in excel with simple steps as follows: · Choose a revenue model in WPS Templates1. Go to the homepage of WPS Office > Apps > Templates. 2. Input “revenue” in the search box in the upper right corner, and press the Enter key.3. You are provided with diverse revenue models, and you can use any of them with one click. Note that Template Premium users can enjoy all the templates f....

    Spreadsheet 309 views

    How to do expenses in WPS Office Excel

    Welcome to WPS Official Academy. You are reading the tutorial of how to do expenses in excel. You will master how to create an expenses table with one click! Are you struggling in doing expenses? Are you concerned about how to take the first step? Don’t fret. WPS Templates provides a lot of beautiful and practical templates for you, with which you are able to do expenses easily. · Choose an expense template in WPS Templates1. Navigate to the homepage of WPS Office > Apps > Templates. 2....

    Spreadsheet 208 views

    Free PowerPoint templates specially for you in WPS Office

    Come to WPS Office and get immediate access to thousands of free PowerPoint templates! With these appealing PowerPoint templates, you are free from the troublesome process of searching for decorative elements and racking your brains to design slides. To enjoy diverse fancy templates, don’t hesitate to click here to download WPS Office for free now. · Steps to download free PowerPoint templates in WPS Office.1. Open WPS Office on your device.2. Go to the homepage, click Apps and then cl....

    Presentation 249 views

    How to create mortgage calculator in WPS Office Excel

    A mortgage calculator is commonly used to estimate monthly mortgage payments. It would be time-consuming to create a mortgage calculator from scratch. For convenience, WPS Office provides you with professional and practical mortgage calculator templates. Without further ado, let’s get started! · Steps to create a mortgage calculator with templates in WPS Office.1. Go to the homepage of WPS Office, and click Apps > Templates.2. Input “Mortgage Calculator” in the search box on the top an....

    Spreadsheet 185 views
    How to use Navigation Pane

    How to use Navigation Pane

    02:01

    How to use Navigation Pane

    Navigation Pane works like GPS in WPS Office, allowing users to find and locate text and adjust article structures more efficiently. 1. We need to open the Navigation Pane. Click the View tab, select Navigation Pane, and then it will appear on the left. 2. We can also click the Navigation Pane drop-down button and choose Move to Right according to our habits.There are four icons on the left, namely, Content, Section Navigation, Bookmark, and Find and Replace.· ContentHere is the table ....

    Writer 43 views
    Prev 123456...8687 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