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
  • 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
    WPS 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
    Login/Sign up
    Top Searches

      • Home
      • Video Tutorials
      • Graphic Tutorials
      • Home
      • Popular
      • how to recover deleted excel files in windows xp

      70 results for how to recover deleted excel files in windows xp

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

      70 results for how to recover deleted excel files in windows xp

      How to merge and split PDF files

      How to merge and split PDF files

      01:25

      How to merge and split PDF files

      WPS PDF could help edit PDF files and freely convert between PDF and Word, Excel, PowerPoint, and JPG files online. When editing PDF files, we often need to merge multiple PDF files or split a PDF file. So how can we do that?· Merge PagesTake this file as an example. When we need to merge multiple PDF files into one, click the Page tab, then click Merge Page. Now the WPS PDF to Word Converter dialog box will pop up. Click the Add files button in the upper right corner and select other ....

      PDF 1,179 views
      How to view two sheets side by side

      How to view two sheets side by side

      01:09

      How to view two sheets side by side

      When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

      Spreadsheet 68 views
      Use the Mail Merge function to input tabular data quickly

      Use the Mail Merge function to input tabular data quickly

      01:49

      Use the Mail Merge function to input tabular data quickly

      WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....

      Writer 383 views
      Why error message #REF! occurs and how to solve it

      Why error message #REF! occurs and how to solve it

      03:18

      Why error message #REF! occurs and how to solve it

      The error message "#REF" is common in table calculations. In general, there are mainly two causes. First, the referenced cells in the formula are deleted or replaced by other cells. Second, the formula references invalid cell ranges or values. Then how can we solve these problems? · The referenced cells in the formula are deleted or replaced by other cells.o The referenced cells in the formula are deleted.Take this table as an example. 1. To calculate the total sales of computers t....

      Spreadsheet 11 views
      Unique Features in File Collect

      Unique Features in File Collect

      03:21

      Unique Features in File Collect

      WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. In the workplace, collecting all kinds of documents is frequently needed. At this time, a file folder is always wanted to collect what we need by sending a sharing link to others At present, such a function is not available in other office software on the market. Fortunately, WPS launched the File Collect feature for a more efficient office experience. ....

      Spreadsheet 36 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
      How to compress pictures in WPS Presentation

      How to compress pictures in WPS Presentation

      01:33

      How to compress pictures in WPS Presentation

      When we are making slides, we often need to insert multiple pictures. When there are too many pictures, the file size may increase, and the transmission speed will slow down.As is shown in this video, here are two presentation files with the same content. The file that has used the Compress Picture feature has a significantly smaller size than the other one. So how can we compress pictures?1. Click to select the picture.2. Then click the Compress Picture button in the Picture Tool tab ....

      Presentation 844 views
      How to convert Excel to PDF

      How to convert Excel to PDF

      02:50

      How to convert Excel to PDF

      PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

      Spreadsheet 287 views
      Prev 123...89 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