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

        1159 results for advanced ms office course online free

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

        1159 results for advanced ms office course online free

        Quickly convert PDF to JPG for free online in WPS Office

        Welcome to WPS Official Academy! Are you searching for the contents of how to convert PDF to JPG online free? After reading this quick tutorial, you will be able to master how to convert PDF to JPG for free online in WPS office within 4 steps.lSteps to convert pdf to jpg for free online in WPS Office1. Open the PDF you want to convert in WPS Office.2. Head to the Tools tab, and click the PDF to Picture button. 3. In the pop-up dialog, complete the settings as Export Type, Watermark, Pa....

        pdf PDF 8.5K views

        How to add password to PDF in WPS Office free online?

        In many cases, we need to prevent the contents in a PDF file from casual alteration or view. Thus, we need the free and easy-to-use PDF editor provided by WPS Office. As the supporting platform of WPS Office, WPS Academy offers this free tutorial to share the trick of adding password to PDF in WPS Office. Continue to read and master quickly!lSteps to add a password to PDF in WPS Office.1. Open the PDF file in WPS Office.2. Navigate to the Protect tab, and click the Encrypt button. 3. I....

        pdf PDF 16.7K views
        How to change the page orientation

        How to change the page orientation

        00:48

        How to change the page orientation

        To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....

        Spreadsheet 13.2K views
        Skillfully use Conditional Formatting to highlight  performance

        Skillfully use Conditional Formatting to highlight performance

        01:21

        Skillfully use Conditional Formatting to highlight performance

        To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the....

        Spreadsheet 6.0K 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

        How to use LEFT and RIGHT formulas together in excel

        Are you ready to master how to use LEFT and RIGHT formulas together in excel? After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet. · What is WPS Spreadsheet? WPS Spreadsheet is compatible with Microsoft Office Excel. As the world's leading developer of office software solutions, WPS Office provides free applications for individuals and businesses to improve productivity. · What is the LEFT and RIGHT function in WPS Spreadsheet? They both all....

        xls Spreadsheet 46.2K views
        How to quickly update the table of contents

        How to quickly update the table of contents

        01:10

        How to quickly update the table of contents

        How can we quickly update the table of contents when we need to modify the title content, location, and page number after setting up the table of contents? Take this document as an example. We found that the current page number is incorrect, so we modified the page number. At this time, the page numbers in the table of contents are not updated. And now we click the table of contents, and click the Update TOC button of the References tab. In the pop-up dialog, we choose Update page numb....

        Writer 17.4K views
        How to split sheets by content

        How to split sheets by content

        01:16

        How to split sheets by content

        When you want to split the content based on the specific categories in the sheet, are you still disassembling and reorganizing the content one by one? The Split Sheet feature can help you. Take this sheet as an example. If we want to split this sheet into three sheets based on class 1, class 2 and class 3, what should we do? We just need to click the Home tab and click Worksheet, then click the Split Sheet option, finally choose Split Sheets By Content. In the Split area box, we can ch....

        Spreadsheet 16.4K views
        Prev 1 2 3 ... 144 145 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