1616 results for how to use goal seek
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
1616 results for how to use goal seek
How to use the automatic numbering
02:11How to use the automatic numbering
We often use the automatic numbering function when editing documents, which can enrich the structure of the document and make it easier to read. How can we use this function? Take this catalog as an example. Select the content that needs to be numbered, click the Numbering drop-down button on the Home tab, and choose the style we want. To get more styles, we can click More Numbering on the Numbering drop-down button. A dialog box will pop up at this time. After selecting any of the st....
How to use the FILTER Function
03:15How to use the FILTER Function
Lookup and Reference functions are frequently used for processing data in a table. Today we will learn how to use the FILTER Function to filter data.This function can be used to filter a range of data based on the criteria that you specify.· Primary usage of the Filter functionTake this table as an example. Suppose we want to get the list of class 1, Select G3:G15, this is the cell range we want the result to return, so don't just select cell G3.Enter the formula: =FILTER in the ce....
How to use the VLOOKUP function
04:29How to use the VLOOKUP function
The clever use of VLOOKUP function can help us quickly find the relevant results. It is usually used to check and match the data between multiple tables. Take this table as an example. In the table on the right, we know the "Number" and "Name" of the "Group1" members, so we are looking for the "Chemistry" scores of the members.1. Click cell J3, and click "Insert Function".2.Click "Lookup and Reference" in "Category", and choose "VLOOKUP" function.3.In the popup dialog box, we can see t....
How to use the screenshot tool in WPS Writer
01:29How to use the screenshot tool in WPS Writer
Many people don't know how to take screenshots when using WPS Writer. Let's take a look at how to use the WPS screenshot tool. First, click the Insert tab to find the Screenshot button. And in the Screenshot drop-down list, we can choose the screenshots of areas with different shapes. They are respectively: Rectangle screenshot, Oval screenshot, Rounded rectangle screenshot and Polygon screenshot. We can click Screenshot to take a screenshot within the WPS Writer interface. Its....
How to use the Quick Parts function in WPS Writer
02:20How to use the Quick Parts function in WPS Writer
Do you know how to skillfully use the Quick Parts function to improve efficiency instead of inputting tedious content repeatedly?In our daily life, the Quick Parts function is mainly used in two ways. · Input commonly used text quickly.The Quick Parts function is to save and reuse specified parts of the text, which act like building blocks. When we need to input the same thing repeatedly, we can build such building blocks in the document for quick use, that is, to create quick parts. T....
How to use tabs to align text quickly in WPS Writer
01:41How to use tabs to align text quickly in WPS Writer
The function of Tabs in WPS Writer allows us to adjust the position of the text when typing by setting the horizontal Ruler, in order to align the text and symbols. And, it could be also used in Microsoft Office Word and Openoffice. How can we use the function of Tabs? If the ruler is not displayed in the document, we can click the View tab and check Ruler. The number on the Ruler represents the number of characters, and the page width on the current page is 41 characters width. Take t....
How to use the draw table tool
01:29How to use the draw table tool
WPS Writer's draw table feature allows us to use the mouse to draw custom tables directly in the document. So, how can we do it? Click this table in the document. Click the Table Tools and the Draw Table button, and then the mouse cursor will become a brush, then we can draw tables in the document as needed. If we now want to draw a 3X4 table, hold down the left button on the mouse. At this point, the table dotted lines will appear on the page, and a floating window will appear in ....
How to use the document comparison function
01:40How to use the document comparison function
After modifying the document, we can compare it with the original document and generate the revised document if we want to view the modification trace. Next, I will show you how to use the comparison function through a case. Take "Document 2" as an example. Click the Review tab and the Compare drop-down button, and choose Compare. Then, a dialog box will pop up. In the Original document box, select "Document 1". In the Revised document box, select "Document 2". In the Label changes wit....