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
      • openoffice wps

      674 results for openoffice wps

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

      674 results for openoffice wps

      TEXT formula in WPS Spreadsheet

      TEXT formula in WPS Spreadsheet

      03:09

      TEXT formula in WPS Spreadsheet

      The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

      Spreadsheet 1,560 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
      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
      Set the text wrapping type in WPS Writer

      Set the text wrapping type in WPS Writer

      01:40

      Set the text wrapping type in WPS Writer

      After inserting the picture in the document, how can we set the text wrapping style? Take the word document as an example. This video could be also used in Microsoft Office Word and Openoffice. After clicking the picture, click the Wrap Text button in the floating toolbar to the right of the picture. We can choose a variety of text wrapping styles here. Click View more, and the Layout dialog box will pop up, which allows us to set the wrapping style more accurately.In the Text Wrapping....

      Writer 1,472 views
      How to set a worksheet in WPS Spreadsheet

      How to set a worksheet in WPS Spreadsheet

      03:53

      How to set a worksheet in WPS Spreadsheet

      The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

      Spreadsheet 721 views
      How to use tabs to align text quickly in WPS Writer

      How to use tabs to align text quickly in WPS Writer

      01:40

      How to use tabs to align text quickly in WPS Writer

      The function of Tabs in WPS Writer allows us to adjust the position of the text when typing by setting the horizontal Ruler, in order to align the text and symbols. And, it could be also used in Microsoft Office Word and Openoffice. How can we use the function of Tabs? If the ruler is not displayed in the document, we can click the View tab and check Ruler. The number on the Ruler represents the number of characters, and the page width on the current page is 41 characters width. Take t....

      Writer 5,006 views
      How to insert attachments in WPS Writer

      How to insert attachments in WPS Writer

      01:11

      How to insert attachments in WPS Writer

      When editing a document, we sometimes need to add related attachments to explain more detail. At this time, we can use the Insert Attachment function to open the attachment in the original file directly. It can greatly improve our work efficiency. So how can we do that? Take this document on introduction to Monet's as an example. We can insert his work as an attachment at the end of the document. It can make it easier for people who read this document to understand Monet.1. Click t....

      Writer 392 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
      Prev 123...8485 Next
      WPS Academy