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

        1828 results for adrama for pc

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

        1828 results for adrama for pc

        Format painter: tips for unifying format

        Format painter: tips for unifying format

        01:11

        Format painter: tips for unifying format

        In the process of making a WPS Presentation slide, we will unify the format of the text content for aesthetic purposes. Today, let's learn some tips for unifying the format quickly. Take this slide as an example. We can see that the font, font size, and color are different between each text. We can simply select the text box in the first line, and click the Home tab, then click the Format Painter button. Move the cursor to the second text box that needs a unified format, and click ....

        Presentation 18.4K views
        Conditional Formatting for data virtualization

        Conditional Formatting for data virtualization

        01:23

        Conditional Formatting for data virtualization

        Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

        Spreadsheet 5.3K views
        How can we insert endnotes for Documents

        How can we insert endnotes for Documents

        02:16

        How can we insert endnotes for Documents

        Endnotes usually appear at the end of the text and are mostly used to cite sources. When writing a paper, we often need to add endnotes to supplement the specific text. Then how can we insert an endnote for documents? · Step 1Place the mouse cursor where you want to insert the endnote. Click the References tab first, then click Settings, and finally click Footnote/(and)Endnote. · Step 2In the Footnote/(and)Endnote dialog box, we can set the Location according to our needs. As for this ....

        Writer 20.1K views
        Use COUNTIF function for conditional statistics

        Use COUNTIF function for conditional statistics

        01:32

        Use COUNTIF function for conditional statistics

        COUNTIF is a statistical function. It is often used to count the number of cells that meet the criteria. This function can not only count numbers and text but also can count expressions. So how can we use this function? The grammatical structure of the COUNTIF function is: COUNTIF(Range, Criteria)Range is the cell range that meets the criteria.Criteria are the conditions that need to be counted.Now we have a table that records everyone's afternoon tea order information. Column B co....

        Spreadsheet 36.7K views
        How to customize draw borders for tables

        How to customize draw borders for tables

        01:19

        How to customize draw borders for tables

        When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

        Spreadsheet 51.4K views
        The SUMPRODUCT function for quick calculation of total sales

        The SUMPRODUCT function for quick calculation of total sales

        01:44

        The SUMPRODUCT function for quick calculation of total sales

        When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

        Spreadsheet 13.0K views
        Change paper orientation and size for printing

        Change paper orientation and size for printing

        01:20

        Change paper orientation and size for printing

        How can we change the paper orientation for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice. Take this word document as an example. 1. Get into the Page Layout tab, where we can find the Orientation and Size buttons.2. Click the Orientation button. Then, we can choose either Portrait or Landscape as the page orientation.3. Click the Size button. Then we can see several default styles of paper sizes provided by WPS Office. I....

        Writer 56.8K views
        Page setup and print-out for spreadsheets

        Page setup and print-out for spreadsheets

        02:07

        Page setup and print-out for spreadsheets

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables and more. Includes advanced animation, slide transitions, and support for video, images, audio and even Flash.In the last chapter, we focus on the contents related to the page setting and printout of spreadsheets, and we often encounter various problems when printing, among which four FAQs will be introduced here. · 1: My form is incomplete. What can I do?Click the ....

        Spreadsheet 11.5K views
        Prev 1 2 3 ... 228 229 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