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...

  What is Flash fill in MS Excel Flash Fill  is an amazing feature in Microsoft Excel that helps you automatically fill in data by recognizing patterns you start typing. Think of it as Excel's way of "thinking ahead" for you. Once you show Excel a few examples of how you want data to look, it will fill in the rest for you without you having to manually type or write any formulas. It's great for tasks like: Separating full names into first and last names Formatting phone numbers or dates Combining information from different columns into one   Step-by-Step Guide to Using Flash Fill in Excel Step 1: Open Excel and Your Data Make sure your Excel file is open, and you have the data you want to work with in the spreadsheet. Let’s say you have a column with full names (First and Last Name) that you want to split into two columns (First Name and Last Name). Step 2: Start Typing the Pattern Click on the cell next to the first piece of data (e.g., next to the full name). For ex...

  Converting text to columns is a useful technique in data analysis. Here are the steps to do it: # Using Excel 1. Select the cell range containing the text you want to split. 2. Go to the "Data" tab. 3. Click on "Text to Columns". 4. Choose "Delimited" or "Fixed Width" depending on your data. 5. Select the delimiter (e.g., comma, space, tab). 6. Click "Finish". # Using Google Sheets 1. Select the cell range containing the text you want to split. 2. Go to the "Data" menu. 3. Select "Split text to columns". 4. Choose the delimiter (e.g., comma, space, tab). 5. Click "Split". # Using Formula You can also use formulas to split text into columns: *Excel* - `=LEFT(A1,FIND(" ",A1)-1)` (splits text at the first space) - `=RIGHT(A1,LEN(A1)-FIND(" ",A1))` (splits text at the first space) - `=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1)`...

  Removing duplicate data is an essential step in data cleaning and preprocessing. Here are some methods to remove duplicate data: # Using Excel 1. *Select the data range*: Choose the cells that contain the data you want to remove duplicates from. 2. *Go to the "Data" tab*: Click on the "Data" tab in the ribbon. 3. *Click on "Remove Duplicates"*: Click on the "Remove Duplicates" button in the "Data Tools" group. 4. *Select the columns to check for duplicates*: Choose the columns you want to check for duplicates. 5. *Click "OK"*: Click "OK" to remove the duplicates. # Using Google Sheets 1. *Select the data range*: Choose the cells that contain the data you want to remove duplicates from. 2. *Go to the "Data" menu*: Click on the "Data" menu. 3. *Select "Remove duplicates"*: Choose "Remove duplicates" from the drop-down menu. 4. *Select the columns to check for duplicates*: Choos...