- All Tutorials
- Video Tutorials
- Quick Tutorials
352 Search results
How to enter a number starting with 0 in the Spreadsheet01:38
How to enter a number starting with 0 in the Spreadsheet
The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....
Use COUNT function to count the number of cells with parameters01:20
Use COUNT function to count the number of cells with parameters
When we do data statistics, we can use the COUNT function to count the number of cells containing values. Take this table as an example. We need to count the number of cities participating in donations. Click cell E6 and click Insert Function to find the COUNT function. Click the OK button, now a dialog box will pop up.Value 1 and Value 2 refer to the cell range to be statistically calculated. Only the numeric parameters are counted in this part of the range, that is to say, the number....
Create an area chart to display data trends02:00
Create an area chart to display data trends
Do you know how to make an ordinary line chart more special? Today we are going to show you how to make a line chart with fill effects, that is, an area chart.Take this table as an example. This is the dynamic price-earnings ratio data of a certain country over a period of time. It is difficult for us to see the difference between the data. Therefore, we need to use an area chart to show the changes in the dynamic price-earnings ratio index.1. First, we click the Insert tab.2. Click th....
Efficient statistics with statistical functions01:48
Efficient statistics with statistical functions
COUNT function and COUNTIF function are used very frequently in statistical functions. Today I'll talk about how to use these two functions. · 1. COUNT functionTake this donation list as an example. We need to count the number of cities with donation amounts. At this point, we can use COUNT function. Click cell E6, enter "=COUNT(C3-C75)," and press the Enter key to get the result. It is important to note that the COUNT function can only count the statistical cells. The forms like b....
Use SUMIFS function with multiple criteria02:27
Use SUMIFS function with multiple criteria
In our work, we often need to filter through multiple criteria for statistics. At this time, we can use the SUMIFS function. The grammatical structure of the SUMIFS function is: “SUMIFS（Sum range, Range1, Criteria 1, Range2, Criteria2...）”Using the data in this table as an example, we want to calculate The total amount of imported fruits from South Korea greater than $50,000. There are two conditions. One is South Korea, and the other is the amount>$50,000.First, after clicking cell E5....
How can we insert page number into a Document01:37
How can we insert page number into a Document
In the process of document typesetting, adding page numbers can help us quickly retrieve and locate. So, how can we insert the page number into a document? Take this document as an example. Click the Insert tab first, then click the Page Number drop-down button. In the Built-in Style, we can choose the style according to demand. If there is no suitable page style, we can click the Insert Page Number button to set up. In the pop-up Insert Page Number dialog box interface, we can set the....
Quickly fill cells with multiple methods04:07
Quickly fill cells with multiple methods
As for beginners, they usually enter data manually when they first use Spreadsheet. It is time-consuming and also easy to cause mistakes. So today we are going to learn a few tips to help you quickly fill in the data in the worksheet.· Fill contents down into the tableTake this table as an example, select the area that needs to be filled, first click the Home tab, then click the Fill button-and then select Fill down. (Notes: The shortcut key is Ctrl+D.) · Fill contents right into the t....
How to fill cells with pure colors, gradient colors, and patterns01:57
How to fill cells with pure colors, gradient colors, and patterns
When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. To do this, we can fill the cell with background color and pattern.Take this table as an example. 1. If we want to fill the B3:G3 cell with color, select this area first.2. Click the Home tab above.3. Then click Settings.4. And finally click Cells. Or we can use the shortcut key Ctrl+1 to open the Formats Cells dialog box. · Pure colorClick Patterns, then we can choose a pure color to....