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

        82 results for excelcnv exe parameters

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

        82 results for excelcnv exe parameters

        Use COUNT function to count the number of cells with parameters

        Use COUNT function to count the number of cells with parameters

        01:20

        Use COUNT function to count the number of cells with parameters

        When we do data statistics, we can use the COUNT function to count the number of cells containing values. Take this table as an example. We need to count the number of cities participating in donations. Click cell E6 and click Insert Function to find the COUNT function. Click the OK button, now a dialog box will pop up.Value 1 and Value 2 refer to the cell range to be statistically calculated. Only the numeric parameters are counted in this part of the range, that is to say, the number....

        Spreadsheet 27.3K views
        Use the ROUND function to round decimals quickly 

        Use the ROUND function to round decimals quickly 

        01:57

        Use the ROUND function to round decimals quickly 

        In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

        Spreadsheet 20.6K views
        Design the article layout in the Home-Settings

        Design the article layout in the Home-Settings

        03:26

        Design the article layout in the Home-Settings

        When designing the layout of the document, we often need to set the text font, paragraph settings, and heading style.In WPS Writer, these frequently used typesetting tools are collected in the Settings button under the Home tab. l Font settingTake this document as an example. We need to set the text format.Press the shortcut Ctrl+A to select the whole document, and click Font.We can change Font, Font style, Size, Color,and other parameters of the text.In the Effect area under the Font....

        Writer 12.4K views
        How to set Shape Effect in WPS Presentation

        How to set Shape Effect in WPS Presentation

        02:36

        How to set Shape Effect in WPS Presentation

        Have you ever felt that simply inserting WPS Office's own shape is slightly monotonous? Inserting poorly designed graphics deters us from standing out in work. Learning to use the Shape effect of WPS demonstration can make your slides more professional. Take this slide as an example, select the inserted graphic, click the Drawing Tools tab at the top, then click Shape Effects before clicking More Shape Effects. Next, I will demonstrate different effects one by one. 1. ShadowAdding ....

        Presentation 11.4K views
        How to set Picture Effect in WPS Presentation

        How to set Picture Effect in WPS Presentation

        02:24

        How to set Picture Effect in WPS Presentation

        You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.Pictures of WPS demonstration can make the slide more professional and appealing. We can also add effects to the pictures to make them cooler. Take this slide as an example, select the inserted pictures, click the Picture Tools tab at the top, then click Picture Effects before clicking More Picture Effects. Next, I will demonstrate different effects one by one. 1.ShadowAdding....

        Presentation 12.4K views
        Set Text  Effects: WordArt, Shadow, Reflection, Glow and 3-D Effects

        Set Text Effects: WordArt, Shadow, Reflection, Glow and 3-D Effects

        02:35

        Set Text Effects: WordArt, Shadow, Reflection, Glow and 3-D Effects

        In order to make the documents more fascinating, we will add effects to the text when we use WPS Writer to edit documents. So, how can we set the text effects? This video can help us to solve the problem and it can be also used in Microsoft Office Word and Openoffice. Take this document as an example, select the text content, click on the upper taskbar Home - and Text Effects. Here, we can add Wordart, Shadow, Reflection, Grow. When we insert a text box in the document and enter the te....

        Writer 21.4K views
        How to set the text effect of slides

        How to set the text effect of slides

        02:53

        How to set the text effect of slides

        When we use WPS presentation to make slides, text effects can be added to make the document more aesthetic and better-designed. So how can we set text effect?Take this slide as an example, select the text content, click the Text Tools tab at the top, then click Text Effects and select More Text Effects. Next, I will demonstrate different effects one by one. · 1. ShadowAdding a shadow effect to the text can make it more stereoscopic.Select the text and click SHADOW, where you can choose....

        Presentation 8.9K 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
        Prev 1 2 3 ... 10 11 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