813 results for see windows 8 1 product key
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
813 results for see windows 8 1 product key
How to start auto numbering from 1
01:45How to start auto numbering from 1
Sometimes the paragraphs must be automatically numbered to make the text more logically acceptable.For example, we are typesetting the paper. And according to the typesetting requirements, the heading doesn't need to be numbered, while the body part does, and each numbering starts from 1. How can we operate?1. Let's number the body part first. Hold down the Ctrl key, and press the left mouse button to select discontinuous body parts. Then click Home and Numbering. We can see th....
Custom cell formats
03:48Custom cell formats
When using WPS Spreadsheet to process data, we can customize cell format with codes. In this video, you will learn about several practical codes for custom cell format. Take the worksheet here as an example. Select Column E, right-click on it and choose Format Cells in the menu. You can also use the shortcut key Ctrl+1 to pop up the dialog. Get into the tab of "Custom". Then we can see "m/d/yyyy" in the input box. Here "m", "d", and "yyyy"are respectively placeholders for month, day, a....
Learn pivot table from the beginning
04:27Learn pivot table from the beginning
A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....
Why error message #REF! occurs and how to solve it
03:18Why error message #REF! occurs and how to solve it
The error message "#REF" is common in table calculations. In general, there are mainly two causes. First, the referenced cells in the formula are deleted or replaced by other cells. Second, the formula references invalid cell ranges or values. Then how can we solve these problems? · The referenced cells in the formula are deleted or replaced by other cells.o The referenced cells in the formula are deleted.Take this table as an example. 1. To calculate the total sales of computers t....
More features in AutoFilter
02:39More features in AutoFilter
When dealing with large amounts of table data, we often need to temporarily hide some of them with AutoFilter to focus on those we need. Here we will compare the AutoFilter function of WPS Spreadsheets and Microsoft Excel. In general, both of them support filtering data according to numbers, text, color and so on.WPS Spreadsheets has three special advantages. Let's go through them one by one.First, Click the Home tab, and click the AutoFilter drop-down button to turn on the AutoFil....
Elementary arithmetic functions in WPS Spreadsheet
02:50Elementary arithmetic functions in WPS Spreadsheet
Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click Insert Function. So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter "= A2 + B2" in cell C2, press the Enter ke....
Most-used Statistical Functions
11:28Most-used Statistical Functions
1. The SUMIF function can be used for single condition summation; according to the use of different ways, the SUMPRODUCT function can be the product of data, but also the product of the sum.2. introduced the use of the AVERAGE function, you can set a single condition to find the average, you can also set multiple conditions to find the average.3. to help you find the difference between "COUNTA", "COUNTBLANK", "COUNTIF" and "COUNTIFS
How to use Select feature in WPS Presentation
02:04How to use Select feature in WPS Presentation
A slide with large information contains a large number of elements. Therefore, we are likely to make some mistakes when editing slides. The Select feature in WPS Presentation can help us avoid mistakes. Take this document as an example. Click the Home tab and click the Select drop-down button. Here we can see three options: Select All, Select Audio, and Select Pane. Then we will get to know them one by one. · Select All1. Click the Select drop-down button and click Select All to select....