Pivot table

  Definition:  Text to Columns feature in MS Excel helps you split data from one column into multiple columns based on a delimiter (like a comma, space, or tab) or a fixed width. It is very useful when working with large datasets, such as splitting names, addresses, or CSV files. When to Use Text to Columns🤔? You can use Text to Columns when: ✅ You have data in a single column that needs to be separated into multiple columns. ✅ Your data is separated by commas (,), spaces, tabs, or any custom delimiter. ✅ You need to organize messy data quickly. Step-by-Step Guide to Using "Text to Columns" in Excel Example Scenario: Suppose you have the following data in Column A: You want to split First Name and Last Name into separate columns. Step 1: Select the Data 1. Open MS Excel and enter your data in Column A. 2. Select the column that contains the text you want to split. Example:  Select A2:A5 (excluding the header). Step 2: Open "Text to Columns" Wizard 1. Go to the Data...

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:

VLOOKUP is a powerful Excel function that allows you to search for a value in a table and return a corresponding value from another column. Here's the syntax and some examples: # Syntax VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) # Arguments 1. *lookup_value*: The value you want to search for. 2. *table_array*: The range of cells that contains the data you want to search. 3. *col_index_num*: The column number that contains the value you want to return. 4. *[range_lookup]*: Optional. Set to FALSE for an exact match, or TRUE for an approximate match. # Examples Suppose we have a table with employee data: | Employee ID | Name | Department | | --- | --- | --- | | 101 | John Smith | Sales | | 102 | Jane Doe | Marketing | | 103 | Bob Johnson | IT | *Example 1: Exact Match* Find the department for employee ID 102: `=VLOOKUP(102, A2:C4, 3, FALSE)` Returns: Marketing *Example 2: Approximate Match* Find the department for employee ID 104 (which doesn't exist): `=VLO...