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
      • link wps office

      854 results for link wps office

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

      854 results for link wps office

      How to link WPS Writer and Spreadsheet together

      How to link WPS Writer and Spreadsheet together

      02:26

      How to link WPS Writer and Spreadsheet together

      In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....

      Writer 10 views
      Hyperlink in WPS Office Spreadsheet

      Hyperlink in WPS Office Spreadsheet

      02:22

      Hyperlink in WPS Office Spreadsheet

      When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

      Spreadsheet 4.7K views
      How to insert video in WPS Presentation

      How to insert video in WPS Presentation

      01:07

      How to insert video in WPS Presentation

      When making slides, we can make the presentation look more professional by inserting video adequately in slides. So how can we insert videos?Take these slides as an example. Click the Insert tab above, and then click Movie. Here, we can choose Local Video or Link Localvideo. The main difference between them is the way of saving the video files.Please note that: if we choose Link Localvideo to insert a video, once we send the slides to other devices, WPS Presentation may not be able to ....

      Presentation 1,239 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
      How to insert audio in WPS Presentation

      How to insert audio in WPS Presentation

      02:38

      How to insert audio in WPS Presentation

      When giving a speech, we often need background music to set off the atmosphere. So how do we insert audio when making slides? Take this slide as an example, click the Insert tab above, and then click Audio. Here we can see Insert Audio, Link to Sound, Background Music and Link Background Music these four options. The difference between Audio and Background Music is that when we choose the Audio option, we can only hear the music when we play the slideshow where the music is inserted. B....

      Presentation 1,325 views
      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 insert objects in WPS Presentation

      How to insert objects in WPS Presentation

      01:17

      How to insert objects in WPS Presentation

      You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Take this presentation as an example. In order to better explain the contents, I will insert a table into this slide. Click Object in the Insert tab. A dialogue box will pop up, where we could select Create new or Create from file.In the Create new interface, we can select different types of blank documents at the Object type, but we need to edit them manually. In the Create ....

      Presentation 73 views
      How to insert objects in WPS Writer

      How to insert objects in WPS Writer

      01:53

      How to insert objects in WPS Writer

      No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Today we will learn how to insert objects into the document by embedding or linking. 1. Embedding ObjectsTaking this document as an example, I want to insert an existing spreadsheet into the document to elaborate on the contents.Place your cursor to where you want to embed an object, then head to the Insert tab, select Object. A dialogue box will....

      Writer 129 views
      Prev 123...106107 Next
      WPS Academy