Posts

Assignment no. 10https://jaspreet kaur5021.blogspot.com/2025/02/assignment-10-goal-seek.html

jaspreet kaur Unit 2 Home ASSIGNMENT 10 : GOAL SEEK February 17, 2025 Goal Seek is a what-if analysis tool that uses trial and error to solve problems. It can be used in many situations, including financial modeling, sales, elections, and forecasting. STEPS FOR USING GOAL SEEK : 1.Go to the Data tab 2.Click What-If Analysis 3.Click Goal Seek 4.In the Set cell box, enter the cell that contains the formula you want to resolve 5.In the To value box, enter the result you want 6.In the By changing cell box, enter the cell that contains the value you want to adjust 7.Click OK Share Comments Popular posts from this blog Assignment no : 6 Use of flash fill February 04, 2025 Excel Flash Fill is a feature of Microsoft Excel where Excel can sense a pattern in the cell and apply the logic to extract a similar resultant pattern out of the remaining cells in the table. STEP 1. First, tell Excel what you want to do by entering the value AMA into cell E2. STEP 2. On the Data tab...
Post a Comment
Read more

Assignment no. 9 https://jaspreet kaur5021.blogspot.com/2025/02/assignment9-steps-to-reate-data-table.html

jaspreet kaur Unit 2 Home ASSIGNMENT:9 STEPS TO CREATE DATA TABLE IN EXCEL. February 17, 2025 What is a Data Table in MS Excel? Definition:- A data table in Microsoft Excel is a tool used for analyzing and organizing data. It allows you to perform what-if analysis, helping you to understand how changes in one or more variables can affect your results. Data tables are especially useful for financial models, simulations, or when you want to compare multiple scenarios using different input values. In simple terms, a data table helps you easily see how changing one thing in your data affects other things. Step-by-Step Procedure to Use Data Tables in MS Excel 1. Prepare Your Data First, have your data ready. Usually, you’ll need a formula that uses the variable you want to change. 2. Enter Your Formula Suppose you have the following values: sale: 1000 Product: 500 time: 3month 3. Set Up Your Data Table Choose an empty area where you want the data table to appear. You can...
Post a Comment
Read more

Assignment no. 8https://jaspreet kaur5021.blogspot.com/2025/02/assignment-no8-use-of-hlookup-in-excel.html

jaspreet kaur Unit 2 Home Assignment no:8 use of Hlookup in excel February 07, 2025 The HLOOKUP function in Excel is used to search for a value in the first row of a table or array and return a value in the same column from a specified row. It's particularly useful when you need to search across a horizontal row of data. HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) lookup_value: The value you want to search for. table_array: The range of cells that contains the data. row_index_num: The row number in the table array from which you want to retrieve the value. [range_lookup]: (Optional) A logical value that specifies whether you want an exact match (FALSE) or an approximate match (TRUE). The default is TRUE. Example: Let's say you have a table where the first row contains the months, and the second row contains the sales numbers. If you want to find the sales number for a specific month, you could use the HLOOKUP function. A B C D Month Jan Feb ...
Post a Comment
Read more

Assignment no. 7 https://jaspreet kaur5021.blogspot.com/2025/02/assignment-no6-use-of-vlookup-in-excel.html

jaspreet kaur Unit 2 Home Assignment no:7 use of vlookup in excel February 05, 2025 VLOOKUP in Excel is a powerful function that allows you to look up data from a table based on a given value. It searches for a value in the first column of a specified range and returns a value in the same row from a specified column. It’s particularly useful when you need to find related data quickly. Syntax of VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) lookup_value: The value you want to search for. This can be a number, text, or reference to a cell containing the value. table_array: The range of cells that contains the data you want to search through (the first column should include the lookup value). col_index_num: The column number in the table from which to retrieve the value. The first column of your table is 1, the second is 2, and so on. [range_lookup]: Optional. You can specify TRUE (approximate match) or FALSE (exact match). If omitted, the default...
Post a Comment
Read more

Assignment no. 6https://jaspreet kaur5021.blogspot.com/2025/02/assignment-no-6-use-of-flash-fill.html

jaspreet kaur Unit 2 Home Assignment no : 6 Use of flash fill February 04, 2025 Excel Flash Fill is a feature of Microsoft Excel where Excel can sense a pattern in the cell and apply the logic to extract a similar resultant pattern out of the remaining cells in the table. STEP 1. First, tell Excel what you want to do by entering the value AMA into cell E2. STEP 2. On the Data tab, in the Data Tools group, click Flash Fill , (or press CTRL + E). RESULT Share Comments Popular posts from this blog How to make pivot table January 29, 2025 Creating a pivot table is a great way to analyze and summarize data in Excel or Google Sheets. Here’s a step-by-step guide for both: In Excel : Select Your Data : Highlight the range of data you want to analyze (including headers). Insert Pivot Tabl e : Go to the Insert tab. Click on PivotTable . In the dialog box, ensure your data range is correct. You can choose to place the pivot table in a new worksheet or the existing w...
Post a Comment
Read more

Assignment no. 5 https://jaspreet kaur5021.blogspot.com/2025/01/assingnment-no5-text-in-column-width-if.html

jaspreet kaur Unit 2 Home Assingnment no:5 text in column width if else statement and formula January 31, 2025 Text to column if else statement and formula It sounds like you're looking for a way to split text into columns based on an "if-else" condition in Excel. Here's a step-by-step guide on how to accomplish this: Using IF Statement and Formulas in Excel Set Up Your Data: Suppose you have your text data in column A starting from cell A1. Create a New Column for Condition Check: In cell B1, you can use an IF formula to check a condition and return a specific value. For example, let's say we want to check if the text contains the word "Hello": excel =IF(ISNUMBER(SEARCH("Hello", A1)), "Contains Hello", "Does Not Contain Hello") Split Text into Columns: If you want to split the text into different columns based on a delimiter, you can use the TEXTSPLIT function (available in Excel 365 and later versions) or...
Post a Comment
Read more

Assignment no. 4 https://jaspreet kaur5021.blogspot.com/2025/01/assignment-no4-remove-duplicate-data.html

jaspreet kaur Unit 2 Home Assignment no:4 Remove duplicate data January 31, 2025 Remove duplicate data in ms excel The steps to remove duplicate data in Microsoft Excel: Method 1: Using the Remove Duplicates Function Select your data range: Click and drag to highlight the cells containing the data you want to clean up. Go to the Data tab: Click on the Data tab at the top of the screen. Remove Duplicates: In the Data Tools group, click Remove Duplicates. Select Columns: A dialog box will appear. Here, you can select which columns you want to check for duplicates. Click OK: Excel will remove duplicates and show you a summary of how many duplicates were found and removed. Method 2: Using Conditional Formatting : Highlight the cells you want to check for duplicates. Go to the Home tab: Click on the Home tab at the top of the screen. Conditional Formatting: In the Styles group, click Conditional Formatting. Highlight Cells Rules: Select Highlight Cells Rules > Duplica...
Post a Comment
Read more