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

        782 results for how do we communicate in today s world

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

        782 results for how do we communicate in today s world

        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 27.6K views
        How to insert a background image and print it out in WPS Spreadsheet

        How to insert a background image and print it out in WPS Spreadsheet

        01:31

        How to insert a background image and print it out in WPS Spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....

        Spreadsheet 47.3K views
        Elementary arithmetic functions in WPS Spreadsheet

        Elementary arithmetic functions in WPS Spreadsheet

        02:50

        Elementary arithmetic functions in WPS Spreadsheet

        Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click Insert Function. So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter "= A2 + B2" in cell C2, press the Enter ke....

        Spreadsheet 13.5K 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.2K views
        How to sort with a custom list

        How to sort with a custom list

        01:36

        How to sort with a custom list

        How can we sort the table with a custom list when designing a report? Today, we will learn how to create a custom list for sorting.For example, we want to sort this table by position. Click Custom Sort in the Data tab to pop up a dialog.By default, the system sorts letters and integers in ascending or descending order on their values.Click the drop-down list at Order and select Custom Lists.Custom lists on the left tell the built-in sorting rules. We can customize the sorting rules at ....

        Spreadsheet 11.5K views
        How to use the paste special function

        How to use the paste special function

        02:11

        How to use the paste special function

        Copy-paste has always been one of the most frequently-used functions in excel. However, few people are aware of its true power. Today we will learn how to utilize Paste Special in excel.The first method is to paste special contents in your table.Take this table as an example. This table is set with styles. In many cases, we merely want to paste the values but don't want the original styles. What should we do? Press Ctrl+C to copy the contents, click the Paste drop-down menu in the ....

        Spreadsheet 38.9K views
        Customize the formats to show data changes

        Customize the formats to show data changes

        01:28

        Customize the formats to show data changes

        Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....

        Spreadsheet 8.4K views
        How can we format cell values

        How can we format cell values

        01:57

        How can we format cell values

        Cell formatting is an important feature of spreadsheets. So today, we will briefly go through how to format cell values. Number formatting can be simply understood as a digital form that can be used for calculations.Take this table as an example: now the data in the cell is in text formatting. If using the SUM function to do calculations, we would find that the data in text format cannot be calculated. At this time, we need to convert the data into a number formatting that can support ....

        Spreadsheet 33.8K views
        Prev 1 2 3 ... 97 98 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