Posts

Watch Window Function

Image
   Watch Window Function Here's your free trial of Copilot Pro Unlock now When cells are not visible on a worksheet, you can watch those cells and their formulas in the Watch Window toolbar. The Watch Window makes it convenient to inspect, audit, or confirm formula calculations and results in large worksheets. By using the Watch Window, you don't need to repeatedly scroll or go to different parts of your worksheet. This toolbar can be moved or docked like any other toolbar. For example, you can dock it on the bottom of the window. The toolbar keeps track of the following properties of a cell: workbook, sheet, name, cell, value, and formula. Note:  You can only have one watch per cell. Add cells to the Watch Window Important:  On a Mac, perform step 2 of this procedure before you perform step 1; that is, click  Watch Window  and then select the cells to watch. Select the cells that you want to watch. To select all cells on a worksheet with formulas, on the  Home  tab, in the  Ed

LET function

Image
  LET function Excel for Microsoft 365   Excel for Microsoft 365 for Mac   Excel for the web   Excel 2021   More... The  LET  function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the  LET  function. Similar to variables in programming,  LET  is accomplished through Excel’s native formula syntax. To use the  LET  function in Excel, you define pairs of names and associated values, and a calculation that uses them all. You must define at least one name/value pair (a variable), and  LET  supports up to 126. Benefits Improved Performance  If you write the same expression multiple times in a formula, Excel calculated that result multiple times.  LET  allows you to call the expression by name and for Excel to calculate it once. Easy Reading and Composition  No more having to remember what a specific range/cell reference referred to, what your calculation was doing or

SWITCH function

Image
 The SWITCH function  Syntax: SWITCH(expression, value1, result1, [value2, result2], ... [default_result]) How it works: 1. The function evaluates the expression and compares it to the value arguments. 2. If the expression matches a value, the function returns the corresponding result. 3. If no match is found, the function returns the default result (if provided). 4. If no default result is provided and no match is found, the function returns a #N/A error. Example: SWITCH(A1, "Red", "Apple", "Green", "Grass", "Unknown") - If cell A1 contains "Red", the function returns "Apple". - If cell A1 contains "Green", the function returns "Grass". - If cell A1 contains any other value, the function returns "Unknown". Benefits: 1. Simplifies complex IF statements. 2. Easy to read and maintain. 3. Flexible with multiple value-result pairs. Common uses: 1. Data validation and cleaning. 2. Conditional

How to fill row data by using CTRL Function

Image
  How to fill row data by using CTRL Function Step 1: Select data till bottom. ( do not select heading) Step 2: Type short key> CTRL +G Step 3: Click on the Blank option from Go To Special window and Click ok. Step 4: Type = sign and select just upper cell (as per below picture) Step 5: Press continue left CTRL button and similarly press right enter. Step 6: Copy all data and do paste special.   Thank you

Insert data from picture Through Office 365

Image
  Insert data from picture Want to turn images that have table data into data that you can edit in Excel? With the  Data from Picture  feature, it's a snap.  With the  Data from Picture  feature, you can insert data from a screen capture on your clipboard, or an image file from your computer. Important:  Only the following character sets are supported: English, Bosnian, Croatian, Czech, Danish, Dutch, Finnish, French, German, Hungarian, Italian, Norwegian, Polish, Portuguese, Romanian, Serbian, Slovak, Slovenian, Spanish, Swedish, and Turkish. Important:  Data from Picture in Excel for Windows is only supported on Windows 11 or Windows 10 version >=1903 (must have  Microsoft Edge WebView2 Runtime  installed). How it works Capture your data from an image. There are two methods: Method     Steps     Tips     Use an existing picture file     Click  Data > From Picture > Picture From File . The image should only depict the data you want to import. If necessary, crop the image.

How to Convert text from Picture through Google Drive

Image
  How to Convert text from Picture through Google Drive Step 1: Upload picture file in google drive Step2: Select picture file, do right click and open with Google Docs. Data will convert in Text form Thank you

SCAN function

Image
  SCAN function Excel for Microsoft 365   Excel for Microsoft 365 for Mac   Excel for the web Here's your free trial of Copilot Pro Unlock now Scans an array by applying a  LAMBDA  to each value and returns an array that has each intermediate value.   Syntax =SCAN ([initial_value], array, lambda(accumulator, value, body)) The SCAN function syntax has the following arguments and parameters: [initial_value]       Sets the starting value for the accumulator. array       An array to be scanned. lambda       A LAMBDA that is called to reduce the array. The LAMBDA takes three parameters: accumulator     The value totaled up and returned as the final result. value      The current value from the array. body      The calculation applied to each element in the array. Remarks Use the initial_value argument to set the starting value for the accumulator parameter. If you are working with text, set the initial value to "". Errors Providing an invalid LAMBDA function or an incorrect nu