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

        2922 results for All

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

        2922 results for All

        A quick way to calculate sum, average, count, max, and min

        A quick way to calculate sum, average, count, max, and min

        01:34

        A quick way to calculate sum, average, count, max, and min

        Here we have received a sheet on the Masks Sales in Single-Day Sheet from a supermarket. How can we quickly calculate the sum, average, maximum, and daily sales volume during the period from August 19th to 31st?We can use the AutoSum feature of the WPS Spreadsheet, rather than calculating all data one by one with a calculator, which would be a waste of time. Follow these step.1. Select the data area, click the AutoSum drop-down button in the Formulas tab.2. Find the Sum button and clic....

        Spreadsheet 52.6K views
        Use format painter to quickly unify text formatting

        Use format painter to quickly unify text formatting

        01:28

        Use format painter to quickly unify text formatting

        When we are editing a document, we may sometimes find the formatting of the document is not uniform. Or sometimes, we may want to quickly apply the same formatting of one paragraph to another text. All these situations can be easily solved with Format Painter, which could be also used in Microsoft Office Word and Openoffice. Take this document as an example. After we finish setting the text formatting of the title, we now want to copy all formatting of the text to the title below.1. Se....

        Writer 51.9K 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
        Introduction to Presentation Tools

        Introduction to Presentation Tools

        03:13

        Introduction to Presentation Tools

        The Presentation Tools button serves as a quick and convenient assistant in WPS Presentation, helping us to set the slides easily in a short time. So how can we use Presentation Tools? Click the Design tab on the top, and click the Presentation Tools drop-down button. We can see four options here: Replace Fonts, Batch Font Settings, Customize Text Formats and Insert Picture to Multiple Slides. · Replace Fonts:The Replace Fonts option helps us to replace one font with another throughout....

        Presentation 48.3K views
        How to set header and footer in WPS Presentation

        How to set header and footer in WPS Presentation

        02:26

        How to set header and footer in WPS Presentation

        When using WPS Presentation, we sometimes add a header and/or a footer to make the slides look more professional. How can we realize it? In this example, get into the Insert tab, and click the Header and Footer button. Then, we will see the two tabs of Slide and the Notes and Handout in the Header/Footer dialog. · The Slide tabHere we can insert the date and time, footer, and page number in the footer, which are respectively positioned in the bottom-left, -middle, and -right areas of t....

        Presentation 48.0K 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
        Set the date format cells

        Set the date format cells

        01:40

        Set the date format cells

        In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

        Spreadsheet 46.9K views
        How can we change the font in a cell

        How can we change the font in a cell

        01:09

        How can we change the font in a cell

        When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell? In this spreadsheet, select a range of cells. In the Home tab , we can change text settings including Size and Text Color , and add effects for the texts such as Bold, Italic, Fonts, Underline, etc. 1. Select the cells filled with WPS Academy.2. Right-click the cells, and choose Format cells in the pop-up menu. Or we can just select the cells and press the shortcut Ctrl+1.3. Click the Font tab ....

        Spreadsheet 45.8K views
        Prev 1 ... 4 5 ... 365 366 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