- All Tutorials
- Video Tutorials
- Quick Tutorials
439 Search results
Use VLOOKUP function to create dynamic charts03:44
Use VLOOKUP function to create dynamic charts
In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....
How to split sheets by content01:16
How to split sheets by content
When you want to split the content based on the specific categories in the sheet, are you still disassembling and reorganizing the content one by one? The Split Sheet feature can help you. Take this sheet as an example. If we want to split this sheet into three sheets based on class 1, class 2 and class 3, what should we do? We just need to click the Home tab and click Worksheet, then click the Split Sheet option, finally choose Split Sheets By Content. In the Split area box, we can ch....
How can we insert endnotes for Documents01:26
How can we insert endnotes for Documents
Endnotes usually appear at the end of the text and are mostly used to cite sources. When writing a paper, we often need to add endnotes to supplement the specific text. Then how can we insert an endnote for documents? · Step 1Place the mouse cursor where you want to insert the endnote. Click the References tab first, then click Settings, and finally click Footnote/(and)Endnote. · Step 2In the Footnote/(and)Endnote dialog box, we can set the Location according to our needs. As for this ....
How can we add footnotes to a Document01:22
How can we add footnotes to a Document
Footnotes usually appear at the bottom of the page. These are comments on certain content. When editing text, we often need to use footnotes to supplement the specific text. For all, easy our work with WPS Office Writer. So how can we insert a footnote to the document? · Step 1Place the mouse cursor where you want to insert the footnote. Click the References tab, then click Settings. And finally click footnote/ (and)endnote. · Step 2Set the Location according to our needs in the Footno....
A quick way to calculate sum, average, count, max, and min01:34
A quick way to calculate sum, average, count, max, and min
Here we have received a sheet on the Masks Sales in Single-Day Sheet from a supermarket. How can we quickly calculate the sum, average, maximum, and daily sales volume during the period from August 19th to 31st?We can use the AutoSum feature of the WPS Spreadsheet, rather than calculating all data one by one with a calculator, which would be a waste of time. Follow these step.1. Select the data area, click the AutoSum drop-down button in the Formulas tab.2. Find the Sum button and clic....
Use SUM function to quickly calculate the sum01:31
Use SUM function to quickly calculate the sum
The SUM function is commonly used when we process data with WPS Spreadsheet.Use the SUM function values in certain cells. Take this worksheet as an example. How can we sum the values in the yellow-filled cells? 1. Click the Insert Function button in the Formula tab.2. Insert the SUM function from the selection box.3. We can also click the SUM option in the AutoSum dropdown list in this step. Then, there will be a popup dialog titled Function Arguments, where Number means the range to r....
Format Cells Locked and Hidden01:21
Format Cells Locked and Hidden
When working with spreadsheets, what should we do if we want to hide and protect the formulas in the cells? Take this spreadsheet as an example, click the Review tab, then we can box the cells containing the formulas, right-click for the pop-up dialog, select Format Cells. Its shortcut key is Ctrl+1.Next, click Protection, check Locked and Hidden at the same time, and click OK. We sometimes find the Locked option in the dialog settings displaying as a black square, which represents unc....
TEXT formula in WPS Spreadsheet03:09
TEXT formula in WPS Spreadsheet
The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....