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

        123 results for office courses near me

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

        123 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 10.2K 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 11.3K 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 10.2K 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 7.6K 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 6.8K 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 12.2K 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.5K views

        Quickly convert PDF to editable word in laptop

        It’s convenient to save a document as a PDF document to protect the content inside, but what if you need to edit it later? WPS Office provides the PDF to Word function, allowing you to convert a PDF to an editable word document quickly! Now let’s have a try step by step. · Steps to convert PDF to editable word in WPS Office1. Open your PDF document in WPS Office.2. Navigate to the Tools tab > PDF to Word. Then a dialog pops up. 3. Select the document to be converted, set the Page Range....

        pdf PDF 13.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