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

        121 results for office courses near me

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

        121 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.8K 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 13.2K 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 12.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.6K 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 14.4K 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.9K 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 16.5K 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.8K 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