WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        353 results for common uses

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

        353 results for common uses

        Five common uses of the Tab key

        Five common uses of the Tab key

        02:53

        Five common uses of the Tab key

        Do you know how to quickly indent the beginning of a paragraph, or start a numbering list, or select one of the overlapping layers? The Tab key will help you make it.Now I'll introduce you to five common uses of the Tab key.· IndentationWhen writing an article, a novice user usually indents the beginning of a paragraph by 4 characters by pressing the space key, but it's too troublesome.Actually, we only need to press the Tab key, and it will be indented by four characters autom....

        Writer 22.7K views

        Common shortcut keys in WPS Spreadsheet

        New File Ctrl + NClose the window Ctrl + WOpen…Ctrl + OSave Ctrl + SPrint Ctrl + PUndo Ctrl + ZRedo Ctrl + YCopy Ctrl + CCut Ctrl + XPasteCtrl + VFindCtrl + FReplaceCtrl + HGo To…Ctrl + GSelection PaneCtrl + F1Go to the beginning of the cellCtrl + HomeGo to the end of the cellCtrl + EndCreate a new line within a cellAlt + EnterExpand selection to the beginning of the cellShift HomePopup menu (right-click menu)Shift + F10 Help center F1Start to edit the cellF2Spell check F7Recalculate w....

        xls Spreadsheet 15.7K views

        Most Common 12 Month Cash Flow Statement Templates

        Most Common 12 Month Cash Flow Statement Templates 12 month cash flow statement template excel is a great way to keep track of your monthly income and expenses. It is important to use this template to see how much money you make each month, how much you spend each month, and how much money you have left at the end of the month. If you see that you are not making enough money, you can adjust your spending or find a new job. If you see that you are spending too much money, you can cut ba....

        xls Spreadsheet 3.3K views

        Most Common Rental Property Excel Templates Sheet

        Most Common Rental Property Excel Templates Sheet The rental property excel template is a great way to keep track of your rental property's expenses and income. The template includes a list of every important piece of information you need to know about your rental property. The rental property excel template includes information about the property, such as the address, monthly rent, and number of rooms. There is also a list of expenses, such as utilities, taxes, and repairs. The t....

        xls Spreadsheet 6.8K views
        Unique features in Student Tools

        Unique features in Student Tools

        01:42

        Unique features in Student Tools

        Student Tools is a collection of functions in WPS Presentation specially optimized for student user groups, which is not available in any other office software on the market. Student Tools, on the far right of the toolbar, collects the features that students use most frequently to save their time to toggle back and forth between the tabs. There are three common views and two common masters collected from the View tab, which can meet the needs of most reading, reviewing and presentatio....

        Presentation 5.8K views
        Why error message #VALUE! occurs and how to solve it

        Why error message #VALUE! occurs and how to solve it

        03:11

        Why error message #VALUE! occurs and how to solve it

        The errors in a function or formula will result in calculation errors, and it returns "#VALUE!". The common causes are as follows: incorrect function syntax, the reference cells containing text in the formulas, the reference cells containing a non-character string in the formulas, and the lack of braces in the formulas. Let's go through them one by one. · Incorrect function syntax.For example, we want to calculate the difference in computer sales between the first half of this year....

        Spreadsheet 10.4K views
        Look up data quickly with LOOKUP function

        Look up data quickly with LOOKUP function

        04:23

        Look up data quickly with LOOKUP function

        Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....

        Spreadsheet 17.1K views
        Batch export multiple pictures

        Batch export multiple pictures

        00:54

        Batch export multiple pictures

        If you want to save multiple pictures in a table, a common practice is to save them one by one. It will be very troublesome when there are a large number of pictures. Today, we will learn a quick tip to export pictures in batches. Taking this table as an example, we can see that there are many pictures in the table. First, change the suffix name of this table file in accordance with the suffix of the zip file. Here, we change the .xlsx format to .rar format and then decompress the file....

        Spreadsheet 6.0K views
        Prev 1 2 3 ... 44 45 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube