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
      • kingsoft office 2019

      663 results for kingsoft office 2019

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

      663 results for kingsoft office 2019

      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
      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

      Top 5 useful functions of Kingsoft Excel

      A good command of Excel is a great advantage in the workplace. To help you through the necessary skills in Excel, Kingsoft Office, also called WPS Office, offers thousands of free tutorials. This article collects 5 top functions of Kingsoft Excel for you to learn quickly. Without further ado, let’s go through them one by one. · Quickly learn 5 top functions of Kingsoft ExcelNote: You can click the following pictures to watch the video tutorials.1. Learn pivot table from the beginning.A....

      Spreadsheet 225 views

      5 basic functions in Kingsoft Word

      In this article, you will learn 5 basic functions in Kingsoft Word. Master these practical skills to improve your office productivity.l An introduction to 5 magic functions in Kingsoft Word: Ø Quickly turn to page 50 without rolling the mouseHead to the Home tab, click the Find and Replace drop-down button and select the Go To button, or press Ctrl+G to pop up the dialog box.In Go to what, click Page, enter “50” in the Enter page number, and click Go To. Ø Check the boxHead to the Inse....

      Writer 222 views
      Basic settings on footer and header

      Basic settings on footer and header

      01:44

      Basic settings on footer and header

      When we are editing documents, we sometimes need to add additional information such as company name, logo, date, etc. in the header and footer. The additional information ensures the integrity of the document. This video of Basic settings on footer and header could be also used in Microsoft Office Word and Openoffice. Steps:Take this document as an example. 1. Click the Insert tab, and then the Header and Footer button in turn. 2. Click the header text box, and enter “Kingsoft Office”....

      Writer 1.6K views
      Customize the formats to show data changes

      Customize the formats to show data changes

      01:28

      Customize the formats to show data changes

      Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....

      Spreadsheet 2 views
      Get to know the WPS Spreadsheet

      Get to know the WPS Spreadsheet

      02:04

      Get to know the WPS Spreadsheet

      WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....

      Spreadsheet 5 views

      4 advantages of Kingsoft PDF:vector graphics, Keep print format, high Compatibility, Small volume

      PDF editing is usually not free and requires membership, but why do so many people still use PDF? Here are 4 advantages of Kingsoft PDF:vector graphics, unchanged ptinting layout, high compatibility, and small size.l Kingsoft PDF supports vector graphicsThe vector graphic, a kind of graph that can be enlarged or reduced without affecting the clarity, has obvious advantages in work, especially in engineering drawings. Vector graphics are often saved as PDF format in Kingsoft.l Kingsoft ....

      PDF 304 views
      Prev 123...8283 Next
      WPS Academy