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

        2922 results for All

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

        2922 results for All

        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 7.3K views
        Use charts to present data

        Use charts to present data

        09:15

        Use charts to present data

        1.In this lesson shared several chart types, such as column, line, pie, bar, area, scatter, radar, and bubble chart. Each chart has its own features and imperfections. We should pick the chart that best fits the topic. 2.Many different elements make up a chart, such as a chart title, data labels, trendlines, and so on. We should pick elements appropriately, concisely, and clearly. 3.We also learn the basics of ribbon buttons. We know how to change the chart type, how to switch rows and....

        Spreadsheet 7.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 7.1K 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 7.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 7.0K 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 7.0K views
        More features in picture inserting

        More features in picture inserting

        01:53

        More features in picture inserting

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell. In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them. If the position of the table changes, the inserted pictures will not fit in the new ce....

        Spreadsheet 6.9K views
        How to create a bubble chart

        How to create a bubble chart

        03:20

        How to create a bubble chart

        Similar to a scatter chart, a bubble chart is mainly composed of bubbles and variables to display information. Unlike scatter charts that can only display variables in the X and Y axis, bubble charts display the skill to the third variable with bubble areas.Bubble charts can be used widely in making maps- a perfect match for displaying data with regional characteristics.This is the survey data of mobile phone sales in a certain area. Let's take it as an example to make a simple bub....

        Spreadsheet 6.9K views
        Prev 1 ... 54 55 ... 365 366 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