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

        122 results for office courses near me

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

        122 results for office courses near me

        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 12.0K views
        Recalculate the table formulas in the Manual Recalculation mode

        Recalculate the table formulas in the Manual Recalculation mode

        01:20

        Recalculate the table formulas in the Manual Recalculation mode

        Today, let me introduce you to a lesser-used function, Manual Recalculation. Take this document as an example. Now, the cells have formulas. When we modify the source data, the values in the table will also change automatically. That is because the table turns on the automatic calculation by default. When we need to process a particularly large amount of data in the worksheet, if we still choose automatic calculation, then every time we change the source data, the table data processing....

        Spreadsheet 12.7K views
        Worksheet and workbook

        Worksheet and workbook

        01:48

        Worksheet and workbook

        Creating forms is an essential skill for our daily work. Mastering the form skills can make our work more effective. Now starting from the basic interface, we will explain what a form worksheet and workbook is.First, we click Spreadsheets on the New page, then click Blank to create a new blank file at the bottom. Now enter the main interface of the table. Above the table is the functional area, which is often used when we edit the table. We will also introduce the usage of these featur....

        Spreadsheet 11.8K views

        How to make a resume template in WPS Office Word

        Welcome to WPS Academy! Are you searching for free courses about making a resume template? A professional and informative resume is the prerequisite for standing out from your competitors. Continue to read this free tutorial and quickly master how to make a resume template in WPS Office Word. lSteps to make a resume template in WPS Office WordØFirst of all, we need to figure out the basic sections that constitute a professional resume.u Full nameu Ideal positionu Contact informationu ....

        doc Writer 8.5K views
        Print out tables

        Print out tables

        02:43

        Print out tables

        In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables. In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer. If we need to print two copies of the spreadsheet document, we can chec....

        Spreadsheet 8.0K views
        Combine the SUBSTITUTE and LEN functions

        Combine the SUBSTITUTE and LEN functions

        02:57

        Combine the SUBSTITUTE and LEN functions

        Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

        Spreadsheet 13.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 31.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 14.2K views
        Prev 1 2 3 ... 15 16 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