5005 AND 22

 

  The   data table in Excel   can be used to change two variables. Users need to provide input variables. Excel returns the output based on the formula and variables given by the users. Step 1:  Create a table with various interest rates, as shown in the below image.In the NEXT cell  Step 2:  Select the newly created table. Go to the  Data . Under the Forecast group, click on the  What-If Analysis  drop-down list and choose the  Data Table . Step 4:  The  Data Table  window appears. Step 5:  In the  Row input cell:  box, we should choose the cell reference of tenure years, i.e., cell B3, since, in the newly created table, we have categorized the rows that indicate the tenure as years. Similarly, in the  Column input cell:  we should choose the cell reference of interest rates, Again, it is because we have interest rates in a column in the newly arranged data table. Click  OK , and we will get ...

USE OF HLOOKUP IN EXCEL In Excel to find and extract data from a table. By the end of these steps, you’ll be able to look up values horizontally across rows with confidence. Step 1: Open Your Excel Spreadsheet First, open your Excel spreadsheet where your data is stored. Make sure your table is well-organized with the necessary data laid out in rows. This organization is crucial for the HLOOKUP function to work correctly. Step 2: Select the Cell for the HLOOKUP Formula Choose the cell where you want the result of the HLOOKUP to appear. Click on an empty cell, which will be the destination for your lookup result. This will help you keep your data organized. Step 3: Enter the Hlookup  Formula In the selected cell, type . =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Step 4: Press Enter After entering the formula, press Enter to execute it.   OUTPUT:

  USE OF VLOOKUP IN EXCEL   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 OF VLOOKUP =VLOOKUP(lookup_value,table_array,column_index,range_lookup) STEPS: Identify which is the value that you want to use (finding the lookup value) Understand for which data to perform the VLOOKUP (selecting the table array) Select which info you wish to retrieve  Determine if you need to use an exact or approximate match (setting the match type) OUTPUT: 

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

  Convert Text to Columns in Excel Converting text to columns in Excel breaks down a single column of text into multiple columns based on specified delimiters. Follow these steps to make the process a breeze: Step 1: Select the Column First, select the column that you want to split into multiple columns. Make sure your data is highlighted. This tells Excel which text to work its magic on. If you only need part of the column, just highlight that section. Step 2: Go to the Data Tab Next, click on the "Data" tab at the top of the Excel window. The Data tab contains various tools for managing your data. "Text to Columns" is among these tools, and you’ll use it to perform the conversion. Step 3: Click on Text to Columns In the Data tab, click on "Text to Columns" to open the Convert Text to Columns Wizard. This wizard will guide you through the process of selecting your delimiters and previewing the result                       St ...