There are 8 free training courses of how to use office suite for WPS
How to Recover Unsaved Word Documents on Windows/Mac/Android/iPhone
Everyone has at least once wondered how to recover unsaved Word document in different circumstances. When all seems lost, there is hope with the right steps.
How to change the fonts in Word
Welcome to WPS Official Academy to check the contents of how to change your fonts in Word. In today’s tutorial, we will also learn how to change the default fonts. What is WPS Office?WPS Office is the best alternative to Microsoft 365. WPS Office Suite supports both PC and Mobile. It is compatible with Microsoft Office, Google Docs and Adobe PDF. How to change the fonts in WPS Writer:1. Select the fonts you want to change, then head to the Home tab and select your fonts in the drop-d....
How to check for duplicates in WPS Office Excel sheets
We often need to compare two sets of data and check for duplicates at work, but it would be a waste of time to look for duplicates one by one. To solve this problem, WPS Office provides the Manage Duplicates function. · Steps to check for duplicates with the Manage Duplicates functionHere we take two sheets as examples, which record the attendees of Conference 1 and Conference 2. To find out those who attended two conferences, we need to check for duplicates in these two sheets. 1. Hea....
How to set up a slideshow in WPS Presentation
1. Use WPS Office to open slides.2. Click the Slide Show tab → the Set Up Show button.3. In the pop-up dialog box, we can set up a slideshow in details, including "Show type", "Show options", "Multiple monitors", "Range of slideshow", and "the way to change slides".4. After we have finished settings, click the OK button. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.
How to set print area in a worksheet
1. Open the worksheet (XLS. Or XLSX. files) in WPS Spreadsheets. 2. Select the cell area to be printed → click the Page Layout tab → Print Area dropdown button → choose Set Print Area from the drop down list.3. Then, click Print Preview to preview effect. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to reorder pages in word
How to reorder pages in word. Sometimes in word wps files, you need to reorder pages for any specific reason. The functions in WPS make it easier to reorder pages and work on the document easily. So here we will discuss in a few easy steps that how can we reorder pages by following really simple and easy steps. No matter on which device you are using WPS on, this method is workable on every devices. No matter you are a student, teacher, or business user, you can improve your work effic....
How to view a PDF file in full screen
1. Open the PDF file in WPS Office.2. Click the Play Slide button in the lower right corner. We can also use its shortcut key Shift+F5.3. Now we can view the PDF file in full screen. With WPS PDF, you can easily read, edit, and manage PDF pages on android and easily convert between PDF and other types of documents. Currently support doc/ppt/word/excel/image/xls.
How to Create and Find Sheet Name Code in Excel (The Simplest Steps)
How to Create and find sheet name code in excel-WPS Academy A sheet name code is a friendly and meaningful name that you can assign to the sheets in your workbook. This is especially useful if you have more than one worksheet because the names can be different. Creating a sheet name in excel is very important to keep track of your data. It is helpful for separating the sheets and for organizing your documents and records. Creating sheet name in excel is a common task for data analysts ....