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....

The Presentation Tools button serves as a quick and convenient assistant in WPS Presentation, helping us to set the slides easily in a short time. So how can we use Presentation Tools? Click the Design tab on the top, and click the Presentation Tools drop-down button. We can see four options here: Replace Fonts, Batch Font Settings, Customize Text Formats and Insert Picture to Multiple Slides. · Replace Fonts:The Replace Fonts option helps us to replace one font with another throughout....

When we use PPT for data reporting, we often insert charts to help us further illustrate.Take this PPT file as an example. So, how can we insert a chart in the slide? Click the Insert tab above, and then click Chart.In the pop-up dialog, we can select many different types of charts.The double-layered doughnut chart provides an intuitive comparison of the changes in the sales data proportion over the past two years. This video takes Doughnut as an example. Click Pie and click Doughnut. ....

When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....

Have you ever experienced the situation of forgetting the scripts during a presentation? Speaker notes function in WPS Academy might help you to solve it. You will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. When using WPS Presentation for a presentation, we can add speaker notes in the PowerPoint to provide tips during the slides show. The speaker notes will be present on the speaker's screen, while audiences can only watch the s....

Presentation Tools is a feature for WPS Office that can quickly modify the font and size of slide texts, and insert pictures to multiple slides in batches. We can see four options here: Replace Fonts, Batch Font Settings, Customize Text Formats and Insert Picture to Multiple Slides. Microsoft PowerPoint has similar functions as well, such as Replace Font, New Photo Album and Edit Master Slide. However, their entry points are scattered which means the users may need to switch back and f....

When doing a presentation, how can we hide certain slides during the slide show while keeping them in the document? This video will show you the Hide Slide function in WPS Presentation. Suppose that we need to hide the second slide, select the preview of it, get into the Slide Show tab, and click Hide Slide. Then we can see the corresponding slide preview greyed out, with a Hide slide icon presenting on the upper-left corner of it. In this way, when we click From Current Slide to start....

In WPS free PowerPoint tutorial, learn how to use themes and background styles of preseatations, and do more to create standout presentations. All WPS Presentation tutorials are free for students, teachers, business users and more and can be downloaded free in Windows, PC, Mac, Linux, Android, and iOS devices. Chemical elements and mathematical formulas are sometimes needed in slides during the learning process. These coursewares cannot be separated from the superscript and subscript f....