There are 8 free training tutorials of how to use office suite for WPS
Excel dark mode add on mac
Excel dark mode add on The excel dark mode add on allows you to make the appearance of your spreadsheet more pleasing to the eye. In addition, the dark mode will help you focus on your work at any time of the day. The screen becomes more comfortable to read, especially with high contrast settings. If you want to darken the Excel interface using the excel dark mode add on you are in the right place. Below are the steps you need to follow to enable dark mode and how to properly darken ce....
How to Landscape a Single Page in WPS Office: A Step-by-Step Guide
Learn how to effortlessly change the orientation of a single page in WPS Office without affecting the rest of your document. Follow our comprehensive guide for hassle-free formatting.
How to crop a photo into a circle in WPS Office PowerPoint
Welcome to WPS Official Academy! Are you looking for practical skills to elaborate your slides? In this free tutorial, you will be able to check the contents of how to crop a photo into a circle within simple 4 steps in WPS Office PowerPoint. After inserting or creating a desired image, you may need to crop the image into the desired shape.Now let's explore step by step.lHere are the steps to crop a photo into a circle in WPS Office PowerPoint1. Click the photo you want to crop, an....
How to insert and change the name of the slicers
Slicer is a very useful feature in WPS Spreadsheet. It can only be applied to a Pivot Table and can help users quickly filter various data. To learn more about the pivot table, you can watch some related videos in our WPS Academy.First, we need to create a Pivot Table.1. Open the table in WPS Spreadsheet, click the Insert tab → and click the PivotTable button, then the Create PivotTable interface will pop up.2. Select the cell range of the Pivot Table in the Select a range area.3. Sele....
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 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 save files to My Cloud Files?
There are two methods for you.Option 1:1. Open WPS Office, and click Open in the WPS home page.2. Click My Cloud Files, and click the Save to Cloud icon → Upload Files. Then select your file and click Open. Option 2:Here we take WPS Writer as an example.1. Open the document you need to save to Cloud.2. Click the Tools tab, and click Save to Cloud Docs. In the pop-up dialog, you can select a concrete position, rename the file and set the file type. Then click Save. For all, easy your w....
How to highlight duplicates in a worksheet
1. Open the spreadsheet with WPS Spreadsheet. 2. Select a range of cells for operation. 3. Click the Data tab → Highlight Duplicates → Set…4. Click OK in the popup “Highlight Duplicates” dialog. WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables, and more. Includes advanced animation, slide transitions, and support for video, images, audio, and even Flash.