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

Today, we are going to show you the usage of the Rows and Columns tool in the WPS Spreadsheet. This tool can help us set the rows and columns of cells and make our work easier with WPS Spreadsheet like Microsoft Excel. Take this table as an example. We need to adjust the row height and column width of the current table.1. Select all tables, click the Home tab, and click Rows and Columns. Select AutoFit Row Height and AutoFit Columns Width. The WPS Spreadsheet will automatically adjust ....

No matter you are students, teachers or business workers, can create and edit documents efficiently by WPS Writer as text editors. Easy to use like Microsoft Word.We cannot finish reading a long document all at once, so we can create bookmarks for the document contents to record the location we saw this time. Click the position where the bookmark needs to be Inserted. Then, select the Insert tab and click the Bookmark button to pop up the dialog box. We can enter the name of the Bookma....

The AND function is one of the commonly-used logical functions. When we need to test multiple conditions, it can quickly return the results. It will return TRUE if all of the arguments evaluate TRUE. Otherwise, it will return FALSE as its result. The syntax is stated as follows: AND(logical1,logical2, ...)Logical 1 is the first condition, while logical 2 is the second condition to evaluate, and up to 255 arguments are allowed in AND Function. Take this table as an example. With the sal....

When using WPS Presentation, we want to make changes to the specified content or font of the text. Take this slide as an example. If we want to quickly replace WPS in the text with WPS Office,Click the Home tab, then click the Replace drop-down button and choose Replace.Or use the shortcut key Ctrl+H.In the pop-up dialog box, enter WPS in the edit box. We can also set the replacement conditions as needed, such as Match case and Find whole words only.In the Find what box, enter WPS. Whi....

In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....

If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

When using WPS Presentation, we sometimes add a header and/or a footer to make the slides look more professional. How can we realize it? In this example, get into the Insert tab, and click the Header and Footer button. Then, we will see the two tabs of Slide and the Notes and Handout in the Header/Footer dialog. · The Slide tabHere we can insert the date and time, footer, and page number in the footer, which are respectively positioned in the bottom-left, -middle, and -right areas of t....