Posts

Showing posts from January, 2025

Convert Picture to Text

Image
  Process Flow to Convert Picture to Text in Office 365 Excel Microsoft Excel in Office 365 provides a built-in feature to extract text from images using Insert Data from Picture and OneNote OCR . Below is a step-by-step process: 📌 Method 1: Using "Insert Data from Picture" (Directly in Excel) Steps: 1️⃣ Open Excel in Office 365. 2️⃣ Go to the "Data" tab. 3️⃣ Click on "Get Data" > "From Picture" > Select "From File" or "From Clipboard" (if copied). 4️⃣ Select the image containing text. 5️⃣ Excel will process and convert the image into an editable table . 6️⃣ Review & Edit the extracted data before inserting it into your sheet. 7️⃣ Click "Insert" , and the text will appear in the Excel sheet. ✅ Best for: Tables, structured data, scanned documents. Sample : 🔹 Final Notes For best results, use clear, high-resolution images with proper alignment. OCR accuracy depends on font clarity and image qualit...

IFS and SWITCH

  IFS and SWITCH Functions in Excel Both IFS and SWITCH functions help in evaluating multiple conditions and returning results based on logical tests. However, they differ in how they process conditions and their use cases. 1️⃣ IFS Function The IFS function evaluates multiple conditions one by one and returns the value corresponding to the first TRUE condition. Syntax: =IFS(condition1, result1, condition2, result2, ..., TRUE, default_result) Example: Let's say we have student scores in cell A2 , and we want to assign grades based on the following conditions: Score (A2) Grade ≥ 90 A 80 - 89 B 70 - 79 C < 70 Fail Using the IFS function , we can write: =IFS(A2>=90, "A", A2>=80, "B", A2>=70, "C", A2<70, "Fail") ✅ How it works: If A2 is 92 , it checks A2>=90 (TRUE) → Returns "A" . If A2 is 85 , A2>=90 is FALSE, so it checks A2>=80 (TRUE) → Returns "B" . If A2 is 65 , all conditions fail except A...

Sort by Color

Image
  Process Flow to Sort by Color in Excel (Based on Given Data) Sorting data by color in Excel allows you to group rows with similar formatting, making it easier to analyze. Follow these steps to sort the data based on the row colors seen in the provided dataset. Step 1: Open Your Excel File Open the Excel file containing your dataset. Ensure the table has colored rows (like blue and gray in your case). Step 2: Select the Data Range Click anywhere inside the table. If needed, manually select the entire data range including column headers (e.g., A1:H5 ). Step 3: Open the Sort Dialog Box Option 1: Using the Data Tab Go to the Data tab on the ribbon. Click on Sort (or press Alt + D + S for shortcut). Option 2: Using the Home Tab Navigate to the Home tab. Click Sort & Filter > Custom Sort . Step 4: Apply Sorting by Color In the Sort window, under the Column section, select the column based on which you want to sort (e.g., SL or Name ). Under Sort On , select Cell Color ...

Go To Special

Image
 Go To Special The "Go To Special" feature in Excel allows users to quickly select specific types of cells, such as blanks, constants, or formulas, for efficient data manipulation. It enhances productivity by streamlining tasks like data cleaning, troubleshooting, and analysis. 1. Blanks Function : Selects all blank cells in the range. Process Flow : Select the range of cells (e.g., A2:D6 ). Navigate to the Home tab, click on Find & Select . Choose Go To Special from the dropdown menu. In the dialog box, select Blanks and click OK . Action : All blank cells in the selected range will be highlighted. Example : Selecting Go To Special > Blanks highlights cells C2, B3, D4, and A5 . Next Step : Fill these blank cells with a value like N/A by typing N/A and pressing Ctrl + Enter . 2. Constants Function : Selects all cells containing constant values (numbers, text, dates). Process Flow : Select the range of cells (e.g., A2:D6 ). Go to Home > Find & Select > ...

Align Function for Shapes and Pictures

  The Align function under the Layout tab in Excel (when working with shapes, pictures, or other objects) helps you organize and position these elements precisely on the worksheet. Here’s a detailed guide specifically for shapes and pictures: _______________________________________________________________________ 1. Accessing the Align Function Select a shape or picture in your worksheet. The Picture Format or Shape Format tab appears in the ribbon. In the Arrange group, you’ll find the Align button. 2. Align Options for Shapes and Pictures Click the Align button to access the following options: Alignment Options Align Left : Aligns the selected shapes or pictures to the leftmost edge of the selection or worksheet. Align Center : Centers the selected objects horizontally relative to the group or worksheet. Align Right : Aligns the selected objects to the rightmost edge of the selection or worksheet. Align Top : Aligns the top edges of the selected objects. Align Middle : Ali...

Auto Highlight Entire Row & Cell in Excel

Auto Highlight Entire Row & Cell in Excel Objective : Highlight an entire row in Excel based on a condition using VBA. Step 1: Define the Requirement Use Conditional Formatting rule: = CELL("Row")=ROW() Step 2: Write VBA Code (in View Code) Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveCell.Calculate End Sub Observe the Result : The entire row corresponding to the selected cell will be highlighted. The row will be highlighted in yellow (or other colors based on your preference). Key Notes: The row will automatically highlight based on the condition. This process works without the need for manual intervention once the macro is run. Process Flow 2: Auto Recalculate Active Cell Objective : Recalculate the formula in the active cell using VBA. Step 1: Write the Conditional Ruling =CELL("address")=CELL("address",A1) Step 2: Process Flow Step 2: Write VBA Code (in View Code) Private Sub Worksheet_SelectionChange(ByVal Target As Range) Ac...

Difference between the DISTINCT and UNIQUE functions:

Difference between the DISTINCT and UNIQUE functions: Suppose we have a list of scores: | Name | Score | | --- | --- | | John | 90 | | Mary | 80 | | John | 90 | | David | 70 | | Mary | 80 | | Emma | 95 | We want to analyze the scores using the DISTINCT and UNIQUE functions: DISTINCT Function =DISTINCT(B2:B7) Result: | Score | | --- | | 90 | | 80 | | 70 | | 95 | The DISTINCT function returns all the unique scores. UNIQUE Function =UNIQUE(B2:B7) Result: | Score | | --- | | 70 | | 95 | The UNIQUE function returns only the scores that appear only once. In this example: - The score 90 appears twice, so it's not included in the UNIQUE result. - The score 80 appears twice, so it's not included in the UNIQUE result. - The scores 70 and 95 appear only once, so they're included in the UNIQUE result. This example shows the difference between the DISTINCT and UNIQUE functions: - DISTINCT returns all unique values. - UNIQUE returns only the values that appear only once.