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

    456 results for kingsoft office for windows

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

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

    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

    Compare two excel files for differences in WPS Office Excel

    Welcome to WPS Official Academy to check the contents of compare two excel files for differences in WPS Office Excel. We often need to compare the data from two different excel files, but it would be troublesome to compare each item one by one with naked eyes. So how can we compare two excel files for differences in a quick and easy way? Let’s have a try step by step. Here we take two tables of employees performance appraisal for example. We can find the two tables are inconsistent wit....

    Spreadsheet 592 views
    Prev 123456...5657 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