WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to refresh excel

    3249 results for how to refresh excel

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

    3249 results for how to refresh excel

    How to convert Excel to PDF

    How to convert Excel to PDF

    02:50

    How to convert Excel to PDF

    PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

    Spreadsheet 6.1K views
    Refresh pivotTable and change data source

    Refresh pivotTable and change data source

    01:28

    Refresh pivotTable and change data source

    If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....

    Spreadsheet 3.0K views
    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 1.5K views

    How to refresh the pivot table in WPS Spreadsheet

    1. Use WPS Office to open the spreadsheet.2. Click the Data tab → and then click the Refresh All button. This skill could also be used in Microsoft Office Excel and OpenOffice.

    xls Spreadsheet 4.3K views
    How to make a simple lottery through the RANDBETWEEN Function?

    How to make a simple lottery through the RANDBETWEEN Function?

    02:02

    How to make a simple lottery through the RANDBETWEEN Function?

    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 the basic usage of the RANDBETWEEN function, which can be used to return a random integer between two specified numbers. This function is relatively simple. For example, if I want to randomly generate an integer between 1 and 100, I only need to enter = RANDBETWEEN(1,100) in the cell and press the Enter key. What should I do if I wa....

    Spreadsheet 3.2K views
    How to Add Caption

    How to Add Caption

    01:41

    How to Add Caption

    We can use the caption feature to number and annotate images, charts and other contents referenced in a document. So how do we use this feature? We take the image in this document as an example. Select the image, click References, and then click Caption to get a pop-up dialog.Click the Label pull-down to select the label you want. If none is available, you can click New Label to customize a label such as a Picture.Then select the Position of the caption. Click the Numbering button, you....

    Writer 2.6K views
    How to add watermarks to a table

    How to add watermarks to a table

    02:19

    How to add watermarks to a table

    Watermarking a document can prevent it from being misused by others; the good news is that watermarks can be added to an excel table.We'll look at two different ways to add watermarks to your table today.The first approach is merely adding a single watermark, which can be utilized for a single-page table.Click Insert, and then click WordArt. Select a style to be inserted, and input the watermark content.The font style can be changed further by clicking Setting in Text Tools. You ca....

    Spreadsheet 2.3K views
    How to insert Check Box

    How to insert Check Box

    02:45

    How to insert Check Box

    When creating tables, we often need to insert check boxes to check the information quickly and check multiple options at once. Today we'll learn how to insert check boxes. Take this Registration of Selected Courses table as an example. 1. Go to the Insert tab, click the Forms drop-down button, and select the Check box. 2. The cursor becomes the shape of a cross, and you can insert a check box by dragging the mouse.3. Input text in the check box, such as "French."Then the check box ....

    Spreadsheet 4.4K views
    Prev 1 2 3 ... 406 407 Next
    WPS Academy
    Products
    Partners