There are 8 free training skills of how to use office suite for WPS
How to Duplicate a Page in Word Document with Formatting
How to duplicate a page in word? Page is in a word created for writing words on the document and edited or published somewhere online or use in print form. Most of the time it’s important to duplicate a page in word without having any chance of failure. There are a lot of beginners who don’t have any idea how to duplicate a page in word and try different things on their own that cost them to lose their page. In short, read the rest of the article and get a complete unders....
How to show presenter view during slide shows
· Option 1: 1. Open the document in WPS Presentation. 2. Get into the Slide Show tab → click Show presenter view → OK 3. Click From Beginning or From Current Show to start the slide shows. If you have the second monitor, you will see the interface in the presenter’s screen (as is shown below). · Option 2: WPS Presentation also sets a quick entry to turn on/off the mode of Presenter View. 1. We just need to check/uncheck the Use Presenter View box in the Slide Show tab. 2. Start the s....
Numbering items in a worksheet
· Option 1: 1. Open the spreadsheet with WPS Office. 2. Enter the beginning number in the first cell where we want to start the numbering. In the example below, the numbering will start from the number “1”.3. Select the cell range to be filled. 4. Click the Fill button again → choose series → change the settings as demonstrated below a. Series in: choose “Columns” b. Type: choose “Linear” c. Step value: enter “1” (from which to start the numbering)d. Stop value: enter “14” (where the ....
Top ten vendor management excel template download
Top Ten Vendor Management Excel Template A vendor management excel template is a great way to keep track of all your vendors and their contact information. This is especially helpful if you are managing a business and need to keep track of your vendors for legal purposes. The excel spreadsheet can be set up to include all the relevant information such as name, contact number, address, website, email, and phone number. It can also include information such as the date the vendor was firs....
10 best monthly gantt chart templates for Excel free download
10 best monthly Gantt Chart excel template A Gantt chart's two-axes structure makes it an excellent tool for connecting tasks and dates. Once an assignment is created and its start and end dates are specified, you receive one of the best-visualized timelines that displays important information quickly. While showing dates and deadlines is one of Gantt charts' strengths, its advantages go well beyond that. Monthly Gantt chart excel template is a must have for a business. There....
How to insert text watermark in WPS Writer
1. Open the file in WPS Writer.2. Click the Insert tab → and then select the Watermark button.3. Click Insert Watermark in the drop-down menu. Then a Watermark dialog box will popup. 4. Here, check Text watermark in the Watermark setup area.5. We may edit the content of the watermark. We can also edit its font, size, color, etc..6. After settings, click OK. This skill could also be used in Microsoft Office Word and OpenOffice.
How to Turn Off Autocorrect
The Autocorrect function in WPS Office can correct spelling and other mistakes when using it to edit documents.How can we turn off Autocorrect when we do not need it? 1. Click Menu on the upper-left corner, and choose Options.2. Get into the Edit tab in the Options dialog. 3. Change the relevant settings in the category of AutoCheck, and click OK to apply the settings. Here is an example of canceling the option of Capitalize first letter of sentences. Before turning off Autocorrect - &....
How to remove duplicates in Excel
· Highlight Duplicates1. Open the Excel file and select the table area.2. Click the Data tab → the Highlight Duplicates drop-down button → the Set option.3. Then, the Highlight Duplicate dialog will pop up. We click the OK button.4. Now, the repeated contents in cells are set in orange background. · Remove Duplicates1. Select the table area again.2. Go to the Data tab, click the Highlight Duplicates drop-down button, and select the Remove Duplicates option.3. Then, the Remove Duplicat....