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

        2331 results for how to repeat a formula in excel

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

        2331 results for how to repeat a formula in excel

        How to use the formula function of table in WPS Writer

        How to use the formula function of table in WPS Writer

        02:38

        How to use the formula function of table in WPS Writer

        You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore. Take this table as an example. Assume that we want to count how many Expense there are in the whole table. We can use the COUNT function to count the number of data in the table.Tips: The COUNT function in WPS can only be applied in counting number data, while the empty cells, logical value....

        Writer 9.1K views
        How to create a Form in spreadsheet

        How to create a Form in spreadsheet

        01:26

        How to create a Form in spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

        Spreadsheet 13.1K views
        How to add a stamp in a PDF file

        How to add a stamp in a PDF file

        01:42

        How to add a stamp in a PDF file

        We use powerful PDF in our daily life nearly every day.In our daily work and study, we can insert a stamp in the PDF file to indicate that the file has already been reviewed.Now we are going to introduce the Stamp WPS Premium feature.Click the Comment tab and then click Stamp. Here, WPS has provided us with a large variety of presets. We can click the needed stamp style and place it in the appropriate area of the page. We can also customize the stamp. Click Click to Add, then the Add S....

        PDF 9.2K views
        How to create a scatter chart in WPS Spreadsheet

        How to create a scatter chart in WPS Spreadsheet

        02:53

        How to create a scatter chart in WPS Spreadsheet

        A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....

        Spreadsheet 10.7K views
        How to insert shapes in a worksheet

        How to insert shapes in a worksheet

        01:20

        How to insert shapes in a worksheet

        We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

        Spreadsheet 10.9K views
        How to insert a signature in a PDF file

        How to insert a signature in a PDF file

        02:16

        How to insert a signature in a PDF file

        We use powerful PDF in our daily life nearly everyday. WPS pdf converter is easy and free for people to use.Nowadays, electronic information technology is developing rapidly. Many companies have adopted paperless contracts, and we often need to sign a contract or agreement on an electronic device. Now we have received a PDF contract from another company, and we need to sign it. So how can we insert a signature in the PDF file?1. Click the Insert tab, and then click the Sign drop-down m....

        PDF 27.8K views
        How to set a Drop Cap in WPS Writer 

        How to set a Drop Cap in WPS Writer 

        01:28

        How to set a Drop Cap in WPS Writer 

        When we edit a document with WPS Writer, if we want to highlight the separation of paragraphs, we can set a Drop Cap effect in the paragraph. In this way, the first letter of the paragraph is a large capital letter and it occupies multiple lines, making the paragraph separation more noticeable. · 1. DroppedTake the first paragraph as an example. Select this paragraph. Click the Insert tab and the Drop Cap button, then a dialog will pop up. In the Position area, we can choose None, Drop....

        Writer 15.5K views
        How to carry out simple calculations in a table

        How to carry out simple calculations in a table

        09:00

        How to carry out simple calculations in a table

        We mainly study two methods of targeted search, Go to and Find, which are the same in objectives to find the desired cells, and different in search mechanism. Specifically speaking, Go to plays its role based on the cell's own attributes, such as constants, formulas, and blanks. While Find is more flexibly used to set some keywords and cell formats.In addition to exact search, we can use the two wildcards, * and ?, to apply the approximate lookup to the text.

        Spreadsheet 27.1K views
        Prev 1 2 3 ... 291 292 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