WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how do you spell consolidate

    133 results for how do you spell consolidate

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    133 results for how do you spell consolidate

    How to merge sheets with the same name

    How to merge sheets with the same name

    01:43

    How to merge sheets with the same name

    In WPS Spreadsheet, there are many ways to merge worksheets. Do you know how to merge worksheets of the same name correctly?Take this workbook as an example, and you can find three worksheets that record students' scores in mathematics, physics, and chemistry respectively.Teachers need to extract the scores of mathematics, physics, and chemistry from these three classes and then put the scores of each subject in different workbooks. What can we do? First, click the Data tab, click ....

    Spreadsheet views
    Use the Today function to quickly calculate days between dates

    Use the Today function to quickly calculate days between dates

    01:57

    Use the Today function to quickly calculate days between dates

    In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....

    Spreadsheet 0.1814 views
    How to use the spell-check function

    How to use the spell-check function

    02:31

    How to use the spell-check function

    The spell-check function of WPS helps us to quickly check spelling mistakes and provides suggestions for corrections. It saves us a lot of time to align documents. We can see that some of the content of this document has been marked with red underlines because WPS Office judged that the content of the text is wrong. At this time, we need to correct the marked content to eliminate these red underlines.Click the Review tab and click the Spell Check button. A pane will pop up on the right....

    Writer 0.1291 views
    How to cancel automatic numbering

    How to cancel automatic numbering

    01:45

    How to cancel automatic numbering

    Do you know how we can shut down the automatic numbering function? Here are three different ways to cancel automatic numbering. WPS Office is equipped with the automatic numbering function by default. When we enter the numbered text and press Enter, serial numbers will be automatically added in the next paragraph , and the Numbering button in the function area is gray.However, a lot of times, we don't need automatic numbering, so how can we solve this the problem? In this case, we....

    Writer views
    Display the unit symbol in the formula result

    Display the unit symbol in the formula result

    01:26

    Display the unit symbol in the formula result

    This is a table of information about the department employees. If we need to calculate the average weight of the staff, what should we do?Normally, you only need to enter the formula =AVERAGE(D2:D8) in cell D9 to get the average.However, the formula returns 0, and obviously, the result is incorrect because there are text characters in the cells, which affects the accuracy of the calculation. Do you know how to retain the weight unit and normally perform the calculation at the same time....

    Spreadsheet views
    Skillfully use Conditional Formatting to highlight  performance

    Skillfully use Conditional Formatting to highlight performance

    01:21

    Skillfully use Conditional Formatting to highlight performance

    To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the....

    Spreadsheet views
    Unique features in Student Tools

    Unique features in Student Tools

    02:23

    Unique features in Student Tools

    No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Student Tools is a collection of functions launched by WPS for students users. Some frequently-used functions are selected. This built-in function cannot be found in other office software at present. In the interface of this function, WPS Office selects Reading View mode from the View tab, frequently used features such as Highlight and Text Color....

    Writer views
    How to encrypt PDF files

    How to encrypt PDF files

    01:35

    How to encrypt PDF files

    Do you know how to better protect the important PDF files? Today I will teach you to use the PDF encryption feature that can greatly enhance the security of documents. · 1. Set the open passwordIf you don't want others to view the contents of the PDF file at will, click the Protect tab and click Encrypt. In the pop-up dialog, check Set the open password. After setting the password, click Confirm.The next time we open this PDF file, we need to enter the correct password to view the ....

    PDF views
    Prev 123...1617 Next
    WPS Academy
    Products
    Partners