WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • find out your static ip address

    17 results for find out your static ip address

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

    17 results for find out your static ip address

    How to create radar chart

    How to create radar chart

    02:01

    How to create radar chart

    Radar chart displays data information on one dimension like a spider web, allowing us to learn the relationships between each piece of data to the whole and compare them quickly.Take this table as an example, which is a table of the competency rating of three employees this year. It's difficult to find out the differences between them only with this data, so we can use a radar chart to make it clear. 1. Select the needed cell range, click the Insert tab and click the Radar drop-dow....

    Spreadsheet views
    Use MATCH function to search location information

    Use MATCH function to search location information

    02:17

    Use MATCH function to search location information

    The MATCH function can return information about the location of the lookup content based on the lookup value. Take this spreadsheet as an example. We want to find the location of the column where the contact Andrew is located. Then we can use the MATCH function. The syntax structure of MATCH function is: MATCH(lookup_value,lookup_array,match_type)In this table, we need to find out which row Andrew is located in column A by his name in cell D3. Click the Formulas tab and the Insert Func....

    Spreadsheet views
    How to make a resume to impress picky HR

    How to make a resume to impress picky HR

    04:35

    How to make a resume to impress picky HR

    An amazing resume is a must-have for the employee who wants to stand out among job applications.Today we will learn how to create a resume in excel.First, set the page size.Head to the "Page Layout" tab and set the page as A4 at "Size." Then select the default "Narrow" at "Margins." Step two, decide where to arrange your texts.Before setting the area, click "Page Break Preview" in the lower right corner to change the view mode. So we can better understand the sector locations for the s....

    Spreadsheet views
    How to use Select feature in WPS Presentation

    How to use Select feature in WPS Presentation

    02:04

    How to use Select feature in WPS Presentation

    A slide with large information contains a large number of elements. Therefore, we are likely to make some mistakes when editing slides. The Select feature in WPS Presentation can help us avoid mistakes. Take this document as an example. Click the Home tab and click the Select drop-down button. Here we can see three options: Select All, Select Audio, and Select Pane. Then we will get to know them one by one. · Select All1. Click the Select drop-down button and click Select All to select....

    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 compare two excel sheets and highlight differences

    In this article, you will know how to quickly compare two excel sheets and highlight differences with only 6 simple steps as follows. How to quickly compare two excel sheets for differences in values? You can use the View Side-by-Side comparison function if your boss requires you to immediately find out the differences between the two Excel sheets.For example, this is book1 and this is book2, click on View Side-by-Side and you can manually find out the differences in their values row b....

    Spreadsheet 0.2619 views

    How to add QR code to resume in WPS Office

    Welcome to WPS Official Academy to check the contents of how to add QR code to resume in WPS Office. You are sure to master the skill after reading this tutorial! · Steps to add QR code to resume in WPS Office1. Prepare your QR code image.2. Open your resume in WPS Office.3. Head to the Insert tab, and click Picture to insert the QR code. 4. Click Wrap Text > In Front of Text. 5. You can resize it and place it to a suitable position. With these steps, you are able to add QR code to re....

    Writer views

    Compare two sheets for differences in WPS Office Excel

    Are you ready to master how to find differences between two sheets in WPS Office Excel? After learning this WPS free tutorial, you will be advanced from a beginner in WPS Spreadsheet. Sometimes we need to compare two worksheets and find out the differences between them but you’ll feel dizzy to compare each item one by one. At this point, the View Side by Side and Manage Duplicates function can help a lot. Let’s have a try step by step.Here we take two performance appraisal sheets (Jan....

    Spreadsheet views
    Prev 123 Next
    WPS Academy
    Products
    Partners