There are 8 free training courses of how to use office suite for WPS
How We Can See File Extension in Excel Windows
The extension of an Excel file provides you with important information about that file before you open it. It also lets you organize the files you save into your directories as template files, macro-enabled files, and more. With just a glance at the Excel file extension, you know more about the Excel file and what it’s used for. Excel file extensions tell you: Whether macros or VBA are included. If the file was saved with an older version of Excel. Whether the file format is base....
How to Use Sheet Name in Excel Formula (Quick Methods)
The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information. At the bottom of each worksheet in the Excel document window is a small tab that indicates the name of the worksheets in the workbook. Excel names these worksheets using a default name. These names (Sheet1, S....
How to print multiple slides on one page
1. Use WPS Office to open the PPT.2. Click the Print Preview icon in the upper left corner of the page → the Print What button.3. Select the number of slides in the Handout settings area as needed. For example, if we want to print 3 slides on one page, choose 3 Slides. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.
How to turn off automatic numbering in WPS Writer
When editing documents, we sometimes don't want WPS Office to automatically number list for us every time we press the Enter key. So how can we turn off automatic numbering?1. First open the file in WPS Writer.2. Click the Menu button in upper lefter corner.3. Then select Options in the drop-down menu. Now a Options dialog box will pop up.4. Click Edit → and then check Auto numbered lists.5. Finally click OK.This skill could also be used in Microsoft Office Word and OpenOffice.
How to wrap text in WPS Writer
1. Use WPS Office to open the document.2. Place the mouse cursor at the position where you want to wrap the text.3. Press the Enter key on the keyboard.4. We finish the text wrapping. To be office word advanced, you could learn how to use WPS Office Writer online in WPS Academy.
Top 10 excel templates of total compensation statement
Top 10 excel templates of total compensation statement As we all know in this modern era everything needs updates and efficient work. Consumers low time frame and work smartly that is why excel template provides thousands of multiple features in different to work smarter and faster. Employees and staff increase their efficiency through excel formulas and their interesting features. Excel template also provides a lot of templates in different forms to record schedules, and inventories a....
How to Insert multiple pictures into Slides
You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Pictures excel in attracting people’s attention and supplementing your content in a less tasteless way. For those who have dozens, or more radically, even hundreds of pictures to insert into slides, today’s tutorial may help.1. Use WPS Presentation to open your slides.2. Place your cursor in the first slide that need to insert picture.3. Click the Design tab > Presentation To....
How to add a calendar template in Excel with drop-down list (2022 Free Templates)
WPS spreadsheet offers various graphic components that are beneficial for business, education, or personal projects in addition to being a great tool for storing data. People may use calendar templates to insert a certain month into their spreadsheets and change the information to meet their individual needs. Learning how to make a calendar in Excel may help you with a variety of activities, including scheduling. In this post, we'll explain what an Excel calendar is, when you would wa....