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
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • how to recover replaced excel files in windows 10

      76 results for how to recover replaced excel files in windows 10

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

      76 results for how to recover replaced excel files in windows 10

      How to calculate top 10 in WPS Office Excel

      In this article, you will know how to calculate top 10 in excel with simple steps as following: Here we take a scholarship table as an example. Suppose we want to calculate the top 10 scholarships. · Find out the top 10 values in WPS SpreadsheetHere are two methods to find out the top 10 values in WPS Spreadsheet.o Method 1: We can use the Conditional Formatting function to highlight the top 10 values.1. Select the cell range, click the Conditional Formatting drop-down button in the H....

      Spreadsheet 421 views
      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 extract and replace the page content of a PDF file

      How to extract and replace the page content of a PDF file

      01:23

      How to extract and replace the page content of a PDF file

      When we are editing a PDF file, what should we do if we want to extract and replace several pages of the content?We can use the Extract Page and Replace pages functions of WPS Premium. If we want to extract the third page of this file and save it separately as a PDF file, click the Page tab, click Extract Page. In the Extract Mode box, select Extract selected page to PDF. In Page range, enter 3.We can add a watermark to the file, and we can also name the newly output file and set the s....

      PDF 361 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
      Text direction in WPS Presentation

      Text direction in WPS Presentation

      02:34

      Text direction in WPS Presentation

      When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....

      Presentation 50 views
      Combine the SUBSTITUTE and LEN functions

      Combine the SUBSTITUTE and LEN functions

      02:57

      Combine the SUBSTITUTE and LEN functions

      Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

      Spreadsheet 211 views
      Prev 123...910 Next
      WPS Academy