Anisha Jasmeen

 

  VLOOKUP VLOOKUP works by searching down the first column of a table to find a match. Once it locates that match, it retrieves data  from the specified column of the same row.  FORMULA: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])                                       Step 1:LOOKUP VALUE                             The lookup value S elect the cell where you want the result to be and start the VLOOKUP formula by typing: STEP 2 : Table array   Now Excel asks you to write the second argument into the VLOOKUP function: the  table_array . This range must contain both the column you’re looking in and the column you want to return something from. Step 3: Column index number The third argument of the VLOOKUP syntax is the  col_index_num  (column index number). The colum...

  Text to Columns in Excel   To separate the contents of one  Excel cell  into  separate columns , you can use the 'Convert Text to Columns Wizard'. For example, when you want to separate a list of full names into last and first names. STEP 1.  Select the range with full names. STEP 2.  On the Data tab, in the Data Tools group, click Text to Columns. STEP 3.  Choose Delimited and click Next. STEP 4.  Clear all the check boxes under Delimiters except for the Comma and Space check box. STEP 5.  Click Finish .

HOW TO USE FLASHFILL IN EXCEL Flash Fill is one of the most amazing features of Excel. It grabs a tedious task that would take hours to be performed manually and executes it automatically in a flash. And it does so quickly and simply without you having to do a thing but only provide an example of what you want . step 1:-    Enter the  First Name  in the first result cell and press  Enter . step 2:-   Start typing the next name step 3:-   Flash Fill  will suggest the  first  part of all names  step 4:-   Press  Enter . step 5:- You can see all the  First Names  in column  . step 6: - Separate the surname  Names  

  Filtering in MS Excel helps you narrow down your data to show only the information you need. Here's how to use it: *Types of Filters* 1. *AutoFilter*: Automatically filters data based on the column headers. 2. *Advanced Filter*: Allows you to filter data using complex criteria. 3. *Custom Filter*: Enables you to filter data using custom criteria. * How to Apply Filters* 1. Select the range of cells you want to filter. 2. Go to the "Data" tab. 3. Click "Filter" in the "Data Tools" group. 4. Select the column header you want to filter. 5. Choose the filter type (e.g., "Number Filters" or "Text Filters"). 6. Select the filter criteria (e.g., "Greater Than" or "Contains"). 7. Click "OK" to apply the filter . *Filter Options* 1. *Number Filters*: Filter numbers based on criteria like "Greater Than," "Less Than," or "Between." 2. *Text Filters*: Filter text based on criteria li...

  Data validation in Excel helps ensure accuracy and consistency in your data. Here's how to use it: *Types of Data Validation* 1. *Whole Number*: Restrict input to whole numbers within a specified range. 2. *Decimal*: Restrict input to decimal numbers within a specified range. 3. *Date*: Restrict input to dates within a specified range. 4. *Time*: Restrict input to times within a specified range. 5. *Text Length*: Restrict input to a specific text length. 6. *List*: Restrict input to a list of predefined values. 7. *Custom*: Create a custom formula to validate input. *How to Apply Data Validation* 1. Select the cell(s) you want to validate. 2. Go to the "Data" tab. 3. Click "Data Validation" in the "Data Tools" group. 4. Choose the validation type from the dropdown menu. 5. Set the validation criteria (e.g., minimum and maximum values). 6. Click "OK" to apply the validation. *Additional Options* 1. *Input Message*: Display a message when a u...