- All Tutorials
- Video Tutorials
- Quick Tutorials
46 Search results
How to add gridlines and guides in WPS Presentation01:31
How to add gridlines and guides in WPS Presentation
When we make a slideshow, in order to achieve a good typographic effect, we generally add guides and gridlines to the page. Take this slide as an example. It is difficult for us to center the title without smart assisted alignment. At this point, we only need to click the View tab above, then click the Grid and Guides button, finally check Display smart guides on screen. With the help of smart guides, centering the title becomes simple. Learn to use guides, and we can achieve more type....
Use Date function to convert date format01:51
Use Date function to convert date format
We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....
How to create a scatter chart in WPS Spreadsheet02:53
How to create a scatter chart in WPS Spreadsheet
A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....
How to use Slide Master in WPS Presentation03:28
How to use Slide Master in WPS Presentation
WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Slide Master can be the perfect fit for improving work productivity to uniform the fonts, background, and company logos when creating new slides. Without using Slide Master, every click with New Slide means creating a new blank slide with non-uniform formats. With the Slide Master function, we only need to set the background and font of ....
How to set the header row across pages00:50
How to set the header row across pages
When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....
How to quickly update the table of contents01:10
How to quickly update the table of contents
How can we quickly update the table of contents when we need to modify the title content, location, and page number after setting up the table of contents? Take this document as an example. We found that the current page number is incorrect, so we modified the page number. At this time, the page numbers in the table of contents are not updated. And now we click the table of contents, and click the Update TOC button of the References tab. In the pop-up dialog, we choose Update page numb....
Create simple and intuitive mini charts03:10
Create simple and intuitive mini charts
The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....
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....