How to edit PPT in WPS Office Presentation

A good speech can hardly be divorced from a concise and professional PPT, but as you know, it’s a great lesson to make PPT slides. This free tutorial provided by WPS Academy is aimed at helping you master how to edit PPT in WPS Office. · Basic skills in editing PPT in WPS Office.o How to insert and set a text boxWhen using WPS Presentation, we often need to edit text content in the text box. So how can we insert a text box? Click the following link to watch the video tutorial: How to i....

How to use the data validation feature

We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Since this feature is quite complicated, we only briefly introduce some basic usages here. If you want to learn more, you may feel free to watch more related videos in our WPS Academy.First, select the cell range where we want to fill data, and click the Data tab → the Validation button in the upper menu bar. At this time, the data validation box will pop up. We can s....

The 7 Best Online PDF editor features in WPS Office

Welcome to WPS Official Academy to check the contents of how to use PDF editor in WPS Office. You are sure to master the skills in editing PDF files after reading this tutorial! The Edit tab collects all the necessary features you may need when editing PDF files.

How to calculate top 10 in WPS Office Excel

In this article, you will know how to calculate top 10 in excel with simple steps as following: Here we take a scholarship table as an example. Suppose we want to calculate the top 10 scholarships. · Find out the top 10 values in WPS SpreadsheetHere are two methods to find out the top 10 values in WPS Spreadsheet.o Method 1: We can use the Conditional Formatting function to highlight the top 10 values.1. Select the cell range, click the Conditional Formatting drop-down button in the H....

How to create infographics in WPS Office Excel

In this quick tutorial, you will master how to create an infographic in excel with only three simple steps as follows. Now let’s start to create an infographic step by step.· Step 1: Input all the content of the infographic in WPS SpreadsheetThink about the layout and the needed content of your infographic and prepare for them. Then input all the text in the proper position. · Step 2: Beautify the infographic in WPS Spreadsheeto Merge CellsYou can merge cells to show the content entir....

How to make a food menu in WPS Office Excel

Are you struggling to make an elegant food menu? This tutorial will show you how to create a neat and beautiful menu in WPS Office Excel quickly. Four simple steps are as following:Step1：Set the print pattern and show print grid linesSept2：Input all the contents of the food menuSept3：Beautify the food menuSept4：Export the food menu Now let’s make a food menu step by step. Remember you are free to adjust the cells anytime according to actual needs.· Step 1: Set the print pattern and sho....

How to make an animated video in WPS Office PowerPoint

Are you ready to master how to make an animated video in PowerPoint? After learning this WPS free tutorial, you will be advanced from a beginner in WPS Presentation. It would be very difficult for a novice to make videos with professional editing software. Don’t worry! WPS Presentation provides the Video Exporting function to help you make an animated video quickly and easily! Without further ado, let’s have a try step by step. · Step 1: Prepare for the animated video in WPS OfficeTo m....

Excel formula: how to add percentage in Excel (4 Easiest Ways)

You can compute percentages in Excel in a variety of ways. Excel may be used to determine the % of right answers on a test, discount prices using various percent assumptions, and calculate the percent change between two numbers, for example. In Excel, calculating a percentage is a simple two-step procedure. The percent formula is built in a cell once the cell is formatted to indicate the value is a percent. Format values as percentage in excel online, 2016 and 2019: 1. In Excel, you m....