WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        2866 results for All

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

        2866 results for All

        More features in Split or Merge

        More features in Split or Merge

        02:26

        More features in Split or Merge

        Sometimes we may need to split or merge documents when creating presentations. So how can we do that? In Microsoft PowerPoint1. To merge the editing PowerPoint with new slides, we can enter the "Home" tab, click ”New Slide," and click "Reuse Slides." Select a desired PowerPoint document on the right to insert it.2. In this way, only one document can be inserted at a time, and multiple documents require repeated operations to be merged.3. Besides, Microsoft PowerPoint doesn't suppor....

        Presentation 8.4K views
        Avoid image compression when saving files

        Avoid image compression when saving files

        00:37

        Avoid image compression when saving files

        No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. When we save a document that contains pictures, it happens that the images are compressed.How can we to prevent this? Click Menu and then Options, select General and Save on the left, and then check Do not compress images in the file" at Save on the right. In addition, we can also set the pixel resolution of the image at Set default target output....

        Writer 8.4K views
        Use data check method to quickly find difference items

        Use data check method to quickly find difference items

        01:40

        Use data check method to quickly find difference items

        Are you still checking table data one by one? Here are two practical methods that can help us find data difference items quickly. Take this table as an example. How can we do it, if we want to quickly find out the data difference items in the rows from Database1 to Database4? First, we select the cell range, then click the Home tab, and click the Find and Replace drop-down button. Select the Go To option under the drop-down menu, or we can also use the shortcut key Ctrl+G to open the d....

        Spreadsheet 8.3K views
        Use Validation to restrict date entries

        Use Validation to restrict date entries

        01:10

        Use Validation to restrict date entries

        When editing a spreadsheet, we may want to restrict the contents to ensure effectiveness, such as requiring the dates cannot exceed today. Today we will tell you how to restrict the input dates using Validation.First, select the cell range that contains the dates. Click Validation in the Data tab or use the shortcuts Alt+D+L.The Data Validation dialog will pop up, where you can select Date at Allow. Then, click the Data drop-down button to restrict the date range. Here, we select less ....

        Spreadsheet 8.3K views
        More features in Document Encryption

        More features in Document Encryption

        02:14

        More features in Document Encryption

        Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....

        Spreadsheet 8.2K views
        The AVERAGE, MAXIMUM, MINIMUM functions

        The AVERAGE, MAXIMUM, MINIMUM functions

        01:15

        The AVERAGE, MAXIMUM, MINIMUM functions

        When we analyze the sales performance of staff, the AVERAGE, MAXIMUM, and MINIMUM functions can help a lot. The worksheet on the screen lists the personal sales performance for each staff.If we want to get the average sales, we can use the AVERAGE function. Click cell C22, and enter the formula "=AVERAGE()". Then, input "E3-G21" within the parentheses, and press Enter to get the result.If we want to know the highest sales, we can use the MAX function. Click cell E22, and enter the form....

        Spreadsheet 8.1K views
        How to create radar chart

        How to create radar chart

        02:01

        How to create radar chart

        Radar chart displays data information on one dimension like a spider web, allowing us to learn the relationships between each piece of data to the whole and compare them quickly.Take this table as an example, which is a table of the competency rating of three employees this year. It's difficult to find out the differences between them only with this data, so we can use a radar chart to make it clear. 1. Select the needed cell range, click the Insert tab and click the Radar drop-dow....

        Spreadsheet 8.1K views
        Beautify The Table

        Beautify The Table

        10:38

        Beautify The Table

        You can start from three aspects: 1.select the correct color scheme. We can download color schemes from color matching websites.2.we can choose suitable icons to fill in the data series and make it interesting and vivid.3. we can achieve special effects by adjusting "Series Overlap" and create needle tube charts and mountain charts. We can click "Smoothed Line" to smooth the lines and adjust "LINE" and "MARKER" to enrich a line chart. After you've beautified a chart, right-click i....

        Spreadsheet 8.0K views
        Prev 1 ... 54 55 ... 358 359 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube