INDEX FUNCTION FOR BEGINNER (Ms. Excel)
This video describe about the "Index Function" in Microsoft Excel. The Simple example used in the video helps the viewer to understand the concept easily. The Excel INDEX function returns the value at a given position in a range or array. You can use INDEX to retrieve individual values or entire rows and columns. Syntax =INDEX (array, row_num, [col_num]) The Microsoft Excel INDEX function returns a value in a table based on the intersection of a row and column position within that table. For online training contact:-7978975040 or E-mail- [email protected] To Visit our Facebook Page Click:- https://www.facebook.com/ICBSR Procedure:- (Step by Step Guide) 1. Open the Excel File you want to use "Index Function" 2. Click over the cell where you want to find out your query. 3. Type "=" equal to sign to activate the function. 4. Type "index" then put "(" column. 5. Select all the data you want result. Then give a "," comma. 6. Put the Row number then give a comma "," 7. Put column number then close the column ")" 8. Press Enter. Now your result is ready. Some of our recent videos link given below; 1. https://www.youtube.com/watch?v=l9HYf1fEbc4 2. https://www.youtube.com/watch?v=VVgdRRlKMEA 3. https://www.youtube.com/watch?v=qMONHmRq9Xs Twitter:- https://twitter.com/icbsrsite Linkedin:- https://www.linkedin.com/company/icbsr-site
This video describe about the "Index Function" in Microsoft Excel. The Simple example used in the video helps the viewer to understand the concept easily. The Excel INDEX function returns the value at a given position in a range or array. You can use INDEX to retrieve individual values or entire rows and columns. Syntax =INDEX (array, row_num, [col_num]) The Microsoft Excel INDEX function returns a value in a table based on the intersection of a row and column position within that table. For online training contact:-7978975040 or E-mail- [email protected] To Visit our Facebook Page Click:- https://www.facebook.com/ICBSR Procedure:- (Step by Step Guide) 1. Open the Excel File you want to use "Index Function" 2. Click over the cell where you want to find out your query. 3. Type "=" equal to sign to activate the function. 4. Type "index" then put "(" column. 5. Select all the data you want result. Then give a "," comma. 6. Put the Row number then give a comma "," 7. Put column number then close the column ")" 8. Press Enter. Now your result is ready. Some of our recent videos link given below; 1. https://www.youtube.com/watch?v=l9HYf1fEbc4 2. https://www.youtube.com/watch?v=VVgdRRlKMEA 3. https://www.youtube.com/watch?v=qMONHmRq9Xs Twitter:- https://twitter.com/icbsrsite Linkedin:- https://www.linkedin.com/company/icbsr-site