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

        Combine the SUBSTITUTE and LEN functions

        Combine the SUBSTITUTE and LEN functions

        02:57

        Combine the SUBSTITUTE and LEN functions

        Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

        Spreadsheet 12.2K views
        How to insert calculated fields in PivotTable

        How to insert calculated fields in PivotTable

        01:06

        How to insert calculated fields in PivotTable

        Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....

        Spreadsheet 12.2K views
        How to set the picture rotation in WPS Presentation

        How to set the picture rotation in WPS Presentation

        01:22

        How to set the picture rotation in WPS Presentation

        We often insert pictures when using WPS Presentation, but if we want to make the layout of the slides more varied, we can try the Rotate feature of images. Take this slide as an example. Select a picture as needed, and a rotation icon will appear above the image. Press the left mouse button. Then we can adjust the rotation angle. If we need to flip a picture, we can select the image to get into the Picture Tools tab and click the Rotate button.Here, we can set the image to Rotate Left ....

        Presentation 12.2K views
        Get started with functions and formulas

        Get started with functions and formulas

        10:29

        Get started with functions and formulas

        1. Reviewed the steps to insert functions in the table, there are 3 entrances to insert functions. You do not need to remember each function, just enter the first few letters, and the system will generate an automatic association.2. shared the 3 types of formula references, namely relative, absolute and mixed references.3. shared the function of how to reference data across worksheets or workbooks.

        Spreadsheet 12.0K views
        Superscript and subscript in WPS Presentation

        Superscript and subscript in WPS Presentation

        01:32

        Superscript and subscript in WPS Presentation

        In WPS free PowerPoint tutorial, learn how to use themes and background styles of preseatations, and do more to create standout presentations. All WPS Presentation tutorials are free for students, teachers, business users and more and can be downloaded free in Windows, PC, Mac, Linux, Android, and iOS devices. Chemical elements and mathematical formulas are sometimes needed in slides during the learning process. These coursewares cannot be separated from the superscript and subscript f....

        Presentation 11.9K views
        How to set slide transitions in WPS Presentation

        How to set slide transitions in WPS Presentation

        01:59

        How to set slide transitions in WPS Presentation

        Appropriate transitions make slides more professional and attractive. So how can we set transitions when creating a Presentation document? Click the slide that we want to add transition animations, and click Transitions.WPS Office provides us with multiple slide transitions, such as Morph, Wipe, Push, Cube, Airplane and so on.Having selected the desired transition, click Effect Options to set the orientation and transition mode of the animation.We can apply it with one click. If we th....

        Presentation 11.9K views
        How to Process data with Text to Columns

        How to Process data with Text to Columns

        07:31

        How to Process data with Text to Columns

        The main knowledge points of this lesson are the following 3 points1. Smart Split Columns can identify the contents and split them. There are four techniques for splitting columns based on text features: Delimiter, Text Type, Keyword, and Fixed Width. 2. Data formats can be standardized in addition to splitting columns. For example, numerical dates can be standardized dates, and numerical formats can be turned into text formats. 3. Ampersand operator and smart filling(Ctrl+E) can merg....

        Spreadsheet 11.7K views
        How can we set the margins of the table

        How can we set the margins of the table

        01:13

        How can we set the margins of the table

        When printing, in order to make the table meet the expected layout, we need to adjust the margins of the table.Margins are the white space between the contents of the spreadsheet and the edge of the printed page.Get into the Page Layout tab, and click Margins. Then we can see WPS has provided three default styles.Meanwhile, we can also choose Custom margins to adjust the margins more accurately.Click on the text box. Then the sample image in the middle will also provides a correspondin....

        Spreadsheet 11.6K views
        Prev 1 ... 34 35 ... 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