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 is most information communicated today

      147 results for how is most information communicated today

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

      147 results for how is most information communicated today

      How to use the paste special function

      How to use the paste special function

      02:11

      How to use the paste special function

      Copy-paste has always been one of the most frequently-used functions in excel. However, few people are aware of its true power. Today we will learn how to utilize Paste Special in excel.The first method is to paste special contents in your table.Take this table as an example. This table is set with styles. In many cases, we merely want to paste the values but don't want the original styles. What should we do? Press Ctrl+C to copy the contents, click the Paste drop-down menu in the ....

      Spreadsheet 76 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
      The Camera in WPS Spreadsheet

      The Camera in WPS Spreadsheet

      01:44

      The Camera in WPS Spreadsheet

      Today we will get to know the Camera in WPS Spreadsheet. With this feature, we can convert the table into a picture, and the contents of the picture will change as those of the table. Here are two sheets: Itinerary and Tour Route Planning Table. To make it convenient for comparison, we would like to place them side by side. Most people may choose to copy the data of the Tour Route Planning Table sheet and paste it into the Itinerary sheet. However, this is not a perfect way. First, we....

      Spreadsheet 64 views
      Set formulas as the validation condition

      Set formulas as the validation condition

      00:59

      Set formulas as the validation condition

      Sometimes we need some preconditions to improve the validity when inputting data. Today we will learn how to set formulas as the validation condition.For example, we only need to enter the spouse's name if the marital status in column D is "married."First, select the cell area E3: E11, click "Validation" in the "Data" tab to enter the "Data Validation" dialog, where we can select "Custom" at the "Allow" drop-down box.Then, enter the formula =D3="married." It means that people can ....

      Spreadsheet 11 views
      How to add annotations to PDF files

      How to add annotations to PDF files

      02:08

      How to add annotations to PDF files

      When we read the information of certain PDF documents, sometimes we need to mark some important paragraphs or add corresponding comments to some content. Today I would like to introduce how to add annotations to PDF documents quickly. Take this PDF document as an example. Click the Comment tab, and click the Note Mode button. At this time, a blank page appears on the right side of the document body. We select the text that needs to be annotated, click the Highlight drop-down menu, and ....

      PDF 601 views
      How to insert Check Box

      How to insert Check Box

      02:45

      How to insert Check Box

      When creating tables, we often need to insert check boxes to check the information quickly and check multiple options at once. Today we'll learn how to insert check boxes. Take this Registration of Selected Courses table as an example. 1. Go to the Insert tab, click the Forms drop-down button, and select the Check box. 2. The cursor becomes the shape of a cross, and you can insert a check box by dragging the mouse.3. Input text in the check box, such as "French."Then the check box ....

      Spreadsheet 21 views
      How can we use the data validation feature

      How can we use the data validation feature

      02:46

      How can we use the data validation feature

      We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Take this table as an example. This is the information collection form for US citizens joining tour groups for international travel. We need to fill in the information of all the participants. How can we ensure that the passport numbers and phone numbers we entered will not be wrong? 1. First, select the cell area where data needs to be filled.2. Click the Data tab.3.....

      Spreadsheet 1,890 views
      More features in Picture to Text

      More features in Picture to Text

      01:55

      More features in Picture to Text

      WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users. WPS Presentation and Microsoft Office both can convert pictures to text. Today we will analyze their differences. Microsoft PowerPoint itself does not support OCR function. If you want to realize Picture to Text, you need to open another app-OneNote.Copy the picture to OneNote, right-click the image to select Copy Text from Picture. Fin....

      Presentation 48 views
      Prev 123...1819 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