WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • propresenter 7

    1471 results for propresenter 7

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

    1471 results for propresenter 7

    The 7 Best Online PDF editor features in WPS Office

    Welcome to WPS Official Academy to check the contents of how to use PDF editor in WPS Office. You are sure to master the skills in editing PDF files after reading this tutorial! The Edit tab collects all the necessary features you may need when editing PDF files. Are your curious about it? Let’s have a look now. · Tutorials of how to use PDF Editor in WPS OfficeFirst of all, open your PDF file in WPS Office and head to the Edit tab. Some buttons have a "V" icon in the upper right corne....

    pdf PDF 3.3K views
    How to split a workbook into multiple files

    How to split a workbook into multiple files

    01:39

    How to split a workbook into multiple files

    We often need use the Split Book function so that we can split a workbook into multiple files at work. Take this workbook as an example, which is a table of goods sales from January to September. Now we want to split it into three workbook files. 1. Head to the Home tab, click the Split Sheet drop-down button,and select Split Book.2. In the pop-up dialog, the current file is checked by default, and you can also split other files by clicking Add more files.3. When finished, click Next t....

    Spreadsheet 1.7K views
    Set the date format cells

    Set the date format cells

    01:40

    Set the date format cells

    In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

    Spreadsheet 11.8K views

    The WEEKDAY Function in EXCEL

    · Description:Weekday Function can return a number from 1 to 7 identifying the day of the week of a date. In today’s tutorial, we will also learn how to combine WEEKDAY with nested IF&OR function. · Syntax:(Serial_number, Return_type) · Arguments:Serial_number: The number that represents a date.Return_type: You can enter a number here: 1: Returns a number from 1 to 7, meaning start from Sunday and end at Saturday. It’s the default if omitted.2: Returns a number from 1 to 7, meaning st....

    xls Spreadsheet 3.5K views
    Use slash header to show the title name

    Use slash header to show the title name

    01:25

    Use slash header to show the title name

    Take this table as an example. When creating a table, we often need to use the Slash Header to display the title name, so how can we make a Slash Header?1. Select cell A1, right-click.2. Then select Format Cells in the popup shortcut menu. We can also use the shortcut key Ctrl+1.3. Then select Border in the Format Cells dialog box.4. Now select the slash shape icon in the border preview area, and click OK. 5. Now enter Subject in cell A1.6. Press Alt+Enter to insert a line break, and t....

    Spreadsheet 1.3K views
    Text direction in WPS Presentation

    Text direction in WPS Presentation

    02:34

    Text direction in WPS Presentation

    When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....

    Presentation 1.8K views
    The INDEX function

    The INDEX function

    03:50

    The INDEX function

    The INDEX function can look up a value regarding its row and column numbers.There are two forms of the INDEX function, the Array form and the Reference form. · One: Array formWe'll use the Array form to return the value located in the seventh row and the fourth column.First, select cell J6. Next, click Formulas and then Insert Function to insert the INDEX function. The function syntax:INDEX(array,row_num,column_num)The first parameter, 'Array', refers to the array for valu....

    Spreadsheet 2.9K 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 1.5K views
    Prev 1 2 3 ... 183 184 Next
    WPS Academy
    Products
    Partners