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

        53 results for microsoft courses near me

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

        53 results for microsoft courses near me

        More features in Document Encryption

        More features in Document Encryption

        02:14

        More features in Document Encryption

        Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....

        Spreadsheet 6.5K views
        Text direction in WPS Presentation

        Text direction in WPS Presentation

        02:34

        Text direction in WPS Presentation

        When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....

        Presentation 9.7K views
        Use the ROUND function to round decimals quickly 

        Use the ROUND function to round decimals quickly 

        01:57

        Use the ROUND function to round decimals quickly 

        In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

        Spreadsheet 19.9K views
        Use VLOOKUP function to create dynamic charts

        Use VLOOKUP function to create dynamic charts

        03:44

        Use VLOOKUP function to create dynamic charts

        In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....

        Spreadsheet 12.4K views

        How to enter text vertically in cells

        In most situations, when entering text context into a cell WPS Spreadsheet, the characters are arranged from left to right. How can we type vertically in WPS Spreadsheet?1. Right-click the cell → choose Format Cells in the dropdown list 2. Get into the Alignment tab in the Format Cells dialog, and check the Vertical text box. Then, the characters would present vertically.WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot ta....

        xls Spreadsheet 14.0K views

        How to convert PDF to PPT in WPS Office online?

        In this free tutorial, you will master how to convert PDF to PPT in WPS Office with simple steps as follows: · Steps to convert PDF to PPT in WPS Office.1. Open the PDF file you want to convert to PPT.2. Navigate to the Tools tab, and click PDF to PPT. 3. Select the file you want to convert.4. Set the exported file format at Save as type.5. Set the location to save the exported file at Save as location.6. Click Start. 7. Then you can continue to edit the PPT in WPS Presentation as need....

        pdf PDF 11.8K views

        How to capitalize letters in WPS Office Word

        When editing a word document, we often need to capitalize the letters of some specific words like abbreviations, proper nouns, etc.It's quite simple to capitalize letters in WPS Office Word. Now let's begin!lSteps to capitalize letters in WPS Office Word1. Open the document in WPS Writer.2. Select the letter to be capitalized.(Tips: Press the Ctrl key to select multiple letters separately.) In the Home tab, click the Change Case button. And check Uppercase or Togglecase.3. You ....

        doc Writer 28.4K views

        How to split PDF file into multiple pages quickly in WPS Office

        Are you ready to master how to split PDF quickly in WPS Office? After learning this WPS free tutorial, you will be advanced from a beginner in WPS PDF. · Steps to split PDF quickly in WPS Office.1. Open the PDF file you need to split.2. Go to the Page tab > Split PDF. 3. Select the PDF file to split.4. Set the Page range, and set the splitting method at Split by.5. Set the location to save the split PDF file at Save as location.6. Click Split. With these steps, you are able to split P....

        pdf PDF 13.5K views
        Prev 1 2 3 ... 6 7 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