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

        148 results for leris account

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

        148 results for leris account

        WPS Top 10 Construction final account Excel Templates

        WPS Top 10 Construction final account Excel Templates Construction final account excel template is the arrangement between the business and the project worker that how much cash the business needs to pay to the worker for hire toward the end when the development is finished. Construction final account excel templates are utilized for introducing your information in a compelling way. It incorporates every one of the information from the natural substances to completed items. Everything ....

        xls Spreadsheet 3.9K views
        How to set custom symbols and symbols shortcut key

        How to set custom symbols and symbols shortcut key

        01:32

        How to set custom symbols and symbols shortcut key

        In the process of editing documents, we occasionally need to re-enter the same symbols. Take this table as an example. When we make an account for purchased fruits, we need to enter the weight unit kg, so how can we quickly enter it? In the Insert tab, click the Symbol drop-down button, and then click More Symbol to pop up a dialog box.In the Custom Symbols tab, we can see many system-defined symbols, including the kg we need to enter. After clicking kg, click the Shortcut keys edit b....

        Writer 16.2K views
        Combine the SUBSTITUTE and LEN functions

        Combine the SUBSTITUTE and LEN functions

        02:57

        Combine the SUBSTITUTE and LEN functions

        Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

        Spreadsheet 11.7K views
        How to use the formula function of table in WPS Writer

        How to use the formula function of table in WPS Writer

        02:38

        How to use the formula function of table in WPS Writer

        You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore. Take this table as an example. Assume that we want to count how many Expense there are in the whole table. We can use the COUNT function to count the number of data in the table.Tips: The COUNT function in WPS can only be applied in counting number data, while the empty cells, logical value....

        Writer 8.7K views

        How to combine debit and credit columns in WPS Office Excel

        Welcome to WPS Official Academy to check the contents of how to combine debit and credit columns in Excel. · What is Debits and Credits?According to WIKIPEDIA, debits and credits in double entry bookkeeping are entries made in account ledgers to record changes in value resulting from business transactions. A debit entry in an account represents a transfer of value to that account, and a credit entry represents a transfer from the account. Debits and credits are traditionally distinguis....

        xls Spreadsheet 19.4K views
        Use subtotal feature to do statistic

        Use subtotal feature to do statistic

        04:35

        Use subtotal feature to do statistic

        The Subtotal feature of the WPS Spreadsheet is a commonly used feature when processing data. It can automatically statistic the data in the worksheet by fields. So how can we use this feature?Take this table as an example.Before using the subtotal feature, we need to edit the table a little bit. Because when using the subtotal function, we must first sort the fields to be classified, otherwise the result of subtotal may be inconsistent with the expected effect.1. Select any cell in the....

        Spreadsheet 8.8K views

        10 Professional Excel Directory Template

        10 Professional Excel Directory Template: Keyword: excel directory template There are many different excel directory templates that you can use in your business. In this article, we will discuss the 10 best professional excel directory templates. These templates are designed to help you keep track of your finances, inventory, assets, and more. They are easy to use and customization, so you can make them fit your specific needs. We recommend giving them a try! 1.Travel Account Book Trav....

        xls Spreadsheet 5.6K views

        Top 10 Credit Card Utilization Excel Templates on WPS Office

        Top 10 Credit Card Utilization Excel Templates on WPS Office Want to make a business card? If yes, then explore the WPS Office and use the credit card utilization excel templates. It is an effective template for tracking charges, transaction fees, and payments made to your account.  Utilizing a credit card utilization excel template helps you keep track of charges, transaction fees, and payments. Your finances will be easier to manage if you use this professionally designed credit card....

        xls Spreadsheet 6.6K views
        Prev 1 2 3 ... 18 19 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