WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....

An official document usually has additional information such as company name, date, page number, etc. at the top or bottom. This specific area is called Header and Footer. If you want to add a header and footer to a PDF file, do you know how to set it? Take this document as an example. Click the Insert tab, and choose Add Header and Footer. In the pop-up dialog box, we can add header and footer, set margins and page apply range. We insert the date in the middle of the footer, and there....

We can use the CONCAT function to merge the contents of multiple cells.This function is mainly applied to merge character strings within a certain cell range or in different cells. Now we take a simple case as an example. We want to merge the domain names to form a complete website address.1. Click Formulas, click Insert Function, input "CONCAT" in the dialog, and click OK.2. Since the cells to be combined are continuous, we input "A2:D2" in Text 1, click OK, and drag the cell to fill ....

Arrange tools in WPS Presentation allow users to adjust the object layout, group objects, and rotate objects. The Arrange tools make it easier to manipulate images, shapes, and other elements. Usually, the latest created object is placed at the front of a slide.If we want to change the object layouts, here are the steps.1. Choose an object.2. Go to Home and click Arrange. 3. Choose Bring to Front in the drop-down menu. Another option to realize it is shown below.1. Select the object.2.....

When using WPS Presentation to create a presentation, sometimes we need to insert shapes to assist with the presentation and beautify the slides. How can we adjust the outline for an inserted shape? Left-click the shape, and get into the Drawing Tools tab. Then, click the Shape Outline dropdown button to change the settings of the shape outline, including colors, thickness, and outline style. To change the outline color, we can either choose one from the default styles provided by WPS ....

When using WPS Presentation to create a presentation, sometimes we need to insert shapes to assist with the presentation and beautify the slides. We will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. How can we change the design of shape fill and outline? Left-click the inserted shape, and get into the Drawing Tools tab. Then click the Shape Fill button. There are two options. One is to choose the default style provided by WPS Office,....

You can start from three aspects: 1.select the correct color scheme. We can download color schemes from color matching websites.2.we can choose suitable icons to fill in the data series and make it interesting and vivid.3. we can achieve special effects by adjusting "Series Overlap" and create needle tube charts and mountain charts. We can click "Smoothed Line" to smooth the lines and adjust "LINE" and "MARKER" to enrich a line chart. After you've beautified a chart, right-click i....

Shapes inserted in slides could make a presentation more attractive. How can we insert shapes in a presentation document? First, click the Insert tab, and click the Shapes button. In the selection list, we can see that there are different categories, namely Lines, Rectangles, and Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners, Callouts, and an Action button. Here we take the shape of Heart, which could be found in the Basic Shapes drop-down list. Insert it by....