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

        1688 results for indirect function excel

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

        1688 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 15.5K 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 6.8K 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 15.2K views
        Use IF function to judge data

        Use IF function to judge data

        01:48

        Use IF function to judge data

        The IF function can judge the specified condition and give two results when the condition is established and when it is not.Here is a staff interview form. Now we need to count the people who passed the interview quickly. If the interview score is greater than or equal to 6, the interviewee is passed, but the interviewee is unqualified if the interview score is less than 6. Here, we can use the IF function to judge the result of the interview quickly. The IF function syntax is as follo....

        Spreadsheet 48.5K views
        How to use the VLOOKUP function

        How to use the VLOOKUP function

        04:29

        How to use the VLOOKUP function

        The clever use of VLOOKUP function can help us quickly find the relevant results. It is usually used to check and match the data between multiple tables. Take this table as an example. In the table on the right, we know the "Number" and "Name" of the "Group1" members, so we are looking for the "Chemistry" scores of the members.1. Click cell J3, and click "Insert Function".2.Click "Lookup and Reference" in "Category", and choose "VLOOKUP" function.3.In the popup dialog box, we can see t....

        Spreadsheet 27.5K 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 36.3K views
        The AND Function in WPS Spreadsheet

        The AND Function in WPS Spreadsheet

        02:56

        The AND Function in WPS Spreadsheet

        The AND function is one of the commonly-used logical functions. When we need to test multiple conditions, it can quickly return the results. It will return TRUE if all of the arguments evaluate TRUE. Otherwise, it will return FALSE as its result. The syntax is stated as follows: AND(logical1,logical2, ...)Logical 1 is the first condition, while logical 2 is the second condition to evaluate, and up to 255 arguments are allowed in AND Function. Take this table as an example. With the sal....

        Spreadsheet 12.8K views
        How to use the FILTER Function

        How to use the FILTER Function

        03:15

        How to use the FILTER Function

        Lookup and Reference functions are frequently used for processing data in a table. Today we will learn how to use the FILTER Function to filter data.This function can be used to filter a range of data based on the criteria that you specify.· Primary usage of the Filter functionTake this table as an example. Suppose we want to get the list of class 1, Select G3:G15, this is the cell range we want the result to return, so don't just select cell G3.Enter the formula: =FILTER in the ce....

        Spreadsheet 41.5K views
        Prev 1 2 3 ... 210 211 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