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

        1705 results for indirect function excel

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

        1705 results for indirect function excel

        The INDEX function

        The INDEX function

        03:50

        The INDEX function

        The INDEX function can look up a value regarding its row and column numbers.There are two forms of the INDEX function, the Array form and the Reference form. · One: Array formWe'll use the Array form to return the value located in the seventh row and the fourth column.First, select cell J6. Next, click Formulas and then Insert Function to insert the INDEX function. The function syntax:INDEX(array,row_num,column_num)The first parameter, 'Array', refers to the array for valu....

        Spreadsheet 13.9K views
        The Trace Precedents function

        The Trace Precedents function

        00:57

        The Trace Precedents function

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. While processing a table, we have to double-click a cell containing a function formula to view the referenced data cell, However, this will easily lead to incorrect editing of the formula. At this time, we can use the function of Tracking Precedents of WPS table.Take this table as an example. We want to see which cells are referenced by the formula of ....

        Spreadsheet 5.9K views
        The Advanced XLOOKUP Function

        The Advanced XLOOKUP Function

        08:33

        The Advanced XLOOKUP Function

        What type of lookup function are you using?VLOOKUP? HLOOKUP? Or...King of the Lookup function-XLOOKUP function is available now!With the XLOOKUP function, you can search for a match in a range or array and return the corresponding item through the second range or array.· The powerful lookup functionSuppose we want to look up Rico's department.Enter=XLOOKUP, and press the TAB key. We need to answer three questions for mandatory arguments.1, what is the keyword for lookup values?Ente....

        Spreadsheet 13.4K views
        AVERAGE function quickly average data

        AVERAGE function quickly average data

        00:57

        AVERAGE function quickly average data

        In WPS Spreadsheet, we can use the AVERAGE function to quickly find the average value of a set of data quickly. It is often used to calculate average wages, average sales, and so on. Take this table as an example. We now need to find the average sales of the bakery this week. After we click cell D4, click Insert Function, and enter AVERAGE in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up. The data we filled in Num....

        Spreadsheet 33.1K views
        Use CONCAT function to merge data

        Use CONCAT function to merge data

        01:16

        Use CONCAT function to merge data

        We can use the CONCAT function to merge the contents of multiple cells.This function is mainly applied to merge character strings within a certain cell range or in different cells. Now we take a simple case as an example. We want to merge the domain names to form a complete website address.1. Click Formulas, click Insert Function, input "CONCAT" in the dialog, and click OK.2. Since the cells to be combined are continuous, we input "A2:D2" in Text 1, click OK, and drag the cell to fill ....

        Spreadsheet 18.7K views
        Look up data quickly with LOOKUP function

        Look up data quickly with LOOKUP function

        04:23

        Look up data quickly with LOOKUP function

        Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....

        Spreadsheet 17.1K views
        Use COUNTIF function for conditional statistics

        Use COUNTIF function for conditional statistics

        01:32

        Use COUNTIF function for conditional statistics

        COUNTIF is a statistical function. It is often used to count the number of cells that meet the criteria. This function can not only count numbers and text but also can count expressions. So how can we use this function? The grammatical structure of the COUNTIF function is: COUNTIF(Range, Criteria)Range is the cell range that meets the criteria.Criteria are the conditions that need to be counted.Now we have a table that records everyone's afternoon tea order information. Column B co....

        Spreadsheet 36.7K views
        How can we use RANK function

        How can we use RANK function

        01:18

        How can we use RANK function

        RANK function is a statistical function that can quickly calculate the rank of a number in a list of numbers. Taking this sales table as an example, how do we rank the sales volume in the first quarter? First, we can place the cursor in cell F3, click the Formulas tab, and Insert Function button to find RANK function. At this time, the Function Arguments dialog box will pop up.Number is the number for which you want to find the rank. Ref is an array of, or a reference to, a list of num....

        Spreadsheet 16.3K views
        Prev 1 2 3 ... 213 214 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