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
    • take backup of computer data

    107 results for take backup of computer data

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF
    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
    Explanations on print interface

    Explanations on print interface

    03:53

    Explanations on print interface

    When using WPS Office to print Spreadsheets, Documents, Presentations, and PDF files, we will often encounter various printing problems. So in this video, we are going to briefly explain the functions of each small feature in the print panel. Take this table as an example. 1. First of all, we need to make sure that the printer is in good condition and also ready to print. 2. In addition, we need to make sure the computer we are using can find the printing device in the local area netwo....

    Spreadsheet 9.8K views
    Instructions of printing interface in WPS Writer

    Instructions of printing interface in WPS Writer

    04:06

    Instructions of printing interface in WPS Writer

    When we use WPS Office to print documents, we often encounter a variety of printing glitches. So in this video, we are going to briefly explain the effects of each small function in the print panel. Let's take this thesis as an example. First, we need to make sure that the hardware device of the printer is normal and on-state. Meanwhile, we also need to determine whether the computer used can find your printing device in LAN. 1. Click Menu and Print. The Print dialog box also can b....

    Writer 5.0K views
    Conditional Formatting for data virtualization

    Conditional Formatting for data virtualization

    01:23

    Conditional Formatting for data virtualization

    Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

    Spreadsheet 32 views
    Refresh pivotTable and change data source

    Refresh pivotTable and change data source

    01:28

    Refresh pivotTable and change data source

    If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....

    Spreadsheet 203 views
    How to consolidate data in WPS Spreadsheet

    How to consolidate data in WPS Spreadsheet

    01:28

    How to consolidate data in WPS Spreadsheet

    In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

    Spreadsheet 1,635 views
    How to create a Form in spreadsheet

    How to create a Form in spreadsheet

    01:26

    How to create a Form in spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

    Spreadsheet 235 views
    Recalculate the table formulas in the Manual Recalculation mode

    Recalculate the table formulas in the Manual Recalculation mode

    01:20

    Recalculate the table formulas in the Manual Recalculation mode

    Today, let me introduce you to a lesser-used function, Manual Recalculation. Take this document as an example. Now, the cells have formulas. When we modify the source data, the values in the table will also change automatically. That is because the table turns on the automatic calculation by default. When we need to process a particularly large amount of data in the worksheet, if we still choose automatic calculation, then every time we change the source data, the table data processing....

    Spreadsheet 124 views
    Prev 123456...1314 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