- All Tutorials
- Video Tutorials
- Quick Tutorials
5 Search results
Get to know the cell widget02:38
Get to know the cell widget
Today we are going to show you how to use the cell widget in WPS Spreadsheet. The functions of it are very practical useful. Let's learn this feature together! · Convert Text to Number In WPS Spreadsheet, the text formatting is quite special. 1. It cannot be directly converted to other formats. 2. The text formatting is aligned to the left, and other formattings are aligned to the right. Take this table as an example. We now need to change the date in the table to another type. By ....
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 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....
Use the DATEDIF function to calculate the intervals of dates03:12
Use the DATEDIF function to calculate the intervals of dates
The DATEDIF function is mainly used to calculate days, months, or years between two dates. Now we are going to use this table to show you the usage of this function. This table records the entry date of the company’s employees. Now we want to calculate the employee’s year of service. We can first click cell C2 and then click Insert Function. Insert DATEDIF in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up.Start dat....
Learn pivot table from the beginning04:27
Learn 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....