How to save and quickly use the local templates in WPS Presentation

When we use WPS Presentation, in order to save time, we often use templates.Today, I will teach you two ways to quickly use the templates.1. We can save the beautiful slides we've made as templates, which can be shared with others or reused by ourselves. Take this slide as an example. We have edited it in advance using the Master Slides feature. If we need to save it as a template to share with others or use it again, just click Menu and click Save as.Select WPS Presentation Templa....

How to apply accounting number format in WPS Spreadsheet

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

How to quickly set the slide layout

When making presentation slides, how can we quickly set the layout of slides?Take these slides as an example. The overall layout is not aesthetically pleasing. Also, the placement of text and pictures is relatively random. Click the Home tab, and then click Layout. Here, WPS Office has provided us with a large variety of layout styles.Just click Tow Content, then the layout of the slideshow will immediately become neat and beautiful. Next, we can adjust the size and position of each co....

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

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

How to set the picture outline in WPS Presentation

When creating a presentation file, inserting too many pictures can easily lead to messy typesetting. Properly adding outlines to pictures can highlight key pictures and make the layout more logical and the slides more beautiful. Select the picture, click the Picture Tools tab, and then click the Picture Outline drop-down button. Here, we can set the Colors, Weight, and Dashes of the Picture Outline with just one click. If we want to set the Picture Outline further, we can click the Mor....

How to insert pictures in WPS Presentation

When using WPS Presentation, we can insert pictures to make the slides more beautiful and help others better understand the text content. So how can we insert and set pictures in slides? Take this slide as an example.1. Click the Insert tab, and then click Picture.2. In the popup window, click From File.3. Select the picture we want to insert and click Open. As we can see, the picture is inserted into the slides now. After inserting the picture, we can see that there are eight small do....

How to set the background in WPS Presentation

Do you think the slideshow with a blank background is a little boring? If you want to make the slideshow look more beautiful, we can try to use the Background function in WPS Presentation. First, we click the Design tab above and then click the Background drop-down menu. Here, you can choose your favorite gradient fill preset. If we want to make more settings for the background, we can click Background. In the Object Formatting task pane that pops up on the right side of the screen, we....