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

        180 results for how to enable dropbox account

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

        180 results for how to enable dropbox account

        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.8K views
        Apply conditional formatting to data

        Apply conditional formatting to data

        11:12

        Apply conditional formatting to data

        In this lesson, we have learned several ways to set conditional formatting. 1."Highlight Cells Rules" and "Top/Bottom Rules." They can highlight cells quickly and draw people's attention to data that matches the conditions. 2.Data bar, Color Scales and Icon Sets can visualize data and make them clearer to recognize. 3.We also learn how to add multiple formatting to data using the AND function.In the selected area, we can set multiple conditions, delete specific rules or clear all ....

        Spreadsheet 9.1K views
        Edit settings in WPS Spreadsheet

        Edit settings in WPS Spreadsheet

        03:47

        Edit settings in WPS Spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

        Spreadsheet 25.3K 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 12.2K 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 9.1K 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 9.3K 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 20.0K views

        Excel dark mode add on mac

        Excel dark mode add on The excel dark mode add on allows you to make the appearance of your spreadsheet more pleasing to the eye. In addition, the dark mode will help you focus on your work at any time of the day. The screen becomes more comfortable to read, especially with high contrast settings. If you want to darken the Excel interface using the excel dark mode add on you are in the right place. Below are the steps you need to follow to enable dark mode and how to properly darken ce....

        xls Spreadsheet 15.5K views
        Prev 1 2 3 ... 22 23 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