2922 results for All
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
2922 results for All
Efficient statistics with statistical functions
01:48Efficient 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....
Create 100 recruitment notices in batches
02:33Create 100 recruitment notices in batches
Here are one hundred profiles of new employees, which need to be made into recruitment notices. If you are the HR of this company, how would you do that? The Mail Merge function allows you to handle these 100 notices easily. Take this document as an example. We need to input employees' names, entry time, department, position, and salary.1. Open the table that contains the information of new employees. 2. The information of the five columns will be inserted as Merge Fields. For conv....
Unique features in Student Tools
01:42Unique features in Student Tools
Student Tools is a collection of functions in WPS Presentation specially optimized for student user groups, which is not available in any other office software on the market. Student Tools, on the far right of the toolbar, collects the features that students use most frequently to save their time to toggle back and forth between the tabs. There are three common views and two common masters collected from the View tab, which can meet the needs of most reading, reviewing and presentatio....
More features in Reading Layout
00:45More features in Reading Layout
Faced with huge amounts of data, we find it difficult to locate the selected cell or cells range. At this point, Reading the Layout can help a lot. Microsoft Excel doesn't support reading mode without plug-ins, while WPS Spreadsheets has the function of Reading Layout. Take this table as an example. 1. Click the View tab, and click the Reading Layout button to select a preferred color.2. When you click a cell, the row and column it lies in are highlighted. You can easily find the s....
Apply Slide Masters Quickly
00:54Apply Slide Masters Quickly
We may sometimes need to apply a pre-set slide master to the current page when editing a slide.Do you know how to make it? Take this slide as an example. Click Design and then click Edit Slide Master, and we can see there are three different slide masters. So how can we apply "a master with the WPS Academy logo" to the current page? First, click Design, and click Involved Template.In the pop-up dialog box, we can select the desired slide master. And we can also select Apply Current or....
How to make conference table cards in batches
02:58How to make conference table cards in batches
Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....
Conditional Formatting for data virtualization
01:23Conditional Formatting for data virtualization
Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....
How to print hidden slides in WPS Presentation
00:48How to print hidden slides in WPS Presentation
When projecting slides with WPS Presentation, we sometimes hide some of the slides for better projection effect.The hidden slides cannot be projected or printed. So how can we print them without changing their hidden state?Take this slide as an example. In the thumbnail on the left of the screen, you can see a small delete icon at the slide page number, indicating the slide is hidden.You need to click the Menu button in the upper-left corner and click Print.Click the check box Use the ....