WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • microsoft courses near me

    35 results for microsoft courses near me

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

    35 results for microsoft courses near me

    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 0.1363 views
    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 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 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 views

    How to clear the format of cell in WPS spreadsheets?

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.To clear the format of all your slides at once, using the Clear option is probably the best idea, who has the final say about how your spreadsheet will look: the contents should have the same fonts, size, colour, etc. Let's learn how to do that. 1. Open your table in WPS Spreadsheets. It is no exaggeration to say that the format of this table is a me....

    Spreadsheet views

    Easy steps to crop PDF file in WPS Office

    Are you ready to master easy steps to crop PDF file? After learning this WPS free tutorial, you will be advanced from a beginner in WPS PDF. Sometimes we may need to crop the PDF file to make it look better or remove the redundant content. WPS Office provides the Crop Page function, allowing you to crop PDF files quickly. · Steps to crop PDF file in WPS Office1. Open your PDF file in WPS Office.2. Head to the Edit tab, and click Crop Page to enter the cropping mode. 3. Here are four bu....

    PDF views

    How to split PDF 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 views

    How to use PDF editor to Add Bookmark in WPS Office

    In this free tutorial, you will learn how to add bookmark with PDF editor in WPS Office with simple steps as follows. · Steps to add bookmark with PDF editor in WPS Office1. Open your PDF file in WPS Office and turn to the page where you want to add a bookmark.2. Head to the Edit tab, and click Add Bookmark to pop up the Bookmark pane on the left. Then you can input the name for the new bookmark. o Edit bookmarks with the buttons on the pane1. You can click the bookmark and jump to the....

    PDF views
    Prev 12345 Next
    WPS Academy
    Products
    Partners