WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • grammarly for powerpoint

    2362 results for grammarly for powerpoint

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

    2362 results for grammarly for powerpoint

    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 4.0K 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 8.2K 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 919 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 13.1K 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 2.7K views
    Split the screen for data comparison

    Split the screen for data comparison

    01:21

    Split the screen for data comparison

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. When we meet a situation where a large amount of data in the table can not be completely displayed in the window, we still want to see the contents from different positions at the same time. To solve this, using the Split window is probably the best idea. If you want to connect the total sales with Branch in a spreadsheet with massive data, dragging the....

    Spreadsheet 1.7K 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 14.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 2.2K views
    Prev 1 2 3 ... 295 296 Next
    WPS Academy
    Products
    Partners