You will be the amazing reporter with WPS Spreadsheet, which could be an alternative to Microsoft Excel. Mathematical equations contain a variety of number formats like symbols, scores, root numbers, and so on. It is difficult for us to enter these equations with the input method. However, with the Equation function in WPS Spreadsheet, inserting mathematical equations will no longer be a problem. Click the Insert tab at the top of the screen, then click the Equation button. Here, WPS O....

You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Mathematical equations contain a variety of number formats like symbols, scores, root numbers, and so on. It is difficult for us to enter these equations with the input method. However, with the Equation function in WPS Presentation, inserting mathematical equations will no longer be a problem. Click the Insert tab at the top of the screen, then click the Equation button. Here....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....

Presentation Tools is a feature for WPS Office that can quickly modify the font and size of slide texts, and insert pictures to multiple slides in batches. We can see four options here: Replace Fonts, Batch Font Settings, Customize Text Formats and Insert Picture to Multiple Slides. Microsoft PowerPoint has similar functions as well, such as Replace Font, New Photo Album and Edit Master Slide. However, their entry points are scattered which means the users may need to switch back and f....

Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

When we are editing a document, we may sometimes find the formatting of the document is not uniform. Or sometimes, we may want to quickly apply the same formatting of one paragraph to another text. All these situations can be easily solved with Format Painter, which could be also used in Microsoft Office Word and Openoffice. Take this document as an example. After we finish setting the text formatting of the title, we now want to copy all formatting of the text to the title below.1. Se....