- All Tutorials
- Video Tutorials
- Quick Tutorials
218 Search results
How to insert audio in WPS Presentation01:36
How to insert audio in WPS Presentation
When giving a speech, we often need background music to set off the atmosphere. So how do we insert audio when making slides? Take this slide as an example, click the Insert tab above, and then click Audio. Here we can see Insert Audio, Link to Sound, Background Music and Link Background Music these four options. The difference between Audio and Background Music is that when we choose the Audio option, we can only hear the music when we play the slideshow where the music is inserted. B....
How can we insert endnotes for Documents01:26
How can we insert endnotes for Documents
Endnotes usually appear at the end of the text and are mostly used to cite sources. When writing a paper, we often need to add endnotes to supplement the specific text. Then how can we insert an endnote for documents? · Step 1Place the mouse cursor where you want to insert the endnote. Click the References tab first, then click Settings, and finally click Footnote/(and)Endnote. · Step 2In the Footnote/(and)Endnote dialog box, we can set the Location according to our needs. As for this ....
Format painter: tips for unifying format01:11
Format painter: tips for unifying format
In the process of making a WPS Presentation slide, we will unify the format of the text content for aesthetic purposes. Today, let's learn some tips for unifying the format quickly. Take this slide as an example. We can see that the font, font size, and color are different between each text. We can simply select the text box in the first line, and click the Home tab, then click the Format Painter button. Move the cursor to the second text box that needs a unified format, and click ....
Change paper orientation and size for printing01:20
Change paper orientation and size for printing
How can we change the paper orientation for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice. Take this word document as an example. 1. Get into the Page Layout tab, where we can find the Orientation and Size buttons.2. Click the Orientation button. Then, we can choose either Portrait or Landscape as the page orientation.3. Click the Size button. Then we can see several default styles of paper sizes provided by WPS Office. I....
The SUMPRODUCT function for quick calculation of total sales01:44
The SUMPRODUCT function for quick calculation of total sales
When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....
Create a countdown calendar current time and date02:14
Create a countdown calendar current time and date
WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....
Use COUNTIF function for conditional statistics01:32
Use COUNTIF function for conditional statistics
COUNTIF is a statistical function. It is often used to count the number of cells that meet the criteria. This function can not only count numbers and text but also can count expressions. So how can we use this function? The grammatical structure of the COUNTIF function is: COUNTIF(Range, Criteria)Range is the cell range that meets the criteria.Criteria are the conditions that need to be counted.Now we have a table that records everyone's afternoon tea order information. Column B co....
How to add a watermark02:14
How to add a watermark
WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....