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
    • wps office for windows

    846 results for wps office for windows

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF
    How to create a resume for work in WPS Writer

    How to create a resume for work in WPS Writer

    05:08

    How to create a resume for work in WPS Writer

    Graduation season is coming. Do you know how to create a professional resume for a job like this? Now we'll introduce you to how to create a resume in WPS Writer step by step. l Step 1. Set the page size.In this blank document, we need to set the page size and margin in advance. Click the Page Layout tab, select the common size of a resume, A4, and set Margins as the built-in Narrow.l Step 2. Arrange the overall layout with ShapesThe resume should be clean and concise with fewer f....

    Writer 29 views
    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

    Get to know about WPS Spreadsheet for windows

    Digital tables are widely used in our daily work. WPS Spreadsheet, the best alternative to Microsoft Excel, allows you to process values, perform calculations and analyze data with high efficiency. Read this tutorial to know more about WPS Spreadsheet. · What is WPS Spreadsheet?WPS Spreadsheet is a module of WPS Office(an acronym for Writer, Presentation and Spreadsheet). WPS Spreadsheet is consistent with Excel document, which helps users to work with high efficiency. Its personal bas....

    Spreadsheet 218 views

    Compare two sheets for duplicate rows in WPS Office Excel

    Welcome to WPS Official Academy to check the contents of how to compare two excel spreadsheets for duplicate rows. It would be a waste of time to search for duplicate rows by comparing each two rows manually. WPS Office provides a function of Highlight Duplicates to help you compare two sheets for duplicate rows quickly. Let’s have a try step by step. Here we take two lists of participants as examples. We want to find out the participants who have participated in both conferences by hi....

    Spreadsheet 533 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

    Compare two sheets for differences in WPS Office Excel

    Are you ready to master how to find differences between two sheets in WPS Office Excel? After learning this WPS free tutorial, you will be advanced from a beginner in WPS Spreadsheet. Sometimes we need to compare two worksheets and find out the differences between them but you’ll feel dizzy to compare each item one by one. At this point, the View Side by Side and Manage Duplicates function can help a lot. Let’s have a try step by step.Here we take two performance appraisal sheets (Jan....

    Spreadsheet 417 views

    How to insert a line for resume in WPS Office Word

    Welcome to WPS Official Academy to check the contents of how to insert a line for resume in WPS Office Word. You are sure to master the simple skills in inserting a line after reading this tutorial! · Steps to insert a line for resume in WPS Office Word1. Open your resume with your basic information.2. Head to the Insert tab, click the Shapes drop-down button and choose a line at Lines.3. Then draw a line in the suitable position by holding and dragging the mouse. You can further edit....

    Writer 226 views
    Prev 123456...105106 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