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

        345 results for common uses

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

        345 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 24.9K 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 8.0K 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 17.3K 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.9K 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 6.5K 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 11.8K views
        Why error message #REF! occurs and how to solve it

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

        03:18

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

        The error message "#REF" is common in table calculations. In general, there are mainly two causes. First, the referenced cells in the formula are deleted or replaced by other cells. Second, the formula references invalid cell ranges or values. Then how can we solve these problems? · The referenced cells in the formula are deleted or replaced by other cells.o The referenced cells in the formula are deleted.Take this table as an example. 1. To calculate the total sales of computers t....

        Spreadsheet 7.4K views
        Why error message NA occurs and how to solve it

        Why error message NA occurs and how to solve it

        02:56

        Why error message NA occurs and how to solve it

        When using the VLOOKUP function to locate data, a #N/A error sometimes will appear.Two common causes are listed as followed. The first reason: the searched value is not in the searching range. Take this table as an example. To get the sales of erasers, black pens, pencils, and blue pens, we need to insert the following formula: =VLOOKUP(F3,A2:D9,4,0) F3 is Lookup_value, Eraser is the value to look for. A2:D9 is Table_array, the entire table is the range containing the data to look for.....

        Spreadsheet 9.8K views
        Prev 1 2 3 ... 43 44 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