SOME COMPUTER BASE PRODUCTIVITY TIPS FOR YOU

Computer Optimization & Productivity Tips

Computer Optimization & Productivity Tips

1. Speed Up Your Computer

Step 1: Click on Windows Start → Settings → Apps → Turn off all unnecessary apps (especially Windows Security if not needed)

Step 2: Press Windows + R, type sysdm.cpl and press Enter

Step 3: Go to the "Advanced" tab → Performance "Settings"

Step 4: Select "Adjust for best performance"

Step 5: Press Windows + R, type msconfig and press Enter

Step 6: Go to the "Boot" tab → "Advanced options"

Step 7: Check "Number of processors" and select the highest number available

Step 8: Click OK and restart your computer

Note: These changes may affect visual aesthetics for performance. Be cautious when modifying system settings.

2. Extract Text from Images

Prerequisite: Install Microsoft PowerToys (free from Microsoft Store)

Step 1: Open the image containing text

Step 2: Press Windows + Shift + T to activate Text Extractor

Step 3: Select the area containing text

Step 4: The text will be copied to clipboard automatically

Step 5: Paste (Ctrl + V) into Microsoft Word

3. Remove Spaces Between Words in Word

Step 1: Select the text where you want to remove spaces

Step 2: Press Ctrl + H to open Find and Replace

Step 3: In "Find what:" type ^w (this represents any whitespace)

Step 4: In "Replace with:" leave it empty (or type a single space if you want single spaces)

Step 5: Click "Replace All"

4. Separate Data in Excel Cells

Example: When name, address, and contact number are in one cell

Step 1: In a new cell, type: =TEXTSPLIT(

Step 2: Click on the cell containing the combined data

Step 3: Type comma separator: , ","

Step 4: Close the bracket: ) and press Enter

Result: The data will split into separate columns at each comma

Note: TEXTSPLIT is available in Excel 365 and Excel 2021. For older versions, use "Text to Columns" in the Data tab.

5. Excel Data Sorting Shortcuts

Ascending Order:

Select a cell in the column you want to sort → Press Alt + A + S + A

Descending Order:

Select a cell in the column you want to sort → Press Alt + A + S + D

Tip: These shortcuts activate the sort feature from Excel's ribbon menu without using the mouse.
Next Post Previous Post
No Comment
Add Comment
comment url
'); //]]>